SELECT cust_last_name,
   CASE substr(acc_num, 10, 1) 
   WHEN '1' THEN 'C'
   ELSE 'M' END
   FROM customers;

compare

SELECT AVG(CASE WHEN e.salary > 2000 
           THEN e.salary

   ELSE 2000 END) "Average Salary" FROM employees e;