/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 vote160 views1 answer
Como leer datos de mysql esp32
SQL
14 votes225 views2 answers
Oracle add attribute to table
SQL
0 vote240 views1 answer
Display all node label neo4j
SQL
6 votes259 views2 answers
Install psql mac
SQL
2 votes192 views1 answer
While loop sql
SQL
0 vote213 views1 answer
How to get nth number in sql
SQL
0 vote226 views1 answer
How to check default value of column in sql server
SQL
0 vote207 views1 answer
Sql doesn't contain
SQL
6 votes200 views2 answers
Mysql convert timestamp to date
SQL
1 vote223 views1 answer
Mysql remove last empty newline
SQL