Main Lab – I covered a number of Summary functions that created aggregate data results. I want you to come up with 3 Summary queries that operate on the database you created for your company.
I do not care which ones you use, but they should not be trivial (In other words I want you to spend enough time to come up with useful queries), you can use the internet for query ideas
Hybrid Assignment – One good Sub query and one good CTE
In the class we talked about how to do sub queries and CTE’s. I want you to create one of each for your company database.
Once again I do not want a trivial query, Use internet resources (or the book) to give you ideas, for example:
https://www.youtube.com/watch?v=K1WeoKxLZ5o