Lifetime of a customer


Suppose you work for a large eCommerce company. You're given the below table schema for a table called 'orders' that highlights eCommerce purchases since the company's inception:

Table: orders

order_id customer_id created_at
unique id of the order unique id of the customer associated with the given order the date the order was made

Additionally you're provided the below table schema, called 'customers' containing the customer's unique id, as well as their name:

Table: customers

customer_id name address
unique id of the customer name of the customer shipping address of the customer

Given the above, write a SQL query to return the name and address of your first 100 customers.
(Your company wants to send gift cards + thank you notes and needs this information)


Access restricted

Subscribe to premium account to see the solution.

Get premium now