dsamarin/all-orders-placed-by-a-customer.sql

Forked from dan81989/all-orders-placed-by-a-customer

Created October 9, 2019 08:31

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dsamarin/ac353eb13d18bc200b8e7618890f9f01.js"></script>
Save dsamarin/ac353eb13d18bc200b8e7618890f9f01 to your computer and use it in GitHub Desktop.

Download ZIP

Let’s say we want to find all orders placed by a particular customer. We can do this by joining the customers and orders tables together using the relationship established by the customer_id key.

Raw

all-orders-placed-by-a-customer.sql

	SELECT order_date, order_amount
	FROM customers
	JOIN orders
	ON customers.customer_id = orders.customer_id
	WHERE customer_id = 3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment