🙏 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 61:

Find the distribution of customer activity

MySQL
Count the number of films rented depending on the day of the week.
Write a query that returns a table of two columns dow (day of week - the ordinal number of the day of the week starting with 1 - Sunday to 7 - Saturday) and rentals_count (the number of films rented this day) sorted in descending order of quantity
Expected result Columns: 2 · Rows: 7
dow rentals_count

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