Dataford - Ace your Data Interview

Find the names and the total spend of the top 3 spenders in the Electronics category

To answer this, you will need 3 tables: customers, orders, and products:

customers: This table contains information about each customer.

Column Name	Description
customer_id	Unique identifier for a customer
name	The customer's full name
email	The customer's email address

orders: This table tracks each order placed by customers.

Column Name	Description
order_id	Unique identifier for an order
customer_id	ID of the customer who placed the order
product_id	ID of the product ordered
order_date	Date when the order was placed

products: This table lists details of products available for purchase.

Column Name	Description
product_id	Unique identifier for a product
product_name	Name of the product
category	Category of the product
price	Price of the product

Modules