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_sales | manufacturer |
|---|---|
| $43000 | AbbVie |
| $41000 | Novartis |
| $36000 | Merck |
CVS Health
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid