/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 vote139 views1 answer
Mysql server not running
SQL
0 vote136 views1 answer
Rabbitmq ui not working
SQL
0 vote125 views1 answer
Oracle list of long running queries
SQL
-1 vote142 views4 answers
Restart mysql server ubuntu
SQL
-2 votes131 views3 answers
Oracle tablespace usage
SQL
1 vote134 views1 answer
Md5 encryption for existing records
SQL
1 vote153 views3 answers
Date_add mysql
SQL
0 vote133 views1 answer
Sql server express download
SQL
0 vote128 views1 answer
Can we rollback deleted data in sql
SQL
14 votes160 views6 answers
Finding duplicate rows mysql
SQL