Count the number of user events performed by MacBookPro users. Output the result along with the event name. Sort the result based on the event count in the descending order.
table name: playbook_events
Solution:
select event_name,count(user_id) as EventCount from playbook_events
where device='macbook pro' group by event_name order by count(user_id) desc;