Change Password

What is the purpose of the SQL CASE statement, and how is it used in queries?
To filter results based on a condition
To perform conditional logic within a query and return different values based on specified conditions
To join multiple tables
To sort results in descending order