Sql - Challenge
Code Life
By Pierre Marsaa
Annual review: Step 1
Professor Pi is writing the league's annual review and needs three queries from you.
Loading data...
Loading data...
Step 1: the elite. Return name, type and level of the Codémons whose level is above the average level of all Codémons and whose trainer holds at least one badge. Two subqueries, no JOIN. Sort by level descending.
↗️
Loading editor...
↶
↷
đź’ˇ Show Solution
Continue