/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 votes353 views2 answers
Mysql get time from datetime
SQL
8 votes366 views1 answer
How to remove tables from postgresql
SQL
-1 vote371 views5 answers
Online sql to linq generator
SQL
0 vote351 views1 answer
MySql get primary keys of table
SQL
2 votes351 views1 answer
Postgresql drop primary key constraint
SQL
0 vote364 views1 answer
Update view sql
SQL
37 votes368 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
2 votes368 views1 answer
How to delete view in sql
SQL
0 vote337 views2 answers
Select limit ms sql
SQL
1 vote357 views2 answers
ImportError: No module named mysql.connector
SQL