Use a CTE cat_stock with each category and its total stock total_stock. Show it sorted from most to least stock.
cat_stock
category
total_stock
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.