I am just getting into Oracle DB scripting and the
the questions sound:
How many movies do not have information about genre?

I've tried this

select count(movie_id) from db.genre
where count(distinct genre) > 8;

but it returns and error:
Error code 934, SQL state 42000: ORA-00934: group function is not allowed here

the tabels are:
movie(id, title, year, kind, runtime, rating)
genre(movie_id, genre)

Would be lovely if someone could help me ;p

You want to select the movies which do not have their ID's inside the genre table. So something like:



Or something similar to that.