Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SSQLITE customers playlists Playlist NTEGER Name NVARCHAR20 TUTORIAL Customer NIEDER Invoice ATETUE playlist track Ring NVARCHA media Types MediaType R Name NARCHARI120 Om Fusame VARCHAR
SSQLITE customers playlists Playlist NTEGER Name NVARCHAR20 TUTORIAL Customer NIEDER Invoice ATETUE playlist track Ring NVARCHA media Types MediaType R Name NARCHARI120 Om Fusame VARCHAR Lasname VARCHARG Company NVARCHARD A NVARCHUR CtNVARCHAR State NARD County WARCHARD Postal Code NARCHARD Phone VARCHAR Fax NVARCHAR24 Em NVARCHAR 30) Support MTEGER invites tracks genres U Price NUMERO QuartNTEGER Name NVARCHAR Albumid INTEGER MediaType NTEGER Garn GIR Com VARCHAR Mecords IER Name NVARCHARE1200 U Price NUMERIC The NVARCHARI NTEGER Lastame VARCHAR FirstName VARCHAR20 TONARCHIARO ReportsTONTECER ATETUS Hurt CATETE NVARCHARG) A B Artistid NTE Name NVARCHAR20 A Using the Chinook database described in the data model above, select the query below that will correctly answer this request: Create a list of Artists, sorted by Name, showing all artists who have NO albums. (assume you are running on a computer where all commands and objects are case insensitive) Select one: Select Name From artists Where Artistid in Select Artistid from albums); Select Name From artists a left outer join albums b on a.artistid = b.artistid where albumid is null; Where albumu 15 Hull; Select Name From artists a right outer join albums b on a.artistid = b.artistid where albumid is null; d. Select Name From artists a, albums b where a.artistid = b.artistid and albumid is null; Select Name From artists a, albums b Where albumid is null; SSQLITE playlists Playlistid INTEGER Name NVARCHAR(120) TUTORIAL invoices Invoiceld INTEGER Customerld. INTEGER InvoiceDateDATETIME Billing Address NVAR BillingCity NVARCHA 4 more columns. playlist_track 9 Playlistid. INTEGER Trackid INTEGER customers Customerid INTEGER FirstName: NVARCHAR(40) LastName: NVARCHAR(20) Company NVARCHAR(80) Address: NVARCHAR(70) City NVARCHAR(40) State NVARCHAR(40) Country NVARCHAR(40) PostalCode: NVARCHAR(10) Phone NVARCHAR(24) Fax: NVARCHAR(24) Email: NVARCHAR(60) SupportRepld INTEGER media_types MediaTypeld INTEGER Name NVARCHAR(120) tracks invoice_items Invoiceltemld INTEGER Invoiceld. INTEGER Trackld INTEGER UnitPrice NUMERIC Quantity INTEGER genres 9 Genreld INTEGER Name: NVARCHAR(120) Trackld. INTEGER Name: NVARCHAR(200) Albumid: INTEGER MediaTypeld: INTEGER Genreld. INTEGER Composer: NVARCHAR(220) Milliseconds INTEGER Bytes. INTEGER UnitPrice NUMERIC albums Albumid INTEGER Title: NVARCHAR(160) Artistid INTEGER employees Employeeld. INTEGER LastName: NVARCHAR(20) FirstName: NVARCHAR(20) Title: NVARCHAR(30) ReportsTO INTEGER Birth DateDATETIME HireDate: DATETIME Address: NVARCHAR(70) 7 more columns artists Artistid INTEGER Name: NVARCHAR(120)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started