Prime Shipping Eligibility
ASKED IN INTERVIEWAmazon
Problem Statement
Amazon Prime shipping costs are optimized when products are lightweight but have a higher profit margin. The logistics team needs a list of all products that weigh less than 5lbs and have a retail price greater than $20.
Write an SQL query to identify these eligible products.
Rules:
- The weight must be strictly less than 5.
- The price must be strictly greater than 20.
- Output columns: product_id, product_name, price.
- Sort the results by price in descending order.
Table Schema:
- Products: product_id, product_name, category, weight, price.
Tests your understanding of
Basic SQL, Filtering and Logical Operators
Input Tables
Products
| product_id(INTEGER) | product_name(VARCHAR) | weight(DECIMAL) | price(DECIMAL) |
|---|---|---|---|
| 1 | Wireless Mouse | 0.5 | 25 |
| 2 | Gaming Chair | 45 | 199 |
| 3 | USB-C Cable | 0.2 | 12 |
| 4 | Mechanical Keyboard | 3 | 85 |
| 5 | Desk Lamp | 4.9 | 30 |
| 6 | Heavy Doorstop | 6 | 22 |
Expected Output
| product_id(INTEGER) | product_name(VARCHAR) | price(DECIMAL) |
|---|---|---|
| 4 | Mechanical Keyboard | 85 |
| 5 | Desk Lamp | 30 |
| 1 | Wireless Mouse | 25 |
Tags
EasyASKED IN INTERVIEWBasic SQLFilteringLogical Operators
5 min
88%