Return each category with revenue and share_pct (its percentage of total revenue, 2 decimals). Use one CTE for category revenue.
category
revenue
share_pct
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.