Dataford - Ace your Data Interview

As a Data Analyst in a known e-commerce company, you are being asked to find the average spend per user for each country.

Hint: We want to account for all users including those who never made a purchase

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
country	The customer's country

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