SQL

Practice typing real SQL queries. From SELECT statements and JOINs to subqueries, CTEs, and DDL operations.

SELECT & FROM

Practice basic SELECT statements with column selection and aliases.

Select all columns from a table
Select specific columns with ordering
Column aliases and LIMIT clause
DISTINCT values with ordering
Computed column with arithmetic

WHERE & Filtering

Type WHERE clauses with comparison operators and logical conditions.

WHERE with boolean and date comparison
BETWEEN range and IN list filtering
LIKE pattern matching and NULL check
Complex filtering with ordering and limit

JOINs

Practice different types of SQL JOINs.

INNER JOIN with table aliases
LEFT JOIN with aggregate count
Multiple JOINs across three tables
Self JOIN for employee-manager relationship

GROUP BY & Aggregates

Type aggregate functions with GROUP BY and HAVING.

COUNT with GROUP BY
Multiple aggregate functions
HAVING clause to filter grouped results
Time-based grouping with DATE_TRUNC

Subqueries & CTEs

Practice subqueries and Common Table Expressions.

Subquery in WHERE clause
IN subquery for filtering
CTE with JOIN to main query
CTE with window function for top-N query

CREATE, INSERT, UPDATE, DELETE

Type DDL and DML statements for creating and modifying data.

CREATE TABLE with constraints and defaults
INSERT a single row
UPDATE specific row with SET
DELETE with multiple conditions
ALTER TABLE and CREATE INDEX

The Typing Cat is rated 4.1 out of 5 from 97,327 ratings