SolveWithSQL

Welcome to SolveWithSQL 👋
If you’re new to SQL—or want to strengthen your fundamentals—you’re in the right place.

The beginner challenges are designed to help you learn SQL by solving simple, real problems, one query at a time.

No fluff. No long lectures. Just practice.

What the Beginner Challenges Are

Beginner challenges focus on the core building blocks of SQL—the things you’ll use every day when working with data.

Each challenge is:

• Short and focused
• Based on realistic tables and scenarios
• Clearly scoped (you always know what to solve)
• Followed by a clean solution and explanation

You’re encouraged to try first, even if you’re not sure. That’s how learning sticks.

What You’ll Learn

In the beginner track, you’ll practice how to:

• Select specific columns from a table
• Filter rows using WHERE
• Sort results with ORDER BY
• Count rows and values
• Remove duplicates with DISTINCT
• Use basic conditions and comparisons

These skills form the foundation for joins, aggregations, and more advanced queries later.

How to Use This Page

If this is your first visit, we recommend:

1. Starting at Challenge #1
2. Working through the challenges in order
3. Writing the query yourself before checking the solution
4. Moving on once the concept feels clear

There’s no timer, no scoring, and no sign-up required.

Beginner Challenge List

Start here and work your way down:

🟢 Beginner Level

1. Challenge #1: Select Specific Columns
2. Challenge #2: Filter Rows with WHERE
3. Challenge #3: Sort Results with ORDER BY
4. Challenge #4: Count Rows with COUNT()
5. Challenge #5: Remove Duplicates with DISTINCT
6. Challenge #6: Group and Summarize Data with GROUP BY
7. Challenge #7: Filter Groups with HAVING
8. Challenge #8: Join Two Tables with INNER JOIN
9. Challenge #9: Keep All Rows with LEFT JOIN
10. Challenge #10: Find Missing Matches with LEFT JOIN + WHERE
11. Challenge #11: Conditional Logic with CASE
12. Challenge #12: Handling NULL Values with COALESCE
13. Challenge #13: Filtering NULL Values with IS NULL and IS NOT NULL
14. Challenge #14: Filter Ranges with BETWEEN
15. Challenge #15: Pattern Matching with LIKE
16. Challenge #16: Single-Character Matching with _ (Underscore Wildcard)
17. Challenge #17: Combining Conditions with AND and OR

(More beginner challenges will be added over time.)

A Note on SQL Dialects

The examples in SolveWithSQL use standard SQL wherever possible.
The concepts apply to popular systems such as:

• PostgreSQL
• MySQL
• SQLite
• SQL Server

Minor syntax differences may exist, but the core ideas remain the same.

Ready to Start?

Begin with the first challenge and start writing queries.

👉 Start with Beginner Challenge #1

Write queries. Make mistakes. Learn SQL by doing.