Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the database: Write SQL queries for each of the questions below. 1) Find the playlists which have one or more tracks that have never

Using the database: Write SQL queries for each of the questions below.

image text in transcribed1) Find the playlists which have one or more tracks that have never been purchased. Print the Id, and the name of such playlists. Number of rows returned in the result = 14

A) Find the playlists where the composer is not specified for 10 or more tracks. Print the Id, and the name of such playlists. Number of rows returned in the result = 6

B) Find the playlists where all the tracks are by the same composer. Print the Id, and the name of such playlists. Number of rows returned in the result = 1 (4 is acceptable too)

TEE Track Trackld T Album Artist Artistld Name MediaType MediaTypeld Name Tite Artistld Albumld MediaTypeld Genreld Composer Milliseconds Genre Genreld Name Playlist Playlistd Name PlaylistTrack Playlistic Trackld Bytes UnitPrice Employee Employeeld LastName FirstName InvoiceLine InvoiceLineld Invoiceld Trackld UnitPrice Quantity Customer Customerld FirstName LastName Company Address ReportsTo BirthDate HireDate Address City State Country PostalCode Phone Fax Email Invoice Invoiceld Customerld InvoiceDate illingAddress BillingCity BillingState BillingCountry State Country PostalCode Fax SupportRepld Total

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: 3

blur-text-image

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