如何在sql中从列中进行选择时以简写形式显示文本

Question

从员工表中选择部门时显示文本为BE而不是后端。

Answer 1

select
case department
when 'Backend' then 'BE'
else department
end as department
from
employee
;