Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Help plz image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

oard ses ndar D 2 b OX 1 ory 3 4 5 1 1 point Identify the cell

Answered: 1 week ago

Question

LO2 Compare three types of individual incentives.

Answered: 1 week ago