Cart Abandonment Rate
Medium
Inventory & E-commerce Cases
Return the percentage of carts that were abandoned (status = 'abandoned'), rounded to two decimals.
Table schema
Carts(id INT PRIMARY KEY, status VARCHAR(10))Sample data
id | status
1 | purchased
2 | abandoned
3 | abandoned
4 | purchased
5 | abandoned
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.