79279157

Date: 2024-12-13 17:45:27
Score: 1
Natty:
Report link

SELECT date, (SELECT COUNT(id) FROM tour WHERE tour.start_date <= day.date AND tour.end_date >= day.date) AS numberOfTours FROM day WHERE date > '2025-07-01' AND date < '2025-07-31' ORDER BY date;

quite easy :)

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: PhilippG