[SQL문제풀기] MacBookPro User Event Count

문제

StrataScratch - MacBookPro User Event Count

StrataScratch

https://platform.stratascratch.com/coding/9653-count-the-number-of-user-events-performed-by-macbookpro-users?code_type=3

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select event_name, count(user_id) event_count
from playbook_events 
where device = 'macbook pro'
group by event_name
order by 2 desc;