Multiple column filter dropdown in metabase using SQL query

I need to create a dashboard in Metabase on the basis of few filters getting selected from drop down creating through SQL query on a single table. How can we achieve this …Need the SQl query format please

Hi @abhi1986
Have a look here:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html