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

• Chapter 4, p. 93, Exercise 1,2,4,6,9,10.
• List the tracks by The Nerotics which are longer than 4 minutes.
• List the name(s) of the members of The Bullets.
• Find the genres of the titles produced by the studio Long Star Recording.
• Find the artist group(s) that have members in both USA and Canada.