What does GROUP BY ROLLUP(dept, role) produce compared to a plain GROUP BY? SQL Data AnalystMedium Try Now
What does CASE WHEN salary > 100000 THEN ‘Senior’ ELSE ‘Junior’ END return? SQL Data AnalystMedium Try Now
In a LEFT JOIN anti-join pattern, what does adding WHERE right_table.id IS NULL accomplish? SQL Data AnalystMedium Try Now
What is a CTE (Common Table Expression) and what advantage does it provide? SQL Data AnalystMedium Try Now
What does LAG(revenue, 1) OVER (ORDER BY month) return for the first row? SQL Data AnalystMedium Try Now
What does the following window function return for each row? SUM(sales) OVER (PARTITION BY region ORDER BY sale_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) SQL Data AnalystMedium Try Now
What is the difference between ROW_NUMBER() and RANK() when there are tied values? SQL Data AnalystMedium Try Now
What is the correct SQL clause execution order for a standard SELECT query? SQL Data AnalystEasy Try Now
