select
c_name,
translate(substr(deal_time,1,7), "/", " "),
price
count(case when price<500000 then 1 else 0 end) as "C",
count(case when price>=500000 && price<800000 then 1 else 0 end) as "B",
count(case when price>=800000 then 1 else 0 end) as "A"
from houses_number,org_number
where houses_number.district_id=org_number.s_num
group by c_name,translate(substr(houses_number.deal_time,1,7), "/", " ")
;
FAILED: ParseException line 5:5 missing EOF at '(' near 'count'