oracle题

Question

Answer 1

SELECT
p_id , TIMESTAMPDIFF(YEAR,create_time,NOW()) '工作年限',
CASE WHEN TIMESTAMPDIFF(YEAR,create_time,NOW()) >= 5 THEN wages+wages*0.5
WHEN TIMESTAMPDIFF(YEAR,create_time,NOW())< 5 AND TIMESTAMPDIFF(YEAR,create_time,NOW()) >=3 THEN wages +wages*0.3
ELSE wages+wages*0.1
END '工资+奖金'
from t_test_table;