Given the table `sales_table` with columns `region`, `product`, and `sales`, which query will rank products within each region by their sales, displaying the region, product, sales, and rank without any gaps in the ranking?

Exam-Like

Last updated: August 9, 2026 at 03:05

-2

SELECT
    region,
    product,
    RANK() OVER (
        ORDER BY sales DESC
    ) AS rank
FROM sales_table;

SELECT
    region,
    product,
    RANK() OVER (
        ORDER BY sales DESC
    ) AS rank
FROM sales_table;

66.8%

SELECT
    region,
    product,
    RANK() OVER (
        PARTITION BY product
        ORDER BY sales DESC
    ) AS rank
FROM sales_table;

SELECT
    region,
    product,
    RANK() OVER (
        PARTITION BY product
        ORDER BY sales DESC
    ) AS rank
FROM sales_table;

17.9%

SELECT
    region,
    product,
    RANK() OVER (
        PARTITION BY region
    ) AS rank
FROM sales_table;

SELECT
    region,
    product,
    RANK() OVER (
        PARTITION BY region
    ) AS rank
FROM sales_table;

SELECT
    region,
    product,
    RANK() OVER (
        PARTITION BY region
        ORDER BY sales DESC
    ) AS rank
FROM sales_table;

SELECT
    region,
    product,
    RANK() OVER (
        PARTITION BY region
        ORDER BY sales DESC
    ) AS rank
FROM sales_table;

15.3%

Databricks Certified Data Analyst - Associate