Question

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

1. Find the media type which has 100 or more tracks. Print the name of such media type. Number of rows returned in the result = 3

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

A) Find the playlists which have one or more tracks that have never been purchased in California (CA). Print the Id, and the name of such playlists. Number of rows returned in the result = 18

B) Find the customers who have invoice total greater than the average invoice total. Print the first and last name, postal code, and invoice total of such customers. Number of rows returned in the result = 179

C) Find the employees to whom at least two other employee reports to. Print the Id, and first and last name of such employees. Number of rows returned in the result = 3

Answer 1