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 act1 != act2 group by act1, act2

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear