SQL练习（三）

16、查询80号部门中last_name以n结尾的所有员工信息

select * from employees WHERE	LAST_NAME LIKE '%n'

17、查询所有last_name由四个字母组成的员工信息

select * from employees WHERE	 LENGTH(LAST_NAME)>4

18、查询first_name中包含“na”的员工信息

select * from employees WHERE	 FIRST_NAME LIKE '%na%'or'%na'or'na%'

19、把hiredate列看作是员工的生日，求本月过生日的员工（考察知识点：单行函数）

select * from employees WHERE HIRE_DATE like '%05%'

20、把hiredate列看做是员工的生日，求下月过生日的员工（考察知识点单行函数）

select * from employees WHERE HIRE_DATE like '%06%'

21、请用三种以上的方式打印2021年入职的员工（考察知识点：单行函数）

①、select * from employees WHERE HIRE_DATE like '2021%'
②、select * from employees WHERE HIRE_DATE BETWEEN '2021-01-01' and '2021-12-31'
③、select * from employees WHERE HIRE_DATE not in (select HIRE_DATE from employees WHERE HIRE_DATE not BETWEEN '2021-01-01' AND '2021-12-31')