Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select name
- from (
- select name,count(*) as cont
- from category natural join film
- where category.category_id=film.category_id
- group by name
- having cont = (select max(cont) from(select name, count(*) as cont
- from category natural join film
- where category.category_id=film.category_id
- group by name)as a)
- )as aux
- order by 1 asc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement