SQLite Forum

Select and count from 2 tables
Login
Good day,

I am trying to find how many movies are both in the genre "Romance" and "Comedy"

I have a table here (https://i.imgur.com/dPJpZTb.jpg) and I am trying to find the answer, but my statement seems to be wrong. (https://i.imgur.com/xvbKCJy.jpg)