/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 votes160 views1 answer
SQL column name Postgre
SQL
10 votes170 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote146 views1 answer
Mysql get longest string in column
SQL
0 vote154 views1 answer
How to create a table based on another table in mysql
SQL
0 vote135 views1 answer
If null don't update
SQL
1 vote147 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote148 views1 answer
Power bi union columns
SQL
0 vote130 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote148 views1 answer
Get last three characters in mysql column
SQL
0 vote166 views1 answer
Sql query inline if
SQL