SQLab — learn SQL in your browser

Cancellations by city

MediumOnline storeHAVING40 XP

Show the cities with at least 3 cancelled orders: city and the number of cancelled orders.

Tables · Online store

categoriesProduct categories8 rows

productsProducts63 rows

reviewsReviews330 rows

customersCustomers160 rows

ordersOrders640 rows

order_itemsOrder lines1,174 rows

Sign in to open this section

Sign in to solve problems and play the arena. It takes less than a minute.

Tables · Online store

categoriesProduct categories8 rows

productsProducts63 rows

reviewsReviews330 rows

customersCustomers160 rows

ordersOrders640 rows

order_itemsOrder lines1,174 rows