The CASE statement functions similarly to an if/else statement in programming. It uses WHEN and THEN clauses to define specific conditions. You can specify multiple…