case-when

#1. 显示系统时间(注：日期+时间)
SELECT NOW();

#2. 查询员工号，姓名，工资，以及工资提高百分之 20%后的结果（new salary）
SELECT employee_id,last_name,salary,salary*1.2 "new salary"
FROM employees

#3. 将员工的姓名按首字母排序，并写出姓名的长度（length）
SELECT last_name,LENGTH(last_name) namelength
FROM employees
ORDER BY SUBSTR(last_name,1,1);

#4. 做一个查询，产生下面的结果
#<last_name> earns <salary> monthly but wants <salary*3>
#Dream Salary
#King earns 24000 monthly but wants 72000
SELECT CONCAT(last_name," earns ",salary," monthly but wants ",salary*3)
FROM employees
WHERE salary=24000;

#5. 使用 case-when，按照下面的条件：
job       grade
AD_PRES    A
ST_MAN     B
IT_PROG    C
SA_REP     D
ST_CLERK   E
产生下面的结果
Last_name    Job_id     Grade
king         AD_PRES      A
SELECT last_name,job_id,
CASE job_id
WHEN job_id='AD_PRES' THEN 'A'
WHEN job_id='ST_MAN 'THEN 'B'
WHEN job_id='IT_PROG' THEN 'C'
WHEN job_id='SA_REP'THEN 'D'
WHEN job_id='ST_CLERK'THEN 'E'
ELSE 'F'
END  AS Grade
FROM employees 
WHERE job_id='AD_PRES';