Guest User

Untitled

a guest
Jan 24th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. --#Students
  2. select count(*) from students where firstName ='John'
  3. --#Sessions
  4. select userid,SUM/countuserid as averageuserId from (select userid,count(userid) as countuserid , sum(duration) as SUM from sessions
  5. group by userid)
  6. where countuserid > 1
  7. group by userid
Add Comment
Please, Sign In to add comment