Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --#Students
- select count(*) from students where firstName ='John'
- --#Sessions
- select userid,SUM/countuserid as averageuserId from (select userid,count(userid) as countuserid , sum(duration) as SUM from sessions
- group by userid)
- where countuserid > 1
- group by userid
Add Comment
Please, Sign In to add comment