[分享]047课后第三题

5dm

 

3. The HR department needs to find high-salary and low-salary employees. Modify lab_02_01.sql to display the last name and salary for any employee whose salary is not in the $5,000–$12,000 range. Place your SQL statement in a text file named lab_02_03.sql.

 

 

这个题除了用大于多少小于多少的条件外，还可以这么写：

select last_name,salary from employees where salary not between 5000 and 12000;