Advertisement
Guest User

Untitled

a guest
May 3rd, 2015
247
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. SELECT `friends`.`friend_age`
  2. FROM `friends`
  3. WHERE `id_user`
  4. IN(SELECT `users`.`uid` FROM `users` WHERE `age`=13 AND `number_of_friends` <> 0)
  5. AND `friend_age` <> 0 ORDER BY `friend_age`
  6.  
  7. select distinct f.friend_age
  8. from fiends f
  9. join users u on f.user_id = u.uid
  10. where
  11. u.age = 13
  12. and f.friend_age<>0
  13. order by f.friend_age
  14.  
  15. select f.friend_age, count(*) cnt
  16. from fiends f
  17. join users u on f.user_id = u.uid
  18. where
  19. u.age = 13
  20. and f.friend_age<>0
  21. group by f.friend_age
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement