SELECT
	SUM( aaa.num),订单.订单申请人 
FROM
	(
	SELECT
		b.产品数量 *b.产品单间 AS num,a.订单申请人 
	FROM
		ORDER  a
		LEFT JOIN orderitime  b ON a.订单 id =b.订单 id 
	WHERE
	a.订单收货国家 NOT IN ('英国','法国') and month(a.订单申请时间) in ('4','5') )aaa group by aaa.订单申请人