Coding question · Conditional PivotMediumAsked at Stripe

Each category's share of total revenue

Window function with no PARTITION (global aggregate) for per-group ratios.

Unlock with Pro→Back to all coding questions

The Brief

← Previous
Top 2 earners per department (DENSE_RANK)
Next →
Mia Jackson's full reporting chain