(8) 查找定单金额高于8000的所有客户编号。 命令：
select CustomerNo
from OrderDetail as a,OrderMaster as b where a.orderNo =b.orderNo group by CustomerNo
having sum(quantity *price )>8000 结果：
(9) 选取编号界于“C20050001”和“C20050004”的客户编号、客户名称、客户地址。 命令：
SELECT CustomerNo ,CustomerName ,address FROM Customer
WHERE CustomerNo BETWEEN 'C20050001' AND 'C20050004' 结果：
(11) 找出同一天进入公司服务的员工。 命令：
select hireDate ,employeeName from Employee as a where exists
(select * from Employee as b
where a.hireDate =b.hireDate and a.employeeNo !=b.employeeNo ) group by hireDate ,employeeName 结果：