/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

0 vote335 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote391 views1 answer
TSQL Find csv file in folder
SQL
3 votes293 views4 answers
Mysql delete duplicate rows
SQL
2 votes303 views1 answer
Sql update from different table
SQL
0 vote338 views1 answer
Declare or use variable in snowflake
SQL
0 vote284 views1 answer
Drop check command
SQL
-1 vote322 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote310 views1 answer
Sql character index
SQL
0 vote322 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
14 votes324 views1 answer
Excel
SQL