Top 5 Expensive Products | Dataford Interview Questions

Write a SQL query to retrieve the top 5 most expensive products from a specific category at Editorialist X.

Use the products table and treat Dresses as the requested category.

Output

One row per qualifying product with product_id, product_name, and price.
Include only products in the Dresses category, ordered by price descending, with product_id ascending as the tie-breaker.
Return at most five rows.

products

Your question is Top 5 Expensive Products. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Write a SQL query to retrieve the top 5 most expensive products from a specific category at Editorialist X.

Use the products table and treat Dresses as the requested category.

One row per qualifying product with product_id, product_name, and price.
Include only products in the Dresses category, ordered by price descending, with product_id ascending as the tie-breaker.
Return at most five rows.

products

Your question is Top 5 Expensive Products. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.