我有一个mysql表,明确在不同的市场上销售产品.
Date Marketplace Sale
1 flipkart 1000
1 flipkart 500
1 amazon 200
1 amazon 1500
1 amazon 700
2 myntra 500
2 flipkart 1000
我想要一个单独的mysql声明,它给我一个月的不同市场(亚马逊,flipkart等)的日期明确销售,就像在这种情况下
上
1月份flipkart毛销量为1500(1000 500),亚马逊毛销售2400(1500 700 200)
我有这个问题:
SELECT date, (Select sum(gross_sale) from sku where marketplace='flipkart') as flipkart, (Select sum(gross_sale) from sku where marketplace='Myntra') as myntra, sum(gross_sale) as countdate FROM sku WHERE date >= '2017-11-01' AND
date <= '2017-11-30' GROUP BY date ORDER BY date ASC limit 30 ;
但是,选择子查询并没有给出日期明确的分布,而是给出了月份的总销售额.如何解决这个问题.请帮忙.提前致谢.