A. To filter rows based on a condition
B. To perform conditional logic within a query
C. To create a new table
D. To join tables based on a condition

Solution

B. To perform conditional logic within a query