Hi @JasonYu
Happy to help! A couple of follow up questions:
What resource type is this (Postgres, Retool Database, Mysql, etc)?
For the last line (IN), we have a cheatsheet that shows the commonly used syntax options SQL Cheatsheet - best practices for different flavors of SQL syntax
For example, when running the second query in Retool Database, I have to change IN to = ANY and then it works 
As noted in the cheatsheet, this syntax quirk has to do with the prepared statements handling of dynamic values