SQLab
LearnPracticeProblemsArenaLeaderboard

SQLab

Online store

Online store · Medium

Question 1

Medium20 XP

How many products are currently on sale (is_active)?

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.

SQLab

Tables · Online store

categoriesProduct categories8 rows
productsProducts63 rows
reviewsReviews330 rows
customersCustomers160 rows
ordersOrders640 rows
order_itemsOrder lines1,174 rows