The Use of CASE Statements

WHEN: takes the condition you want to evaluate THEN: displays the result of the condition evaluated ELSE: this is the result that gets displayed if the when condition stated are not met END AS: the name of the column that displays the result SELECT C...