group by로 묶어서 where로 찾기

where ~ like '%~' and ~
group by ~

select payment_method, count(*) from orders
where email like '%naver.com' and course_title = '앱개발 종합반'
group by payment_method