Top 3 Most Expensive Items
ASKED IN INTERVIEWe Bay
Problem Statement
eBay analysts want to feature the most premium electronics on the homepage. Write an SQL query to find the three most expensive items in the Electronics category.
Rules:
- Only include items from the Electronics category.
- Output columns: item_name, price.
- Results must be sorted by price in descending order.
Tests your understanding of
Ranking, Filtering and Sorting
Input Tables
Items
| item_id(INTEGER) | item_name(VARCHAR) | category(VARCHAR) | price(DECIMAL) |
|---|---|---|---|
| 1 | Laptop | Electronics | 1200 |
| 2 | Smartphone | Electronics | 800 |
| 3 | Headphones | Electronics | 150 |
| 4 | Monitor | Electronics | 300 |
| 5 | Desk Lamp | Home | 45 |
Sellers
| seller_id(INTEGER) | item_id(INTEGER) | rating(DECIMAL) |
|---|---|---|
| 101 | 1 | 4.8 |
| 102 | 2 | 4.5 |
Stock_Log
| item_id(INTEGER) | quantity(INTEGER) |
|---|---|
| 1 | 10 |
| 2 | 25 |
Expected Output
| item_name(VARCHAR) | price(DECIMAL) |
|---|---|
| Laptop | 1200 |
| Smartphone | 800 |
| Monitor | 300 |
Tags
EasyASKED IN INTERVIEWRankingFilteringSorting
5-10 min
85%