Sql - Challenge
Code Life
By Pierre Marsaa
Adoption day: Step 1
Professor Pi organizes an adoption day for wild Codémons and needs three lists.
Loading data...
Loading data...
Step 1: every trainer with the size of their team. Return the trainer's name as trainer and the number of Codémons as team_size (0 for trainers who own nothing), sorted by team_size ascending, then by trainer.
↗️
Loading editor...
↶
↷
💡 Show Solution
Continue