Guest User

Untitled

a guest
Dec 9th, 2018
1,643
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.63 KB | None | 0 0
  1. > SELECT * FROM users
  2. +----+---------------------------+
  3. | id | email |
  4. +----+---------------------------+
  5. | 5 | abcdefghijklmno@gmail.com |
  6. +----+---------------------------+
  7.  
  8. > SELECT * FROM movies
  9. +----+---------+---------+--------------+
  10. | id | title | user_id | total_watches|
  11. +----+---------+---------+--------------+
  12. | 1 | X-men | 1 | 1 |
  13. | 2 | Blade | 1 | 1 |
  14. | 3 | Goonies | 1 | 1 |
  15. +----+---------+---------+--------------+
  16.  
  17. > SELECT * FROM sessions
  18. +----+---------+---------+------------+
  19. | id | user_id | show_id | total_time |
  20. +----+---------+---------+------------+
  21. | 1 | 1 | 1 | 5 |
  22. | 2 | 1 | 1 | 30 |
  23. | 3 | 1 | 1 | 5 |
  24. +----+---------+---------+------------+
  25.  
  26. +----+---------------------------+---------------+----------------+
  27. | id | email | total_time | total_watches |
  28. +----+---------------------------+---------------+----------------+
  29. | 5 | abcdefghijklmno@gmail.com | 40 | 3 |
  30. +----+---------------------------+---------------+----------------+
  31.  
  32. SELECT users.id, users.email, SUM(movies.total_watches) AS total_watches, SUM(sessions.total_time) AS total_time
  33. FROM users
  34. JOIN movies ON users.id = movies.user_id
  35. JOIN sessions ON users.id = sessions.user_id
  36. GROUP BY user.id
  37.  
  38. +------------------+---------------+---------------+
  39. | email | total_watches | total_time |
  40. +------------------+---------------+---------------+
  41. | abcdef@gmail.com | 9 | 120 |
  42. +------------------+---------------+---------------+
Add Comment
Please, Sign In to add comment