63316329

Date: 2020-08-08 15:16:07
Score: 5.5
Natty:
Report link
Select a.name,sum(il.quantity)*(il.unitprice) as totalSales from artist a 

join album al on a.artistid=al.artistid 

join track t on al.albumid=t.albumid

join invoiceline il on t.trackid=il.trackid

group by a.name order by totalSales desc;

Same question?

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Me too answer (2): Same question
  • Ends in question mark (2):
  • Starts with a question (0.5): Same question
  • Low reputation (1):
Posted by: Nofil Asif