/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 vote224 views1 answer
Postgres row expiration
SQL
11 votes196 views3 answers
Sql line numbers
SQL
1 vote349 views1 answer
Postgres convert text to number
SQL
4 votes164 views3 answers
Mysql update with join
SQL
1 vote191 views5 answers
Sql 2nd highest salary
SQL
0 vote178 views2 answers
How to display enum value sql server
SQL
2 votes168 views2 answers
Exec procedure pl sql
SQL
6 votes193 views3 answers
What is where in sql
SQL
10 votes163 views4 answers
Join with multiple conditions sql
SQL
1 vote212 views1 answer
Postgresql blocked on mac
SQL