[Solved] What is wrong with this query?SELECT player, score, AVG(score) OVER (ORDER BY score RANGE BETWEEN 2 PRECEDING AND CURRENT ROW) FROM players; | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

What is wrong with this query?

SELECT player, score, AVG(score) OVER (ORDER BY score RANGE BETWEEN 2 PRECEDING AND CURRENT ROW) FROM players;

AAVG cannot be used with RANGE frame.

BRANGE frame cannot use numeric offsets like '2 PRECEDING'.

CORDER BY clause is missing.

DThe query is correct and will run without errors.

Step-by-Step Solution

Solution:

Step 1: Understand RANGE frame limits
RANGE requires value expressions, not row counts like '2 PRECEDING'.
Step 2: Identify error
Using '2 PRECEDING' with RANGE causes syntax error.
Final Answer:
RANGE frame cannot use numeric offsets like '2 PRECEDING'. -> Option B
Quick Check:
RANGE needs value offsets, not row counts [OK]

Quick Trick: Use INTERVAL or value expressions with RANGE, not row counts [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is wrong with this query?