Ga naar de inhoud
EndpointPilot
X
Bluesky
LinkedIn
Facebook
About
About the Founder
Beginner SQL Challenges
Challenge 1: Select Specific Columns (Without Overfetching)
SQL Beginner Challenge 10: Find Missing Matches with LEFT JOIN + WHERE
SQL Beginner Challenge 11: Conditional Logic with CASE
SQL Beginner Challenge 12: Handling NULL Values with COALESCE
SQL Beginner Challenge 13: Filtering NULL Values with IS NULL and IS NOT NULL
SQL Beginner Challenge 14: Filter Ranges with BETWEEN
SQL Beginner Challenge 15: Pattern Matching with LIKE
SQL Beginner Challenge 16: Single-Character Matching with _ (Underscore Wildcard)
SQL Beginner Challenge 17: Combining Conditions with AND and OR
SQL Beginner Challenge 18: Sorting Results with ORDER BY
SQL Beginner Challenge 19: Limiting Results with LIMIT
SQL Beginner Challenge 20: Skipping Rows with OFFSET
SQL Beginner Challenge 21: Pagination Patterns
SQL Beginner Challenge 22: Counting Rows with Conditions (COUNT + WHERE)
SQL Beginner Challenge 23: Counting Values Per Group with GROUP BY
SQL Beginner Challenge 24: Filtering Rows vs Groups (WHERE + HAVING)
SQL Beginner Challenge 25: Summing Values with SUM()
SQL Beginner Challenge 26: Calculating Averages with AVG()
SQL Beginner Challenge 27: Finding Minimum and Maximum Values (MIN / MAX)
SQL Beginner Challenge 28: Sorting Aggregated Results (ORDER BY with Aggregates)
SQL Beginner Challenge 29: Limiting Grouped Results (Top-N with Aggregates)
SQL Beginner Challenge 2: Filter Rows with WHERE
SQL Beginner Challenge 30: Top-N with Ties (Handling Equal Totals)
SQL Beginner Challenge 3: Sort Results with ORDER BY
SQL Beginner Challenge 4: Count Rows with COUNT()
SQL Beginner Challenge 5: Remove Duplicates with DISTINCT
SQL Beginner Challenge 6: Group and Summarize Data with GROUP BY
SQL Beginner Challenge 7: Filter Groups with HAVING
SQL Beginner Challenge 8: Join Two Tables with INNER JOIN
SQL Beginner Challenge 9: Keep All Rows with LEFT JOIN
Contact
Intermediate SQL Challenges
SQL Intermediate Challenge 1: Above-Average Products per Category (Subquery / CTE)
SQL Intermediate Challenge 2: Top Product per Category (Correlated Subquery or ROW_NUMBER())
SQL Intermediate Challenge 3: Second-Highest Product per Category
SQL Intermediate Challenge 4: Products Above Category Median
Privacy Policy
Start with Beginner SQL Challenges
Terms & Conditions
SolveWithSQL HomePage Background
SolveWithSQL HomePage Background
Ben Kemp
december 27, 2025
