Top 3 Expensive Items
e Bay
Problem Statement
eBay marketplace analysts want to feature the most premium products on the homepage. You need to identify the three items with the highest listing prices.
Write an SQL query to find the top 3 most expensive products.
Rules:
- Return the product_name and price.
- Results must be sorted by price in descending order.
- If two products have the same price, sort them by product_name in ascending order as a tie-breaker.
Tests your understanding of
Basic SQL, ORDER BY, LIMIT and Filtering
Input Tables
products
| product_id(INTEGER) | product_name(VARCHAR) | price(DECIMAL) |
|---|---|---|
| 1 | Vintage Watch | 1200.5 |
| 2 | Gaming Laptop | 2500 |
| 3 | Designer Bag | 3200 |
| 4 | Rare Coin | 5000 |
| 5 | Old Camera | 800 |
Expected Output
| product_name(VARCHAR) | price(DECIMAL) |
|---|---|
| Rare Coin | 5000 |
| Designer Bag | 3200 |
| Gaming Laptop | 2500 |
Tags
EasyBasic SQLORDER BYLIMITFiltering
5 min
82%