It's probably because it's trying to guess what the filter condition should be and uses the wrong casing for the genre (should be "Sci-Fi", not "sci-fi"). At least that's what happened when I tried your prompt a couple of times.
Sometimes it gets the casing correct by accident straight away, other times it struggles. When it does struggle, I just keep typing "fix" in the chat, and eventually it figures it out. Sometimes it asks me to run a query to determine the distinct set of genres, sometimes it just decides to lowercase the genre column in the filter condition.
I tried to ask: "Recommend me great sci-fi movies from 2010 to 2024". It generated a SQL script for me to execute which unfortunately doesn't work.