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.
In Management Studio, open and execute the SQL script in the above folder to generate an empty table called WeirdStats. Your mission is to fill this from the Excel workbook of shopping purchases to get this:
For posh shops (Marks and Spencer and Waitrose), show the single most expensive purchase; for cheap shops (Aldi) show the single cheapest purchase; otherwise show the average purchase value.
The table should also show which statistic you've chosen to display, as well as the number of purchases made in that store.
If you're feeling confident, try doing this without reading on to see a suggested flow diagram.
Here's one possible way to solve this:
One possible answer (but not necessarily the best one!).
When you've got this working, close down the package.
25 Aytoun Street