Skip to content

Instantly share code, notes, and snippets.

@vladimir-light

vladimir-light/sakila_customer_payments.sql

Created January 16, 2014 17:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vladimir-light/8459735 to your computer and use it in GitHub Desktop.
Save vladimir-light/8459735 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sakila_customer_payments.sql
SELECT p.customer_id,
i.inventory_id,
f.title,
f.rental_duration,
f.rental_rate,
r.rental_id,
r.rental_date,
r.return_date,
p.payment_id,
p.amount,
p.payment_date
FROM payment AS p
JOIN rental AS r ON(p.rental_id = r.rental_id AND r.customer_id = 187 AND DATE(r.rental_date) = '2005-08-18')
JOIN inventory AS i ON(r.inventory_id = i.inventory_id)
JOIN film AS f ON(i.film_id = f.film_id)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment