员工表 WORKER_ID FIRST_NAME LAST_NAME SALARY JOINING_DATE DEPARTMENT 1 Monika Arora 100000 2014-02-20 09:00:00 HR 2 Niharika Verma 80000 2014-06-11 09:00:00 Admin 3 Vishal Singhal 300000 2014-02-20 09:00:00 HR 4 Amitabh Singh 500000 2014-02-20 09:00:00 Admin 5 Vivek Bhati 500000 2014-06-11 09:00:00 Admin 6 Vipul Diwan 200000 2014-06-11 09:00:00 Account 7 Satish Kumar 75000 2014-01-20 09:00:00 Account 8 Geetika Chauhan 90000 2014-04-11 09:00:00 Admin 奖金表 WORKER_ID BONUS_DATE BONUS_AMOUNT 1 2016-02-20 00:00:00 5000 2 2016-06-11 00:00:00 3000 3 2016-02-20 00:00:00 4000 1 2016-02-20 00:00:00 4500 2 2016-06-11 00:00:00 3500 职称表 WORKER_ID WORKER_TITLE AFFECTED_FROM 1 Manager 2016-02-20 00:00:00 2 Executive 2016-06-11 00:00:00 8 Executive 2016-06-11 00:00:00 5 Manager 2016-06-11 00:00:00 4 Asst. Manager 2016-06-11 00:00:00 7 Executive 2016-06-11 00:00:00 6 Lead 2016-06-11 00:00:00 3 Lead 2016-06-11 00:00:00 题目1: 查询所有薪水在5万到10万之间(含)的员工全名和薪水,请将SQL和预期的结果集写下来。
时间: 2023-03-14 21:05:26 浏览: 326
SELECT FIRST_NAME,LAST_NAME,SALARY FROM WORKER_ID WHERE SALARY BETWEEN 50000 AND 100000;
FIRST_NAME LAST_NAME SALARY
Monika Arora 100000
Niharika Verma 80000
Vishal Singhal 300000
Amitabh Singh 500000
Vivek Bhati 500000
Vipul Diwan 200000
Satish Kumar 75000
Geetika Chauhan 90000
阅读全文