Help plz
Bookmarks Window Help b77% )- Mon 12:28 PM Luis Lopez a GitHub, Inc. cs1222-fall-2017/lab2.md at master csula/cs 1222-fall-2017 GitHub 1. Report the names of all artists that came from e-mail that have not recorded a citle. Use JOIN to answer this question. 2. Each member is given his or her salesperson as a primary contact name and also the name of that salesperson's supervisor as a secondary contact name. Produce a list of member names and the primary and secondary contacts for each. 3. List the names of members in the 'Highlander. 4. List each title from the Title table along with the name of the studio where it was recorded, the name of the artist, and the number of tracks on the title. 5. List all genres from the Genre table that are not represented in the Titles table 6. List every genre from the Genre table and the names of any titles in that genre if any. For any genres without titles, display 'No Titles' in the Title column 7. Report the studio name and the last name of each studio contact. Hint: the last name is the part that follows the space 8. Report the longest track title. 9. Redo Q6 using CASE. 10. Report the artist name and the age in years of the responsible member for each artist at the time of that artist's entry date. http://104.131.155.18:8000/lab-22 Bookmarks Window Help b77% )- Mon 12:28 PM Luis Lopez a GitHub, Inc. cs1222-fall-2017/lab2.md at master csula/cs 1222-fall-2017 GitHub 1. Report the names of all artists that came from e-mail that have not recorded a citle. Use JOIN to answer this question. 2. Each member is given his or her salesperson as a primary contact name and also the name of that salesperson's supervisor as a secondary contact name. Produce a list of member names and the primary and secondary contacts for each. 3. List the names of members in the 'Highlander. 4. List each title from the Title table along with the name of the studio where it was recorded, the name of the artist, and the number of tracks on the title. 5. List all genres from the Genre table that are not represented in the Titles table 6. List every genre from the Genre table and the names of any titles in that genre if any. For any genres without titles, display 'No Titles' in the Title column 7. Report the studio name and the last name of each studio contact. Hint: the last name is the part that follows the space 8. Report the longest track title. 9. Redo Q6 using CASE. 10. Report the artist name and the age in years of the responsible member for each artist at the time of that artist's entry date. http://104.131.155.18:8000/lab-22