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

Subcategories count

SQL Server 2022
In the previous task you found a list of root categories. This time, find the number of subcategories in each of them.
Form a resulting table with columns corresponding to the names of the root categories in alphabetical order and one row of data containing the number of subcategories in each of them.
Expected result Columns: 4 · Rows: 1
Accessories Bikes Clothing Components

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