第1关:基本查询语句
USE Company;
#请在此处添加实现代码
########## Begin ##########
########## retrieving the Name and Salary ##########
select Name,Salary
From tb_emp;
########## retrieving all the table ##########
select *
From tb_emp;
########## End ##########
第2关:带 IN 关键字的查询
USE Company;
#请在此处添加实现代码
########## Begin ##########
########## retrieving the Name and Salary with IN statement ##########
select Name,Salary
from tb_emp
where id not in (1);
########## End ##########
第3关:带 BETWEEN AND 的范围查询
USE Company;
#请在此处添加实现代码
########## Begin ##########
########## retrieving the Name and Salary with BETWEEN AND statement ##########
select Name,Salary from tb_emp where Salary > 3000 and Salary < 5000;
########## End ##########