SQL QueriesSpecify the following SQLite queries on the chinook database. A schema for the database is in the picture.You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine. SQLite is already installed on labnet machines.You must submit typed queries, not handwritten ones, and save them in a .pdf document. There is no need to submit the output (results).Each query is worth 1 mark, but some are more difficult than others. Queries to Specify5. List the customer id, last name and email address of all customers with a Yahoo or Hotmail email address.6. List the album id and number of tracks for all albums with 15, 16 or 17 tracks, in descending order of the number of tracks.7. Find the maximum track length in milliseconds.8. List the last name, first name and hire date of all employees born in 1961 to 1969 inclusive9. List the genre name and count of all tracks in each genre, in descending order of track count (so the genre with the most tracks is listed first)10. List the customer id, customer's last name, customer email and support rep's last name for all customers who live in Canada. SSQLITEplaylists9 Playlistid: INTEGERName: NVARCHAR(120)invoicescustomersCustomerld: INTEGERFirstName: NVARCHAR(40)LastName: NVARCHAR(20)TUTORIALInvoiceld: INTEGERCustomerld: INTEGERInvoiceDate: DATETIMEBillingAddress: NVAR.BillingCity: NVARCHACompany: 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: INTEGERplaylist_trackPlaylistid: INTEGERTrackld: INTEGER4 more columns..media_types9 MediaTypeld: INTEGER HName: NVARCHAR(120)invoice_itemstracksInvoiceltemid: INTEGER4 9 Trackld: INTEGERName: NVARCHAR(200)Invoiceld: INTEGERTrackld: INTEGERUnitPrice: NUMERICQuantity: INTEGERAlbumld: INTEGERgenres9 Genreld: INTEGERName: NVARCHAR(120)MediaTypeld: INTEGERGenreld: INTEGERComposer: NVARCHAR(220)employees9 Employeeld: INTEGERLastName: NVARCHAR(20)FirstName: NVARCHAR(20)Title: NVARCHAR(30)ReportsTo: INTEGERBirthDate: DATETIMEMilliseconds: INTEGERBytes: INTEGERalbums9 Albumld: INTEGERTitle: NVARCHAR(160)Artistid: INTEGERUnitPrice: NUMERICartistsHireDate: DATETIME9 Artistid: INTEGERAddress: NVARCHAR(70)7 more columns..Name: NVARCHAR(120)

SQL Queries Specify the following SQLite queries on the chinook database. A schema for the database is in the picture. You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine. SQLite is already installed on labnet machines. You must submit typed queries, not handwritten ones, and save them in a .pdf document. There is no need to submit the output (results). Each query is worth 1 mark, but some are more difficult than others. Queries to Specify 5. List the customer id, last name and email address of all customers with a Yahoo or Hotmail email address. 6. List the album id and number of tracks for all albums with 15, 16 or 17 tracks, in descending order of the number of tracks. 7. Find the maximum track length in milliseconds. 8. List the last name, first name and hire date of all employees born in 1961 to 1969 inclusive 9. List the genre name and count of all tracks in each genre, in descending order of track count (so the genre with the most tracks is listed first) 10. List the customer id, customer's last name, customer email and support rep's last name for all customers who live in Canada.

Computer Networking: A Top-Down Approach (7th Edition)

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...

See similar textbooks

SQL Queries

Specify the following SQLite queries on the chinook database. A schema for the database is in the picture.

You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine. SQLite is already installed on labnet machines.

You must submit typed queries, not handwritten ones, and save them in a .pdf document. There is no need to submit the output (results).

Each query is worth 1 mark, but some are more difficult than others.

Queries to Specify

5. List the customer id, last name and email address of all customers with a Yahoo or Hotmail email address.

6. List the album id and number of tracks for all albums with 15, 16 or 17 tracks, in descending order of the number of tracks.

7. Find the maximum track length in milliseconds.

8. List the last name, first name and hire date of all employees born in 1961 to 1969 inclusive

9. List the genre name and count of all tracks in each genre, in descending order of track count (so the genre with the most tracks is listed first)

10. List the customer id, customer's last name, customer email and support rep's last name for all customers who live in Canada.