Posts by KaynniN • 1 point
2 posts
-
-3
votes1
answer21
viewsA: SELECT TWO COLUMNS THAT HAVE THE SAME ID IN DIFFERENT TABLES AND MAKE COMPARISONS
Solved using the code below = SELECT actor.first_name, Count(film_actor.actor_id) AS 'TOTAL' FROM actor INNER JOIN film_actor ON actor.actor_id = film_actor.actor_id GROUP BY film_actor.actor_id;…
-
-4
votes1
answer21
viewsQ: SELECT TWO COLUMNS THAT HAVE THE SAME ID IN DIFFERENT TABLES AND MAKE COMPARISONS
Good night Devs, I need to take each actor_id and film_id and check which total of movies(filme_id) has linked to actor_id and this I got : SELECT actor_id, COUNT(film_id) from film_actor group by…