Busiest Ice Cream Cart
A small ice cream company runs several carts around the city. The IceCreamCarts table records each cart’s name and the number of scoops it sold on a sunny Saturday.
Write a query that returns the highest number of scoops sold by any cart.
Return one column named max_scoops_sold containing a single value.
Table Schema
IceCreamCarts
| Column | Type | Description |
|---|---|---|
cart_id |
INTEGER | Unique identifier for the cart. |
cart_name |
VARCHAR(50) | The playful name of the cart. |
scoops_sold |
INTEGER | Scoops sold during the day. |
Example Data
| cart_name | scoops_sold |
|---|---|
| Sprinkle Sprint | 126 |
| The Rolling Scoop | 184 |
| Cone Voyage | 157 |
Expected Result Shape
| max_scoops_sold |
|---|
| 184 |
Loading...
Loading SQL engine…

