我试着解决这个问题:“根据他在公司工作的年数来查询他的姓名和奖金:如果他在公司工作了1到5年,他将得到100欧元;如果他在6到10年之间,他每年将得到50欧元;如果他有11到20年,他每年将得到70欧元。如果他超过21年,他将每年获得100欧元。” SELECT name, (EXTRACT(YEAR FROM SYSDATE)-EXTRACT(YEAR FROM admissiondate))*(CASE EXTRACT(YEAR FROM SYSDATE)-EXTRACT(YEAR FROM adm
我在下面有疑问, WHEN floor(months_between(CAL_DATE, BIRTH_DATE) / 12) BETWEEN 0AND 20 WHEN floor(months_between(CAL_DATE, BIRTH_DATE) / 12) BETWEEN 21AND 30 WHEN floor(months_b
SELECTMONTHS_BETWEEN (business_dt, CAST(LOYALITY_START_DATE_CRM AS DATE))MONTHS_BETWEEN(business_dt, CAST(LOYALITY_START_DATE_CRM AS DATE)) > 0 MONTHS_BETWEEN (business_dt, CAST(LOYALITY_START_DATE_CRMAS DATE)) < 3 then 'onboarding'
WHEN