How to use the variable haiving set of values in a spark.sql?

Daniel3
New Contributor II

Hi, I have a set of values to be searched from a table, for which i was trying to assign them to a variable first and then trying to use the variable in spark.sql, but i'm unable to fetch the records. Please see the image attached and correct my code please.