560 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
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
This will generate the database that you'll need to use in order to do this exercise (note that the database and script are only to be used for exercises published on this website, and may not be reused or distributed in any form without the prior written permission of Wise Owl).
Create a query which uses an inner join to link the categories table to the events table (they share a column/field called CategoryId):
The first few of the 459 events in reverse date order. We weren't sure of the correct category for the first one.
Change the inner join to an outer join, so that you show for each category its events - even when there aren't any:
If you scroll down to the bottom of your query, you'll see you now have a couple of extra rows, making 461 in total.
Add a WHERE clause to show only those categories which don't have any corresponding events:
It seems unlikely they'll be any events for the first category, but you never know ...
Save this query as Empty categories, then close it down.
25 Aytoun Street