Alternative Methods to SQL Switch/Case in the WHERE Clause
Purpose:The SWITCH/CASE statement in SQL is used to create conditional expressions within the WHERE clause of a query.It allows you to specify multiple conditions and execute different actions based on which condition is met