🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 63:

Experiments Started per Month

SQLite
The experiment table stores the start date of each experiment in started (text in the form YYYY-MM-DD). For every month from January 2023 to February 2024 inclusive show how many experiments started, including the months without new experiments.
Output columns: year, month (numbers) and experiments (0 for a month without experiments). Sort by year and month.
Expected result Columns: 3 · Rows: 14
year month experiments

Sample rows open after wrong checks: 0 of 2

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query