@ANYANNY02 The errors you are getting is because of bad quoting - " instead of using '.
You are basically asking for this:
https://github.com/metabase/metabase/issues/5245 - upvote by clicking 
on the first post
If you want dropdowns currently, then you'll need to create a table, which contains the values you need.
Have a look here: How to create a SQL filter variable to change date grouping between month/week/day