Learn SQL

0%

Show Skipped Chapters

1.Talk to a Table

Say “Hello” to the Table Say “Hello” to the Table - Repaired Quiz: Say “Hello” to the Table Challenge: Say “Hello” to the Table Solution: Say “Hello” to the Table Pick the Columns You Want Quiz: Pick the Columns You Want Challenge: Pick the Columns You Want Solution: Pick the Columns You Want Find the Rows That Matter Quiz: Find the Rows That Matter Problem: Find the Rows That Matter Solution: Find the Rows That Matter Use Comparisons and Logic Quiz: Use Comparisons and Logic Problem: Use Comparisons and Logic Solution: Use Comparisons and Logic Sort the Answers Quiz: Sort the Answers Problem: Sort the Answers Solution: Sort the Answers Problem: Help a Pet Lover Solution: Help a Pet Lover

2.Ask Better Questions

Do Math with Your Data Quiz: Do Math with Your Data Problem: Do Math with Your Data Solution: Do Math with Your Data Group Things Together Quiz: Group Things Together Problem: Group Things Together Solution: Group Things Together Only Keep Interesting Groups Quiz: Only Keep Interesting Groups Problem: Only Keep Interesting Groups Solution: Only Keep Interesting Groups Ask Questions About Questions Quiz: Ask Questions About Questions Problem: Ask Questions About Questions Solution: Ask Questions About Questions Project: Find the Top Performers

3.Create Your Own World

Create a Table Quiz: Create a Table Challenge: Create a Table Solution: Create a Table Add Some Data Quiz: Add Some Data Problem: Add Some Data Solution: Add Some Data Fix Mistakes Quiz: Fix Mistakes Problem: Fix Mistakes Solution: Fix Mistakes Design Better Tables Quiz: Design Better Tables Problem: Design Better Tables Solution: Design Better Tables Project: Build a Student Tracker

4.Connect the Dots

Meet the JOIN Family Quiz: Meet the Join Family Problem: Meet the JOIN Family Solution: Meet the JOIN Family Connect Two Tables Quiz: Connect Two Tables Problem: Connect Two Tables Solution: Connect Two Tables Go Multi-Level Quiz: Go Multi-Level Problem: Go Multi-Level Solution: Go Multi-Level Build a Mini Dashboard Problem: Build a Mini Dashboard Solution: Build a Mini Dashboard Project: Build a Mini Dashboard Project: Library Tracker Problem: Compute Student CGPA Solution: Compute Student CGPA Final Project: Build a Game Leaderboard

...

/

Say “Hello” to the Table - Repaired

Say “Hello” to the Table - Repaired

Run your first SQL query and view full table data.

We'll cover the following...

Welcome to SQL! In the next 2 minutes, you will:

✅ run your first query
✅ personalize it (columns / filter)
✅ pass a 10-second checkpoint

Step 1 — Run your first query

You can press Run to see results, or ask your AI Mentor if you get stuck.

MySQL

SELECT * FROM people;

By clicking Run, you ask SQL to show every column and row from the people table.

You should see a table with 4 rows and 4 columns: id, name, age, city. The table is named people.

ID	Name	Age	City
1	Aisha	30	Karachi
2	Dan	24	New York
3	Fatima	27	Lahore
4	Lee	22	Seoul

Tip: SQL keywords are case-insensitive (select, SELECT, SeLeCt), and the final semicolon is optional for a single statement.

Step 2 — Make it yours

Can you make a minimal change in the query such that, instead of showing everything from the people table, it shows the data from pets.

Don’t worry about making mistakes. Write the code that you think should make sense. Press Run, and if you don’t see the correct results, try your AI Mentor.

MySQL

SELECT * FROM people;

Concept at a glance

SELECT — which columns to show (* means “all columns”).
FROM — the table you’re asking (people).
Keywords (SELECT, FROM) aren’t case-sensitive, table names are.
The semicolon ; is optional for a single query here.