Ticket FIN-88 from Kavita Rao, Finance Manager, MeghaMart
Month-end review is at 4 PM and the revenue numbers from the old report look wrong. I need you to pull the real answers straight from the database. Delivered orders only, cancelled ones must never count. Five questions, five queries.
customers(id, name, city, joined_date)
products(id, name, category, price)
orders(id, customer_id, order_date, status) -- status: delivered / cancelled
order_items(order_id, product_id, qty, unit_price) -- unit_price may include discounts
products(id, name, category, price)
orders(id, customer_id, order_date, status) -- status: delivered / cancelled
order_items(order_id, product_id, qty, unit_price) -- unit_price may include discounts
Starting the database in your browser...
Results will appear here.
0 of 5 solved
The database runs entirely in your browser. Solve at least 3 to unlock the AI review. Cancelled orders are the classic trap.