MENU
A data analyst has been asked to use the below table sales_table to rank products within region by the sales.
Input table:
region product sales
WEST A 1880.59
EAST A 2045.99
EAST B 4583.23
WEST B 3391.19
The result of the query should look like this:
region product rank
EAST B 1
EAST A 2
WEST B 1
WEST A 2
Which query will accomplish this task?
A.
SELECT
region,
product,
RANK() OVER (
ORDER BY sales DESC
) AS rank
FROM sales_table;
B.
SELECT
region,
product,
RANK() OVER (
PARTITION BY product
ORDER BY sales DESC
) AS rank
FROM sales_table;
C.
SELECT
region,
product,
RANK() OVER (
PARTITION BY region
) AS rank
FROM sales_table;
D.
SELECT
region,
product,
RANK() OVER (
PARTITION BY region
ORDER BY sales DESC
) AS rank
FROM sales_table;