SQL - COUNT and GROUP BY doubt

Question

I have the following question:

Select the first name (first_name) and title of the film (film) of all(s) the actors/actors/actresses (actor) associated(s) with the movies of the (Category) comedy (Comedy) category (use IN or ANY).

So far I’ve got this:

SELECT first_name, title, COUNT(*)

FROM ACTOR a, CATEGORY c, FILM f, FILM_CATEGORY fc, FILM_ACTOR fa

WHERE a.actor_id = fa.actor_id

AND fa.film_id = c.name in (‘Comedy’)

GROUP BY c.name;

The problem is that it shows nothing. It claims loss in connection with SQL, but I know it is some error in the code, I tried several ways but I could not.

Picture of the diagram:

Answer 1

Link to references: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_in

INNER JOIN Customers  on Orders.CustomerID = Customers.CustomerID
WHERE Customers.Country  IN ('Brazil', 'Argentina', 'Portugal')
GROUP BY Customers.Country;

Your code:

SELECT first_name, title, COUNT(*)

FROM ACTOR a, CATEGORY c, FILM f, FILM_CATEGORY fc, FILM_ACTOR fa

WHERE a.actor_id = fa.actor_id

AND fa.film_id = c.name in (‘Comedy’)

GROUP BY c.name;

some notes.
the total COUNT(*) it is necessary?
here fa.film_id = c.name is comparing id to the category name, I believe that would be fa.film_id = c.categoria_id

SELECT first_name, title, **COUNT(*)**

FROM ACTOR a, CATEGORY c, FILM f, FILM_CATEGORY fc, FILM_ACTOR fa

WHERE a.actor_id = fa.actor_id

AND **fa.film_id = c.name** in (‘Comedy’)

GROUP BY c.name;