Select & Filter in SQL: interview exercises

Select & Filter in SQL: 6 test-checked interview exercises (Pick columns, sort, limit, Filter with AND), each beside a worked example, with tests as you go. Free.

1. Pick columns, sort, limit
2. Filter with AND
3. IN and BETWEEN
4. Pattern matching with LIKE
5. NULL and COALESCE
6. DISTINCT values

Each exercise pairs a worked example with a twin problem to solve in a real editor; the tests run the moment you do. Progress is saved in your browser, and in your account if you sign in.

More SQL topics

• Aggregation
• Joins
• Subqueries & CTEs
• Window Functions
• Strings, Dates & CASE
• Modifying Data
• Schema Design

All SQL exercises · Other languages and frameworks