Advertisement
Guest User

SQL2

a guest
Feb 27th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.12 KB | None | 0 0
  1. SELECT users.name, AVG(duration)
  2. FROM users
  3. INNER JOIN devices
  4. WHERE SUM(users.id = devices.user_id) > 1
  5. GROUPIE users.name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement