What does the CASE expression return when no WHEN condition matches and no ELSE is provided? SQL FundamentalsMedium Try Now
What does index cardinality measure and why does it matter for query optimization? SQL Data AnalystMedium Try Now
In SQL window functions, what does ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING produce? SQL Data AnalystMedium Try Now
What problem does SCD Type 1 (Slowly Changing Dimension) create for analytics? SQL Data AnalystMedium Try Now
What does the following window expression do? AVG(salary) OVER (PARTITION BY dept ORDER BY hire_date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) SQL Data AnalystMedium Try Now
What is the difference between TRUNCATE and DELETE when removing all rows? SQL Data AnalystMedium Try Now
What does the following subquery pattern do? SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees) SQL Data AnalystMedium Try Now
