select a.手机品牌,a.手机型号,sum(1) as 销售数量,sum(销售价格) as 销售额 from a join b on a.手机序列号=b.手机序列号 and b.售出日期 between '2004-1-1 00:00:00' and '2004-2-2 23:59:50' group by a.手机品牌,a.手机型号
select a.手机品牌,a.手机型号,count(b.手机序列号) as 销售数量,sum(b.销售价格) 销售额 from 表A a Join 表B b on a.手机序列号=b.手机序列号 group by a.手机品牌,a.手机型号
销售额 from 表A a
Join 表B b on a.手机序列号=b.手机序列号
group by a.手机品牌,a.手机型号