数据库实训操作题参考答案.docVIP

销售管理数据库的操作题 销售管理数据库的数据查询 1.查询员工王娜所在的部门。 select DepartmentName from Department where DepartmentID=(select DepartmentID from Employee where EmployeeName=姚安娜)select EmployeeName 姓名,Sex 性别,BirthDate 出生年月,Salary 工资 from Employee where BirthDate=(select MAX(BirthDate) from Employee) --年龄最小就是出生年月最大，利用嵌套查询，查询最大出生年月Select EmployeeName 姓名,Salary 工资 from Employee where EmployeeID in(select EmployeeID from Sell_Order)Select Employee.* from Employee where exists (select * from Sell_Order where Sell_Order.EmployeeID=Employee.EmployeeID) 4.查询订购“牛奶”的客户信息。（用两种方法做：嵌套查询、连接查询） --嵌套查询： select CompanyName 公司名称,Co