#常见函数练习题
#显示系统时间
SELECT NOW();
#2.
SELECT employee_id
,last_name
,salary
,salary
*1.2 “new Salary”
FROM employees;
#3.
SELECT
last_name
,
LENGTH(last_name
) namelength
FROM
employees
ORDER BY SUBSTR(last_name
, 1, 1) ASC ;
#4.
SELECT
CONCAT(
last_name
,
’ earns ',
salary
,
’ monthly but want ',
salary
* 3
) “Dream Salary”
FROM
employees
;
#5
常量值必须有’'包围起来
SELECT
last_name
Last_name,
job_id
Job_id,
CASE
job_id
WHEN ‘AD_PRES’
THEN ‘A’
WHEN ‘ST_MAN’
THEN ‘B’
WHEN ‘IT_PROG’
THEN ‘C’
WHEN ‘SA_REP’
THEN ‘D’
WHEN ‘ST_CLERK’
THEN ‘E’
ELSE ‘F’
END Grade
FROM
employees
ORDER BY Grade;