현재 버전

select media ,sum(cnt) as cnt

from view

where 1=1

group by media

having media='a미디어' or 'b미디어'

order by media asc, cnt desc


수정 이력

2020-06-09 14:08:45 에 아래 내용에서 변경 됨 #1

select media ,sum(cnt) as cnt

from view

where 1=1

group by media

having media='a미디어' or 'b미디어'

order by a미디어 asc, cnt desc