If statement in sq-lite

I have a database of members who are in a club. One of the columns is if they are active or no (the column has data 'yes' or 'no'). I want to write a query where it only selects members who are active. How do I write a query for? I have come up with the following code, If it is wrong please correct it for me.

CASE Yes when Active then select * from StudentData

Note-
Active - name of column
StudentData - name of table