You need the moving average of the last 3 rows including the current row. Which frame clause achieves this? SQL Data AnalystHard Try Now
A CTE is defined WITH cte AS (SELECT …). Which statement about CTEs is true? SQL Data AnalystHard Try Now
What does LAG(revenue, 2) OVER (ORDER BY month) return for the third row in a result set? SQL Data AnalystHard Try Now
Which window function calculates a running total of sales ordered by date within each region? SQL Data AnalystHard Try Now
What is the key behavioral difference between RANK() and DENSE_RANK() when there are tied values? SQL Data AnalystHard Try Now
A query uses ROW_NUMBER() OVER (PARTITION BY dept_id ORDER BY salary DESC). What does this produce? SQL Data AnalystHard Try Now
In what order does SQL evaluate the major clauses of a SELECT statement? SQL FundamentalsEasy Try Now