答案：#1、查询支出在50-150之间的员工信息 SELECT * FROM `salary` WHERE `OutCome` BETWEEN 50 AND 150; #2、查询财务部、研发部、市场部的员工信息 #5种做法 SELECT * FROM `employees` WHERE `DepartmentID` IN (SELECT `DepartmentID` FROM `departments` WHERE `departments`.`DepartmentName` IN ('财务部','研发部','市场部')); SELECT * FROM `employees` JOIN `departments` ON `employees`.`DepartmentID`=`departments`.`DepartmentID` WHERE `departments`.`DepartmentName` IN ('财务部','研发部','市场部') SELECT * FROM `employees` ,departments WHERE `departments`.`DepartmentName` IN ('财务部','研发部','市场部') AND `employees`.`DepartmentID`=`departments`.`DepartmentID`; SELECT * FROM `departments` WHERE `DepartmentName` IN ('财务部','研发部','市场部'); SELECT * FROM `employees` WHERE `DepartmentID` IN('1','4','5'); #3、显示工作年限三年以上(含3年)、学历在本科以上(含本科)的男性员工的信息 SELECT * FROM `employees` WHERE `WorkYear`>=3 AND `Education`!='大专' AND `Sex`='1'; SELECT * FROM `employees` -- where (`WorkYear`>=3)&&(`Education` in ('本科','硕士')&&(`Sex`='1')); WHERE (`WorkYear`>=3)&&(`Education`'大专'&&(`Sex`='1')); #4、查找员工编号中倒数第二个数字为0的姓名、地址和学历 SELECT `EmployeeID`,`Name`,`Address`,`Education` FROM `employees` WHERE `EmployeeID` LIKE '%0_'; #5、查找地址中包含’中山路’ 的员工的信息 SELECT * FROM `employees` WHERE `Address` LIKE '%中山路%';
