.操作要求:(1) 应用子查询了解“张小路”处理的订单的信息(订单号、订单时间、会员号、订单总额)。结果图:SQL语句:SELECT o_ID as 订单号,o_Date as 订单时间,c_ID as 会员号,o_Sum as 订单总额from Orders where e_ID = (SELECT Employees.e_ID as 编号from Employees WHERE e_Name= 张小路)(2) 应用子查询了解“张小路”处理的订单的详细信息(订单号、商品号、购买价格、购买数量)。结果图:SQL语句:SELECT o_ID AS 订单号,g_ID as 商品号,d_Price as 购买价格,d_Number as 购买数量from OrderDetails where o_ID IN(SELECT o_ID from Orders where e_ID IN(SELECT e_ID from Employees where e_Name = 张小路)(3)使用SELECT