Amazon's checkout team wants to know where shoppers give up after adding to cart. They look at each device separately, because the checkout pages differ.
For each device, count the customers who added to cart on that device, and the percentage of them who never purchased on that device.
Expected output
abandoned_pct rounded to 1 decimal; any row orderExample of the shape (made-up values):
| device | carted | abandoned_pct |
|---|---|---|
| tablet | 50 | 38.0 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.