[Solved] Consider the table Orders with columns Customer and Total:Customer | TotalAnna | 200Ben | 200Clara | 150What will be the result of this query?... | SQL

SQL - Window Functions Fundamentals

Consider the table Orders with columns Customer and Total:

Customer | Total
Anna     | 200
Ben      | 200
Clara    | 150

What will be the result of this query?

SELECT Customer, RANK() OVER (ORDER BY Total DESC) AS Rank FROM Orders;

AAnna - 1, Ben - 1, Clara - 3

BAnna - 1, Ben - 2, Clara - 3

CAnna - 1, Ben - 1, Clara - 2

DAnna - 2, Ben - 2, Clara - 3

Step-by-Step Solution

Solution:

Step 1: Understand RANK() behavior
RANK() assigns the same rank to ties but skips subsequent ranks accordingly.
Step 2: Apply to data
Anna and Ben both have 200, so both get rank 1. Clara has 150, so rank is 3 (rank 2 is skipped).
Final Answer:
Anna - 1, Ben - 1, Clara - 3 -> Option A
Quick Check:
Check for skipped rank after ties [OK]

Quick Trick: RANK() skips ranks after ties [OK]

Common Mistakes:

Master "Window Functions Fundamentals" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider the table Orders with columns Customer and Total: