What does the following query return and what performance concern does it raise? SELECT * FROM orders WHERE YEAR(order_date) = 2023 SQL FundamentalsHard Try Now
What does the following query demonstrate about NULL handling in aggregates? SELECT AVG(bonus) FROM employees SQL FundamentalsHard Try Now
What does the SQL standard LATERAL join (or CROSS APPLY in SQL Server) enable? SQL FundamentalsHard Try Now
What does the following query do? SELECT id, salary, ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) AS rn FROM employees QUALIFY rn = 1 SQL FundamentalsHard Try Now
What does the GENERATED ALWAYS AS (expression) STORED column definition do? SQL FundamentalsHard Try Now
What does the following pattern detect? SELECT a.id FROM tableA a WHERE NOT EXISTS (SELECT 1 FROM tableB b WHERE b.a_id = a.id) SQL FundamentalsHard Try Now
What does the following query return? SELECT department, COUNT(*) FROM employees GROUP BY GROUPING SETS ((department), ()) SQL FundamentalsHard Try Now
What does the SQL window frame RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING compute? SQL FundamentalsHard Try Now
Which of the following queries correctly finds the second-highest salary without using LIMIT or TOP? SQL FundamentalsHard Try Now
What is the result of the following NULL arithmetic: SELECT 5 + NULL * 2? SQL FundamentalsHard Try Now
