#26

Drug sales by manufacturer

CVS Health is consolidating drug sales by manufacturer. For each manufacturer, calculate total sales. Return the result in the total_sales column as a string in the format $N, where N is the sales total rounded to a whole number. Sort the result by the actual sales total in descending order.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

total_salesmanufacturer
$43000AbbVie
$41000Novartis
$36000Merck
CVS Health

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid