(24pt) Complete the following queries in SQL. Please put your queries in an SQL script file lab3.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.

1. List the names of all the tracks in the "alternative" genre.
2. Find the name of the artist who recorded the song "Shoes".
3. List the names of the artists and the titles of the CDs they recorded. If an artist hasn't recorded a CD yet, put "N/A" in the CD title column.
4. List the names of the members whom the salesperson Lisa Williams is in charge of.
5. List the names of the sales people who are supervised by Scott Bull.
6. Find the artist groups that are located in the same region as the studio "Pacific Rim".
7. Find out whether the song "25" and the song "Song 8 and 1/2" are on the same CD. The result should be either the name of the CD or empty (i.e. no result).
8. Find out whether the song "25" and the song "Song 8 and 1/2" are recorded by the same artist. The result should be either the name of the artist or empty (i.e. no result).
9. (extra credit) Find the artist groups that consist of only male members.