SQL · Capital One · Medium
Write one SQL query that, for every region, reports the category with the greatest delivered revenue during August 2025. Use these four tables: customers(customer_id INT, name VARCHAR(100), region VARCHAR(20)) products(product_id INT, category VARCHAR(50)) orders(order_id INT, customer_id INT, order_date DATE, status VARCHAR(20)) order_items(order_id INT, product_id INT, qty INT, unit_price DECIMAL(10,2)) Revenue for a line item is qty * unit_price, and a region/category…
Checking your access…