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
4 rows with columns category, revenue, share_pct
Run your code to see the output here.