Using the ERD above, formulate queries to satisfy the following questions. Do not include NULL values.: What are the last names and emails of all customer who made purchases in the store? What are the names of each albums and the artist who created it? What are the total number of unique customers for each state, ordered alphabetically by state? Which states have more than 10 unique customers? What are the names of the artists who made an album containing the substring "symphony" in the album title? What are the names of all artists who performed MPEG (video or audio) tracks in either the "Brazilian Music" or the "Grunge" playlists? How many artists published at least 10 MPEG tracks? What is the total length of each playlist in hours? List the playlist id and name of only those playlists that are longer than 2 hours, along with the length in hours rounded to two decimals. playlistsPlaylistid: INTEGERName: NVARCHAR(120)invoicescustomersO Invoiceid: INTEGERO Customerid: INTEGERCustomerid: INTEGERInvoiceDate: DATETIMEBillingAddress: NVAR.BillingCity: NVARCHA.4 more columns.FirstName: NVARCHAR(40)LastName: NVARCHAR(20)Company: NVARCHAR(80)Address: NVARCHAR(70)playlist_trackCity: NVARCHAR(40)State: NVARCHAR(40)Country: NVARCHAR(40)PostalCode: NVARCHAR(10)Phone: NVARCHAR(24)Fax: NVARCHAR(24)Email: NVARCHAR(60)Playlistid: INTEGERTrackd: INTEGERmedia_typesMediaTypeld: INTEGERName: NVARCHAR(120)invoice_itemstracksInvoiceltemid: INTEGERTrackld: INTEGERName: NVARCHAR(200)Invoiceld: INTEGERTrackdd: INTEGERSupportRepid: INTEGERAlbumid: INTEGERUnitPrice: NUMERICgenresQuantity: INTEGERGenreld: INTEGERName: NVARCHAR(120)MediaTypeld: INTEGERGenreld: INTEGERComposer: NVARCHAR(220)employeesEmployeeld: INTEGERLastName: NVARCHAR(20)FirstName: NVARCHAR(20)Title: NVARCHAR(30)Milliseconds: INTEGERBytes: INTEGERalbumsAlbumid: INTEGERTitle: NVARCHAR(160)Artistid: INTEGERUnitPrice: NUMERICReportsTo: INTEGERBirthDate: DATETIMEHireDate: DATETIMEartistsArtistid: INTEGERAddress: NVARCHAR(70)Name: NVARCHAR(120)7 more columns.

1. To print all the lastnames and emails only select statement is enough. 2. Here names of artists…

Answered: ng the ERD above, formulate queries to…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Using the ERD above, formulate queries to satisfy the following questions. Do not include NULL values.:

What are the last names and emails of all customer who made purchases in the store?
What are the names of each albums and the artist who created it?
What are the total number of unique customers for each state, ordered alphabetically by state?
Which states have more than 10 unique customers?
What are the names of the artists who made an album containing the substring "symphony" in the album title?
What are the names of all artists who performed MPEG (video or audio) tracks in either the "Brazilian Music" or the "Grunge" playlists?
How many artists published at least 10 MPEG tracks?
What is the total length of each playlist in hours? List the playlist id and name of only those playlists that are longer than 2 hours, along with the length in hours rounded to two decimals.