Domain — RisingBrain

Sheets Domain Screening Puzzles Courses Interview

Sheets Domain Screening Puzzles Courses Interview

SQL · choose a topic

Pattern 1 — Basic Data Retrieval

7

SELECT
SELECT Specific Columns
DISTINCT
Aliases (AS)
Arithmetic Expressions
LIMIT / TOP / FETCH FIRST
ORDER BY

Pattern 2 — Filtering Data

7

WHERE
Comparison Operators
Logical Operators (AND, OR, NOT)
BETWEEN
IN
LIKE
IS NULL / IS NOT NULL

Pattern 3 — Built-in Functions

8

String Functions
Numeric Functions
Date Functions
CASE WHEN
COALESCE
NULLIF
CONCAT
LENGTH / CHAR_LENGTH

Pattern 4 — Aggregation

5

COUNT
SUM
AVG
MIN / MAX
Aggregate on Condition

Pattern 5 — Grouping

4

GROUP BY
HAVING
GROUP BY Multiple Columns
COUNT DISTINCT

Pattern 6 — Joins

8

INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
CROSS JOIN
SELF JOIN
Multiple JOINs
Non-Equi Join

Pattern 7 — Set Operators

4

UNION
UNION ALL
INTERSECT
EXCEPT / MINUS

Pattern 8 — Subqueries

8

Scalar Subquery
Correlated Subquery
IN Subquery
EXISTS
NOT EXISTS
ANY (SOME)
ALL
Nested Subqueries

Pattern 9 — Common Table Expressions (CTEs)

3

Basic CTE
Multiple CTEs
Recursive CTE

Pattern 10 — Window Functions

11

ROW_NUMBER()
RANK()
DENSE_RANK()
NTILE()
LEAD()
LAG()
FIRST_VALUE()
LAST_VALUE()
Running Total
Moving Average
Window Aggregate

Pattern 11 — Interview SQL Patterns

10

Second Highest Salary
Nth Highest Salary
Top N Per Group
Duplicate Records
Remove Duplicates
Consecutive Records
Gaps and Islands
Pivot
Unpivot
Conditional Aggregation

Pattern 12 — Data Manipulation (DML)

4

INSERT
UPDATE
DELETE
MERGE / UPSERT

Pattern 13 — Database Objects

4

Views
Stored Procedures
User-Defined Functions
Triggers

Pattern 14 — Database Design & Performance

2

Indexes
Transactions (COMMIT / ROLLBACK)