Cold Case~69min

The Artist Whose Plays Were Mostly "Promotional"

Nova Ashworth (ARTIST-11) has 61.87% of her plays classified as "promotional" (which pay no royalty) — flat and consistent across all 6 months — versus a 5.96%-6.95% peer baseline (avg 6.62%) among 5 comparable artists. Reclassified to the peer-baseline ratio, she's owed $5,432.61 in underpaid royalty at $0.003/play. Wren Castellano (ARTIST-19) also shows an elevated overall promotional ratio (42.6%), but broken out by month, it's a normal ~7% every month except March 2024, which spikes to 82% during a documented radio promo campaign — explained, not misclassification.

Tables you'll query

artiststracksplays

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →