Lifetime of a customer
Question
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)