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:
|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:
|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)
Subscribe to premium account to see the solution.Get premium now