按表t_case中start_time（datatime）字段和end_time（datatime）字段每个年份 每个月 出现的次数 的sql语句
表结构
id   start_time  end_time
1    2015-2-1    null
2    2015-2-2    2015-6-6
3    2014-1-1    2015-2-3
4    2011-3-2    2014-1-12
结果为
year  month  startsum  endsum
2011  3       1        0
2014  1       1        1
2015  2       2        1
2015  6       0        1
求这个查询的sql谢谢了  

这是我写的查的start_time的sql

SELECT date_format(start_time,'%Y-%m') bb, SUM(1)  aa
FROM t_case
GROUP BY date_format(start_time,'%Y-%m')

怎么加end_time 呢？

搞定了  虽然没有人看  这一版的人还真少呢

SELECT date_format(start_time,'%Y-%m') as caseTime, SUM(1) as count,'lian' type
FROM t_case
WHERE date_format(start_time,'%Y')=2015 OR date_format(start_time,'%Y')=2014
GROUP BY date_format(start_time,'%Y-%m')

union all

SELECT date_format(end_time,'%Y-%m') as caseTime, SUM(1) as count, 'jiean' type
FROM t_case
WHERE date_format(end_time,'%Y')=2015 OR date_format(end_time,'%Y')=2014
GROUP BY date_format(end_time,'%Y-%m')

select month1,sum(counta) counta,sum(countb) countb
from
(
SELECT date_format(start_time,'%Y-%m') month1, sum(1) counta,0 countb
FROM test.t_case
GROUP BY date_format(start_time,'%Y-%m')
union all
SELECT date_format(end_time,'%Y-%m') month1,0 counta,sum(1) countb
FROM test.t_case
GROUP BY date_format(end_time,'%Y-%m')
) s
group by month1