SQL 有条件分类汇总

SELECT * FROM (SELECT Sum(订单明细.金额) AS 金额之总计, Sum(订单明细.数量) AS 数量之总计, round(Sum(订单明细.重量)/1000,1) AS 重量之总计, 订单.订单ID FROM 订单 INNER JOIN 订单明细 ON 订单.订单ID=订单明细.订单ID GROUP BY 订单.订单ID)  AS 订单汇总
我现在需要对“订单明细表”中的“类型”字段过滤，即 订单明细.类型<>"赠送", 请问应该如何把这个条件加入以上SQL语句中，谢谢

SELECT * FROM (SELECT Sum(订单明细.金额) AS 金额之总计, Sum(订单明细.数量) AS 数量之总计, round(Sum(订单明细.重量)/1000,1) AS 重量之总计, 订单.订单ID FROM 订单 INNER JOIN 订单明细 ON 订单.订单ID=订单明细.订单ID where 订单明细.类型<>'赠送'  GROUP BY 订单.订单ID)  AS 订单汇总