多选题

有以下结果表tt_tmp，数据如下 gt,result ---------...

Question

有以下结果表tt_tmp，数据如下
gt,result
-----------------------
2018-05-19 S
2018-05-19 S
2018-05-19 F
2018-05-19 F
2018-05-20 S
2018-05-20 F
2018-05-20 F

需要统计以下结果
gt  success failure
2018-05-19 2 2
2018-05-20 1 2

sql语句怎么写（）

A. select gt, sum(case when result='S' then 1 else 0 end)'success',
sum(case when result='F' then 1 else 0 end)'failure' from tt_tmp group by gt

B. select s.gt,s.success,f.failure from
(select gt,count(*) as 'success' from tt_tmp where result='S'group by gt) s inner join

(select gt,count(*) as 'failure' from tt_tmp where result='F'group by gt)

on s.gt=f.gt

C. select gt, sum(case when result='F' then 1 else 0 end)'success',
sum(case when result='S' then 1 else 0 end)'failure' from tt_tmp group by gt

D. select s.gt,s.success,f.failure from
(select gt,count(*) as 'success' from tt_tmp where result='S'group by gt) s,
(select gt,count(*) as 'failure' from tt_tmp where result='F'group by gt) f where s.gt=f.gt