Sql - Challenge
đź“– Read the lesson
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...
↶
▶️ Run
↷
đź’ˇ Show Solution
Continue