(30pt) Complete the following queries in SQL. Please put your queries in an SQL script file lab5.sql. and upload it to CSNS at the end of the lab. Note that file uploading will be disabled automatically after 4:00pm, and late submission will not be accepted.

1. Chapter 3, p.65, Exercise 1-5, 7, 8.
2. Chapter 4, p.93, Exercise 3, 7, 8.
3. Chapter 5, p.139, Exercise 5.