#Function
CASE WHEN

SELECT id, 
       CASE status
           WHEN 'active' THEN 'Active Member'
           WHEN 'inactive' THEN 'Inactive Member'
           ELSE 'Unknown Status'
       END AS membership_status
FROM users;