/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

2 votes183 views1 answer
Oracle apex who is connected
SQL
1 vote206 views1 answer
Check if mysql is installed
SQL
16 votes188 views2 answers
Sql vs nosql
SQL
0 vote164 views1 answer
Start and stop mysql
SQL
0 vote168 views1 answer
Price-colour
SQL
0 vote188 views2 answers
Collation in sql
SQL
0 vote170 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote167 views3 answers
ChAnge TABLE name apex oracle
SQL
19 votes270 views5 answers
Mysql between date range
SQL
0 vote213 views1 answer
How to create notes in mysql
SQL