We can solve this problem by CASE ... WHEN ... THEN ... END;