/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 vote350 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote353 views1 answer
Show the colums of table sql
SQL
0 vote331 views1 answer
Inner joint
SQL
10 votes328 views4 answers
Join with multiple conditions sql
SQL
18 votes337 views6 answers
Drop table if exists
SQL
0 vote347 views1 answer
Mysql select inside sum
SQL
0 vote356 views1 answer
How to find total working hour in sql
SQL
0 vote368 views1 answer
Mysql record group by created date count
SQL
0 vote322 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
18 votes344 views6 answers
Laravel form validation
SQL