#4 Filtering Rows - Learn SQL with SQLite in Python

[@richardbennett4365]

At 3:03, he said he only cares about the year as long as it is over 1985. He means over 1984, or he has to change his code, because he's not going to get what he says with his code.

[@TMQuest]

Thanks for pointing this out. I meant over or equal as you pointed out, but just said over. Sometimes the word "over" in casual language can mean either "strictly over" or "over or equal". When people say "I have over 100 baseball cards", they would mean strictly over. But when saying "I would only date someone over 30 years old", most would interpret this as over or equal. I will try to use more precise phrasings in the future :)

[@richardbennett4365]

Thanks, but be careful what you say versus what you typed. The presenter said at 2:25 that the print statement returned all songs "higher" than 1985. The song isn't higher. The date is equal to or greater than 1985 or the songs returned have a date greater than 1984, because he corded >= not >. It is why "Take On Me" is included in the output.