I am at a complete loss for something that should be very simple to find in SQLite. In the IMDB database, I have to find how many actors have the name 'Meryl', I have tried
select name, count(name) from people where name='Meryl'; and
select count(name) from people where name='Meryl'. Nothing comes up even though I know for a fact there are 15 in the database because I have counted.
I have tried with other names and it works fine and even with Meryl Streep and it works. I don't know what I'm doing wrong. Please help!