Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Only write sql queries ASAP Question 5: Show the number of customers assigned to each of the employees. Question 6: From the invoices, show which

Only write sql queries ASAP

Question 5:

Show the number of customers assigned to each of the employees.

Question 6:

From the invoices, show which country's customers spent the most on the tracks.

Question 7:

Show the top 3 artists based on their track sales.

Question 8:

Show the track name names, album name, artist name and genre of all the artist whose names contains last letter from your artist name.

image text in transcribed

Artist Album Track 3-00 00 Artistid Name Albumid Title Artistid Media Type A MediaTypeid Name Genre 3-001 Trackid Name Albumid MediaTypeid Genreid Composer Milliseconds CO Bytes UnitPrice Playlist 00 -3-00 PlaylistTrack Playlistid Trackid Genreld Name 7 Playlistid Name InvoiceLine InvoiceLineid Invoiceld TrackId UnitPrice Quantity Customer Invoice Employee Employeeld LastName FirstName Title ReportsTo BirthDate HireDate Address City State Country PostalCode Phone Fax Email 300 Customerid FirstName LastName Company Address City State Country PostalCode Phone Fax Email SupportRepid Invoiceld Customerid InvoiceDate BillingAddress Billing City BillingState Billing Country BillingPostalCode Total -0-00

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

Recommended Textbook for

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

More Books

Students also viewed these Databases questions

Question

What is the Definition for Third Normal Form?

Answered: 1 week ago

Question

Provide two examples of a One-To-Many relationship.

Answered: 1 week ago