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!