Posts by KaynniN • 1 point

• -3

  votes

  1

  answer

  21

  views

  A: 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;…

  mysql sql mysqli select-sql mysql-workbench

  answered 2 years, 10 months ago KaynniN 1

• -4

  votes

  1

  answer

  21

  views

  Q: 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…

  mysql sql mysqli select-sql mysql-workbench

  asked 2 years, 10 months ago KaynniN 1