Microsoft SQL training exercises | Aggregation and grouping

Showing exercises 1-6 (out of 6)

Category: SQL
Topic: Aggregation and grouping
Level: Relatively easy
Course: Introduction to SQL
Exercise: Create an SQL query showing the count of events for each country, showing the use of GROUP BY.

Go to exercise ...

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

Go to exercise ...

Category: SQL
Topic: Aggregation and grouping
Level: Average difficulty
Course: Introduction to SQL
Exercise: Create an SQL query to show the number of events taking place for each country, using a WHERE and a HAVING clause to filter data.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Category: SQL
Topic: Aggregation and grouping
Level: Harder than average
Course: Introduction to SQL
Exercise: Create a T-SQL query to list events by decade - combining the use of a GROUP BY clause with a CASE statement.

Go to exercise ...

This page has 0 threads Add post