(select o_id from orders where e_id in (select e_id from employees
where employees.e_name='张小路'))
3.使用select···into语句将orderdetails表中的记录备份到od_temp select * into od_temp from orderdetails
4.统计订单详情表中的商品的平均售价和商品总数量并存放在sale中 create table sale(g_id char(6),a_avg float) go insert sale
select g_id,AVG(d_price) from orderdetails group by g_id
5.将“张小路”所处理的订单状态（O_status）全部修改为Ture update orders set o_status='True' where '张小路'=
(select e_name from employees where orders.e_id=employees.e_id)