/SQL/Sql Top 5 sutradara dengan filem terbanyak

Sql Top 5 sutradara dengan filem terbanyak

SELECT director.dir_id,director.dir_fname,director.dir_lname,movie_direction.mov_id FROM director INNER JOIN movie_direction WHERE director.dir_id=movie_direction.dir_id GROUP BY director.dir_fname ORDER BY movie_direction.dir_id LIMIT 5;

Similar codes

25 votes221 views6 answers
Import database mysql command line
SQL
57 votes834 views6 answers
Sql alter table
SQL
0 vote214 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
1 vote191 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote181 views2 answers
How to tun mysql on ubunto
SQL
2 votes171 views1 answer
Sql server find table name
SQL
0 vote214 views1 answer
How to find symmetric pairs in sql
SQL
20 votes228 views4 answers
How to find average in sql
SQL
0 vote287 views1 answer
Get statis values sql
SQL
0 vote170 views1 answer
Mysql find foreign key references
SQL