SQL Inclass exercise #2
Dear Students
I have attached a copy of the assignment as well as the solution. The solution gives the queries for the first 4 queries (that you can use for reference) and then an explanation on how to work out the other solutions (as well as what the query should return if it is written correctly). Please try them (and follow the description of how to work through it if you have problems). Try out as many of them – If you have any questions feel free to email me a copy of you query (or I would prefer it if you came to my office hour instead). Ill post the solution after the class on Thursday. MySQL will also try and point out what is wrong so that is occasionally helpful
In-Class Exercise #5 – SQL Out
In-Class Exercise #5 – SQL Out [KEY]
In-Class-Exercise-5-SQL-complete-Out-KEY
Best of luck
Kartik
Edit: The Movie schema and the solution have been uploaded as well.