/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 vote227 views1 answer
Power query case when
SQL
1 vote231 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote242 views1 answer
Mysql sum per week
SQL
0 vote227 views1 answer
Mysql vs sql server performance benchmark
SQL
10 votes232 views1 answer
User_dependencies
SQL
5 votes218 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote230 views1 answer
Mysql error 1251
SQL
0 vote224 views1 answer
Sql server pivot rows to columns
SQL
0 vote251 views1 answer
Sql today at midnight
SQL
-1 vote170 views1 answer
Mysql how to set update or create
SQL