SQL exercises on AGGREGATION AND GROUPING

This page lists the 12 exercises about Aggregation and grouping in SQL on our website:

Software:	SQL
Topic:	Aggregation and grouping
Level:	Relatively easy
Exercise:	Use COUNT, MAX and MIN to show statistics about the rows in the events table.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Relatively easy
Exercise:	Use GROUP BY and COUNT to report on the number of events for each category.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Relatively easy
Exercise:	Use grouping to show how many episodes each Doctor Who author wrote.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Relatively easy
Exercise:	Use SQL queries to group a list of music artists and create statistics related to their albums.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Relatively easy
Exercise:	Use the GROUP BY clause in SQL queries to calculate aggregated values for a list of music artists.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Average difficulty
Exercise:	Group by 2 fields and use HAVING clause to show popular combinations.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Average difficulty
Exercise:	Use SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY to list non-European busy countries.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Average difficulty
Exercise:	Write SQL queries to group concerts by multiple different geographic columns and create basic aggregations.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Harder than average
Exercise:	Combine CAST, AVG, COUNT, LEN, UPPER and LEFT to show the average length of event names by category initial.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Harder than average
Exercise:	Use a complex CASE statement to show the number of events for each century, including the CUBE function.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Harder than average
Exercise:	Use lots of grouping and criteria to list out year/doctor episode counts.

Show this exercise

Software:	SQL
Topic:	Aggregation and grouping
Level:	Harder than average
Exercise:	Use SQL queries to group a list of albums by multiple columns and create subtotals for the groups.

Show this exercise

You can search our full list of SQL exercises here. Or why not learn to do them the right way on one of our SQL training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post