Sql - Challenge
Code Life
By Pierre Marsaa
Season dashboard: Step 1
Professor Pi is building the season dashboard and needs three queries from you.
Loading data...
Loading data...
Step 1: badges per gym. Write a CTE per_gym counting the badges handed out by each gym_id, then return every gym's name and badges_given (0 when none), most generous first, then by name.
↗️
Loading editor...
↶
↷
💡 Show Solution
Continue