SQLab — learn SQL in your browser

Delivered revenue

MediumOnline storeJOIN + SUM40 XP

What is the total revenue from delivered orders? Revenue is the sum of quantity × unit_price. Return a single number.

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