#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';