Bottom Three Products by Revenue
Easy
Ranking & Top-N
Return the three products with the lowest total revenue (product and revenue), lowest first.
Table schema
Sales(id INT PRIMARY KEY, product VARCHAR(20), amount INT)Sample data
id | product | amount
1 | Pen | 10
2 | Book | 50
3 | Bag | 5
4 | Pen | 5
5 | Cap | 30
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.