← Problems

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…