Advertisement
Guest User

Untitled

a guest
Apr 30th, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.35 KB | None | 0 0
  1. select name
  2. from (
  3. select name,count(*) as cont
  4. from category natural join film
  5. where category.category_id=film.category_id
  6. group by name
  7. having cont = (select max(cont) from(select name, count(*) as cont
  8.               from category natural join film
  9.           where category.category_id=film.category_id
  10.           group by name)as a)
  11. )as aux
  12. order by 1 asc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement