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.