Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started
Top 5 Expensive Products
00:00
5 left

Top 5 Expensive Products

EasySQL · PostgreSQL

Problem

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

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

Schema

products
ColumnTypeDescription
product_idPKINTUnique product identifier
product_nameVARCHAR(255)Product display name
categoryVARCHAR(100)Product category
priceDECIMAL(10,2)Product price
Tablesproducts
Interviewer

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.

You need to log in / sign up to run or submit.
CodePostgreSQL
You need to log in / sign up to run or submit.Ln 1
Run your query to see results here.