SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
select fa1.actor_id as act1, fa2.actor_id as act2, count(*) as cnt from film_actor fa1 join film_actor fa2 on fa1.film_id = fa2.film_id where fa1.actor_id != fa2.actor_id group by act1, act2 order by cnt

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear