Level 1, the basics. Retrieval, operators, aggregate functions, and the theory questions that still come up in interviews.
Level 2, where interviews actually begin. Joins, grouping, subqueries, CTEs, and set operations. This is where roughly half the candidates get filtered out.
Level 3, the level that gets you selected. Window functions, CASE WHEN, date and string functions, and query execution order. Scenario based questions live here.