GotchiCode needs JavaScript for the code editor and live challenges. Please enable it to play.
GotchiCode
Paths
Courses
Community
Arcade
Leaderboard
◂
Learn SQL
▾
First Queries
0/4
The Warden's Ledger
10 XP
Keywords and Case
10 XP
Notes in the Margin
10 XP
Meet the Tables
10 XP
▾
Picking Columns
0/4
One Column
10 XP
Several Columns
10 XP
Column Order
10 XP
Renaming with AS
15 XP
▾
Filtering Rows
0/4
WHERE a Number
15 XP
WHERE Text
15 XP
Bigger and Smaller
15 XP
Not Equal
15 XP
▾
Combining Filters
0/4
AND
15 XP
OR and Parentheses
15 XP
IN
15 XP
BETWEEN
15 XP
▾
Pattern Matching
0/4
LIKE and Percent
15 XP
Exactly One Character
15 XP
NOT LIKE
15 XP
Pattern Practice
20 XP
▾
Missing Values
0/4
What Is NULL?
15 XP
IS NOT NULL
15 XP
NULL Never Equals
20 XP
COALESCE
20 XP
▾
Sort & Limit
0/4
ORDER BY
15 XP
Descending and Ties
15 XP
LIMIT
15 XP
DISTINCT
15 XP
▾
Expressions & Functions
0/4
Arithmetic
15 XP
Text Functions
15 XP
ROUND and ABS
20 XP
Gluing Text
20 XP
▾
Aggregates
0/4
COUNT
15 XP
Counting with Conditions
15 XP
SUM and AVG
15 XP
MIN and MAX
15 XP
▾
Grouping Data
0/4
GROUP BY
20 XP
Aggregates per Group
20 XP
HAVING
20 XP
HAVING vs WHERE
25 XP
▾
Building Tables
0/4
CREATE TABLE
20 XP
Choosing Types
20 XP
Primary Keys
20 XP
A Table of Your Own
25 XP
▾
Constraints
0/4
NOT NULL
20 XP
UNIQUE
20 XP
DEFAULT
20 XP
CHECK
25 XP
▾
Adding Rows
0/4
INSERT
15 XP
Choosing Columns
15 XP
Many at Once
20 XP
Registration Day
25 XP
▾
Changing Rows
0/4
UPDATE ... SET
15 XP
UPDATE Needs WHERE
20 XP
Updating with Math
20 XP
Several Columns
20 XP
▾
Removing Rows
0/4
DELETE ... WHERE
15 XP
Deleting Everything
15 XP
Careful Deletes
20 XP
Spring Cleaning
20 XP
▾
Reshaping Tables
0/4
Adding a Column
20 XP
Renaming
20 XP
DROP TABLE
20 XP
IF EXISTS
20 XP
▾
Table Relationships
0/4
Why Two Tables?
20 XP
Foreign Keys
20 XP
REFERENCES
20 XP
Linking Up
25 XP
▾
Inner Joins
0/5
The JOIN
25 XP
Columns from Both
25 XP
JOIN plus WHERE
25 XP
Table Aliases
25 XP
JOIN and COUNT
30 XP
▾
Outer Joins
0/4
Missing Partners
25 XP
LEFT JOIN
25 XP
Finding Orphans
25 XP
Counting with Gaps
30 XP
▾
Multi-table Joins
0/4
Three Tables
30 XP
The Self-Join
30 XP
Rivals
30 XP
Expedition Report
30 XP
▾
Set Operations
0/3
UNION
25 XP
INTERSECT
25 XP
EXCEPT
25 XP
▾
Subqueries
0/5
A Query Inside a Query
25 XP
IN a List from a Query
25 XP
NOT IN
25 XP
Subquery or Join?
25 XP
One per Row
30 XP
▾
Conditional Logic
0/3
CASE WHEN
25 XP
Buckets
25 XP
Counting Cases
30 XP
▾
Capstone: The Warden's Ledger
0/5
Build the Registry
30 XP
Opening Day
30 XP
The Roster Report
30 XP
Strength of the Dens
30 XP
The Final Audit
30 XP
Loading lesson…