sql语句的统计按天，按月，按年 多表统计一个表展示

select days '日期',sum(sumPearn) '销售量',sum(sumfirstEarn) '销售额',sum(sumPearn-sumfirstEarn) from (
select DATE_FORMAT(createDate,'%Y-%m-%d') days,sum(pearn) sumPearn,0 sumfirstEarn from member_order group by days
UNION ALL
select DATE_FORMAT(createDate,'%Y-%m-%d') days,0 sumPearn,sum(firstEarn) sumfirstEarn from member_earn group by days
) a GROUP BY days

按天统计 就是%Y-%m-%d
按月统计 就是%Y-%m
按年统计 就是%Y
sum(sumPearn-sumfirstEarn) 可计算