Please Provide an answer in MYSQL workbench

List the top 5 artists in terms of total sales. List the artist Name, and the sum of all invoices by the artist, biggest (in terms of total sales, to smallest).

Hint : to do this you will need to join artist to album to track to invoiceline to invoice, sum the Total of each invoice, group by the artist name or artistid and sort the list in descending order with a limit clause.

Artist table:

Columns:

ArtistId	int(11) AI PK
Name

album table:

Table: album Columns:

AlbumId	int(11) AI PK
Title	varchar(160)
ArtistId	int(11)

track table:

TrackId	int(11) AI PK
Name	varchar(200)
AlbumId	int(11)
MediaTypeId	int(11)
GenreId	int(11)
Composer	varchar(220)
Milliseconds	int(11)
Bytes	int(11)
UnitPrice	decimal(10,2)

invoiceLine table:

InvoiceLineId	int(11) AI PK
InvoiceId	int(11)
TrackId	int(11)
UnitPrice	decimal(10,2)
Quantity	int(11)

invoice table:

InvoiceId	int(11) AI PK
CustomerId	int(11)
InvoiceDate	datetime
BillingAddress	varchar(70)
BillingCity	varchar(40)
BillingState	varchar(40)
BillingCountry	varchar(40)
BillingPostalCode	varchar(10)
Total	decimal(10,2)