575 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
This page lists the 8 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. |
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. |
Software: | SQL |
Topic: | Aggregation and grouping |
Level: | Relatively easy |
Exercise: | Use grouping to show how many episodes each Doctor Who author wrote. |
Software: | SQL |
Topic: | Aggregation and grouping |
Level: | Average difficulty |
Exercise: | Group by 2 fields and use HAVING clause to show popular combinations. |
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. |
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. |
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. |
Software: | SQL |
Topic: | Aggregation and grouping |
Level: | Harder than average |
Exercise: | Use lots of grouping and criteria to list out year/doctor episode counts. |
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!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.