I need help with this exercise SQLITETUTORIALmedia_typesMediaTypeld: INTEGERName: NVARCHAR(120)genresGenreld: INTEGERName: NVARCHAR(120)44playlistsPlaylistid: INTEGERName: NVARCHAR(120)playlist_trackPlaylistid: INTEGERTrackid: INTEGERtracksTrackid: INTEGERName: NVARCHAR(200)Albumid: INTEGERMediaTypeld: INTEGERGenreld: INTEGERComposer: NVARCHAR(220)Milliseconds INTEGERBytes: INTEGERUnitPrice: NUMERICartistsArtistid: INTEGERName: NVARCHAR(120)invoicesInvoiceld: INTEGERCustomerld: INTEGERInvoiceDate: DATETIMEBillingAddress: NVAR...BillingCity NVARCHA4 more columns...invoice_itemsInvoiceltemid: INTEGERInvoiceld: INTEGERTrackid INTEGERUnitPrice: NUMERICQuantity: INTEGERalbumsAlbumid: INTEGERTitle: NVARCHAR(160)Artistd: INTEGERcustomersCustomerid INTEGERFirstName: 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)SupportRepid: INTEGERemployeesEmployeeld: INTEGERLastName: NVARCHAR(20)FirstName: NVARCHAR(20)Title: NVARCHAR(30)Reports To: INTEGERBirthDate: DATETIMEHireDate: DATETIMEAddress: NVARCHAR(70)7 more columns.....You have to run them in certain order in order to create the database (why?)1. Write a SQL query to find all the tracks that have a length of 5,000,000 milliseconds or more.2. Write a SQL query to find all the invoices whose total is between $5 and $15 dollars3. Write a SQL query to find all the customers from the following States: RJ, DF, AB, BC, CA, WA, NY.4. Write a SQL query to find all the invoices for customer 56 and 58 where the total was between $1.00and $5.00.5. Write a SQL query to find all the tracks whose name starts with 'All'.6. Write a SQL query to find all the customer emails that start with "J" and are from gmail.com.7. Write a SQL query to find all the invoices from the billing city Brasília, Edmonton, and Vancouver andsort in descending order by invoice ID.8. Write a SQL query to show the number of orders placed by each customer (hint: this is found in theinvoices table) and sort the result by the number of orders in descending order.9. Write a SQL query to find the albums with 12 or more tracks.10. Write a SQL code to find how many albums does the artist Led Zeppelin have.11. Create a list of album titles and the unit prices for the artist "Audioslave".12. Find the first and last name of any customer who does not have an invoice. Are there any customersreturned from the query?13. Find the total price for each album. 14. How many records are created when you apply a Cartesian join (Cross join) to the invoice andinvoice items table?1. The following diagram is a depiction of what type of join?a.Inner Joinb. Full outer joinC. Left joind. Right join16. Select which of the following statements are true regarding inner joins. (Select all that apply)a. There is no limit to the number of table you can join with an inner join.b.Performance will most likely worsen with the more joins you makeInner joins retrieve all matching and nonmatching rows from a tabled. Inner joins are one of the most popular types of joins use17. Which of the following is true regarding Aliases? (Select all that apply.)a. Aliases are often used to make column names more readableb.SQL aliases are used to give a table, or a column in a table, a temporary name.An alias only exists for the duration of the query.18. What is wrong with the following query?SELECT Customers.CustomerName, Orders.OrderIDFROM LEFT JOIN ON Customers.CustomerID = Orders.CustomerID FROM Orders AND CustomersORDER BYCustomerName;19. Write a query to find the total number of invoices for each customer along with the customer's fullname, city and email.20. Write a query to retrieve the track name, album, artistID, and trackID for all the albums.C.table1C.table2

Question

I need help with this exercise SQLITETUTORIALmedia_typesMediaTypeld: INTEGERName: NVARCHAR(120)genresGenreld: INTEGERName: NVARCHAR(120)44playlistsPlaylistid: INTEGERName: NVARCHAR(120)playlist_trackPlaylistid: INTEGERTrackid: INTEGERtracksTrackid: INTEGERName: NVARCHAR(200)Albumid: INTEGERMediaTypeld: INTEGERGenreld: INTEGERComposer: NVARCHAR(220)Milliseconds INTEGERBytes: INTEGERUnitPrice: NUMERICartistsArtistid: INTEGERName: NVARCHAR(120)invoicesInvoiceld: INTEGERCustomerld: INTEGERInvoiceDate: DATETIMEBillingAddress: NVAR...BillingCity NVARCHA4 more columns...invoice_itemsInvoiceltemid: INTEGERInvoiceld: INTEGERTrackid INTEGERUnitPrice: NUMERICQuantity: INTEGERalbumsAlbumid: INTEGERTitle: NVARCHAR(160)Artistd: INTEGERcustomersCustomerid INTEGERFirstName: 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)SupportRepid: INTEGERemployeesEmployeeld: INTEGERLastName: NVARCHAR(20)FirstName: NVARCHAR(20)Title: NVARCHAR(30)Reports To: INTEGERBirthDate: DATETIMEHireDate: DATETIMEAddress: NVARCHAR(70)7 more columns.....You have to run them in certain order in order to create the database (why?)1. Write a SQL query to find all the tracks that have a length of 5,000,000 milliseconds or more.2. Write a SQL query to find all the invoices whose total is between $5 and $15 dollars3. Write a SQL query to find all the customers from the following States: RJ, DF, AB, BC, CA, WA, NY.4. Write a SQL query to find all the invoices for customer 56 and 58 where the total was between $1.00and $5.00.5. Write a SQL query to find all the tracks whose name starts with 'All'.6. Write a SQL query to find all the customer emails that start with &#34;J&#34; and are from gmail.com.7. Write a SQL query to find all the invoices from the billing city Brasília, Edmonton, and Vancouver andsort in descending order by invoice ID.8. Write a SQL query to show the number of orders placed by each customer (hint: this is found in theinvoices table) and sort the result by the number of orders in descending order.9. Write a SQL query to find the albums with 12 or more tracks.10. Write a SQL code to find how many albums does the artist Led Zeppelin have.11. Create a list of album titles and the unit prices for the artist &#34;Audioslave&#34;.12. Find the first and last name of any customer who does not have an invoice. Are there any customersreturned from the query?13. Find the total price for each album. 14. How many records are created when you apply a Cartesian join (Cross join) to the invoice andinvoice items table?1. The following diagram is a depiction of what type of join?a.Inner Joinb. Full outer joinC. Left joind. Right join16. Select which of the following statements are true regarding inner joins. (Select all that apply)a. There is no limit to the number of table you can join with an inner join.b.Performance will most likely worsen with the more joins you makeInner joins retrieve all matching and nonmatching rows from a tabled. Inner joins are one of the most popular types of joins use17. Which of the following is true regarding Aliases? (Select all that apply.)a. Aliases are often used to make column names more readableb.SQL aliases are used to give a table, or a column in a table, a temporary name.An alias only exists for the duration of the query.18. What is wrong with the following query?SELECT Customers.CustomerName, Orders.OrderIDFROM LEFT JOIN ON Customers.CustomerID = Orders.CustomerID FROM Orders AND CustomersORDER BYCustomerName;19. Write a query to find the total number of invoices for each customer along with the customer's fullname, city and email.20. Write a query to retrieve the track name, album, artistID, and trackID for all the albums.C.table1C.table2

Accepted Answer

As per our company guidelines, we are not supposed to answer more than three subparts per post and…

1. Write a SQL query to find all the tracks that have a length of 5,000,000 milliseconds or more. 2. Write a SQL query to find all the invoices whose total is between $5 and $15 dollars 3. Write a SQL query to find all the customers from the following States: RJ, DF, AB, BC, CA, WA, NY.