Sql - Challenge
📖 Read the lesson
Code Life
By Pierre Marsaa
League directory: Step 1
Professor Pi is printing the league directory and needs three queries from you.
Loading data...
Loading data...
Loading data...
Step 1: one list of every name in the league. Return
name
and
kind
(
'trainer'
,
'gym'
or
'codemon'
) for all three tables, sorted by
kind
then
name
.
↗️
Loading editor...
↶
▶️ Run
↷
💡 Show Solution
Continue