Question

Hi i need Help. i use MYSQL command line.

Artist << Track सा --00 9-001 3 Artistid Name 5. Album Albumid Title Artistid MediaType A 100-MediaTypeid Name Genre TrackId Name Albumid MediaTypeid Genreid Composer Milliseconds Bytes UnitPrice 007 Genreld 3-00 Playlist 7 Playlistid Name PlaylistTrack Playlistid 7 TrackId Name InvoiceLine Invoicelineid Invoiceld TrackId UnitPrice Quantity | Employee Employeeld LastName FirstName Title ReportsTo BirthDate HireDate Address City State Country PostalCode Phone Fax Email 200 Customer Customerid FirstName LastName Company Address City State Country PostalCode Phone Fax Email SupportRepid Invoice 7 Invoiceld Customer Id InvoiceDate BillingAddress BillingCity BillingState Billing Country BillingPostalCode

THE QUESTION ARE BELOW

please check the answer before you submit because sometimes query gives error thank you

For Full database of SQL you can DOWNLOAD from this link:

https://drive.google.com/file/d/1xh1TcBfMtvKoxvJr7Csgnts68fF53Q1t/view?usp=sharing

-------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------

What are the total sales for each year. Note that you will need to use the YEAR function. Order by year with the newest year first.

-------------------------------------------------------

How many employees have no customers?

------------------------------------------------------------------

List the total sales for each genre. Display the genre with the most sales first and the genre's in alphabetical order.

-------------------------------------------------------------------------------------

Which artist has generated the most sales in dollars? You CANNOT use the LIMIT keyword.

----------------------------------------------------------------------

List the playlist with the most tracks (songs) including how many tracks are included in the playlist. You CANNOT use the LIMIT keyword.

------------------------------------------------------------------------------------------

Answer 1

Query 1

Select Year(InvoiceDate) as Year,sum(total) as "Total Sales" from Invoice group by Year(InvoiceDate) Order by Year(InvoiceDate) desc;

Showing rows 0 - 4 (5 total, Query took 0.0028 seconds.) Select Year(InvoiceDate) as Year, sum(total) as "Total Sales" from Invoice group by Year(InvoiceDate) Order by Year(InvoiceDate) desc Profiling [Edit inline] [Edit][ Show all Number of rows: 25 Filter rows: Search this table Sort by key: None + Options Year Total Sales 2013 450.58 2012 477.53 2011 469.58 2010 481.45 2009 449.46 O Show all Number of rows: 25 Filter Final output Query results operations Print 3c Copy to clipboard Export Il Display chart | Bookmark this SQL query

Query 2:

Select EmployeeId,LastName,FirstName from Employee where EmployeeId not in(Select SupportRepId from Customer);

Server 127.0.0.1 >> Database: cd > Table Employee Browse Structure L SQL Search * Insert Export Import 3 Privileges Operations Tracking 28 Triggers Show query box Showing rows 0 - 4 (5 total, Query took 0.0030 seconds.) Select EmployeeId, LastName, FirstName from Employee where EmployeeId not in(Select SupportRepId from Customer) Profiling (Edit inline] ( Edit ] [Explain SQL][ Create PH O Show all Number of rows: 25 Filter rows Search this table Sort by key None + Options Employeeld LastName FirstName Delete 1 Adams Andrew Delete 2 Edwards Nancy Edit 12 Copy Edit Copy Edit : Copy Edit 0 Copy Edit - Copy Delete 6 Mitchell Michael Delete 7 King Robert Delete 8 Callahan Laura Output2 O Check all With selected: Edit 3. Copy Delete Export Show all Number of rows: 25 Filter rows Search this table Sort by key None

Query 3:
Select Genre.Name as Genre,sum(UnitPrice) as "Total Sales" from Genre inner join Track on Genre.GenreId=Track.GenreId group by Genre.Name order by sum(UnitPrice) desc;

Showing rows 0 - 24 (25 total, Query took 0.0076 seconds.) Select Genre.Name as Genre, sum(UnitPrice) as "Total Sales" from Genre inner join Track on Genre. GenreId=Track. GenreId group by Genre.Name order by sum(UnitPrice) desc Profiling [Edit inline] [Edit] [ Show all Number of rows: 25 Filter rows: Search this table Sort by key: None + Options Genre Rock Latin Metal Alternative & Punk TV Shows Jazz Drama Blues Classical R&B/Soul Reggae Sci Fi & Fantasy Pop Soundtrack Alternative Hip Hop/Rap Comedy Electronica/Dance World Heavy Metal Science Fiction Easy Listening Bossa Nova Rock And Roll Opera Total Sales 1284.03 573.21 370.26 328.68 185.07 128.70 127.36 80.19 73.26 60.39 57.42 51.74 47.52 42.57 39.60 34.65 33.83 29.70 27.72 27.72 25.87 23.76 14.85 11.88 0.99 Final output

Query 4:

Select Artist.name as "Artist Name",sum(UnitPrice) as "Total Sale" from Track Inner join Album on Track.AlbumId=Album.AlbumId inner join Artist on Artist.ArtistID=Album.ArtistID group by Artist.Name order by sum(UnitPrice) desc limit 1;

phpMyAdmin Server: 127.0.0.1 >> Database: cd >> Table Artist Browse Structure SQL Search * Insert Export Import Privileges Operations Tracking 29 Triggers Recent Favorites Type to filter these, Enter to search all Show query box X A Current selection does not contain a unique column Grid edit, checkbox, Edit, Copy and Delete features are not available. c323 cd Showing rows 0 - 0 (1 total, Query took 0.0081 seconds.) Select Artist.name as "Artist Name", sum(UnitPrice) as "Total Sale" from Track Inner join Album on Track.AlbumId=Album. Albumid inner join Artist on Artist ArtistID=Album. ArtistID group by Artist. Name order by sum(UnitPrice) desc limit 1 Profiling [Edit inline] ( Edit ][ Explain SQL][ Create PHP code][Refresh] + Options Artist Name Iron Maiden Total Sale 210.87 Query results operations Print 3c Copy to clipboard Export . Display chart Create view New + album artist customer employee genre invoice invoiceline mediatype playlist t-il playlisttrack + track club LOdb + dbcat + dbcustomer +-odbemployee +-dbhospital LO dbhospital 1 -dbsampleword dbstudent + dbstudent1 +LO dbsurvey +-3 dbtrigerexample +-delight_hotels LO docoffice +-dotcode + emp1 Bookmark this SQL query Label: Let every user access this bookmark Bookmark this SQL query Console W

if you still have any Problem regarding this question please comment and if you like my code please appreciate me by thumbs up thank you.........