sql ora-00937异常 请高手过目

Question

SELECT
to_char(t.sttime, 'yyyy-mm-dd') AS NEWSTTIME,
--count(t.Status) as s1
--decode(t.Status,0, count(t.Status),1,count(t.Status),0) as s1
sum(case t.Status when 0 then count(t.Status) end) s1,
sum(case t.Status when 1 then count(t.Status) end) s2
FROM
TIME_MONITOR t
GROUP BY
to_char (t.sttime, 'yyyy-mm-dd')
,t.Status
order by
NEWSTTIME

Answer 1

SELECT to_char(sttime, 'yyyy-mm-dd') AS NEWSTTIME,
count(case Status when 0 then Status end) s1,
count(case Status when 1 then Status end) s2
FROM TIME_MONITOR
GROUP BY to_char (sttime,'yyyy-mm-dd')
order by NEWSTTIME;