Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. select Count( p1.name) , u1.email from users as u1 INNER JOIN
  2. purchases as p1 ON u1.id=p1.user_id
  3. where u1.email IN (select u.email from users as u
  4. INNER JOIN purchases p ON u.id=p.user_id
  5. where p.name='Williams Selden') group by u1.email;
  6.  
  7. count | email
  8. -------+----------------------------
  9. 15 | Shanell.Maxson@gmail.com
  10. 23 | Ozella.Yoshimura@gmail.com
  11. 14 | Isabel.Breeding@gmail.com
  12.  
  13. select DISTINCT p1.name , u1.email from users as u1 INNER JOIN
  14. purchases as p1 ON u1.id=p1.user_id where u1.email
  15. IN (select u.email from users as u INNER JOIN purchases p ON
  16. u.id=p.user_id where p.name='Williams Selden') group by u1.email,
  17. p1.name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement