Query: youtube_channel_subscriber_vs_video_view_by_category

select
  category,
  sum(subscribers) as TotalSubscribers,
  sum(video_views) as TotalVideoViews
from
  youtube_statistics
group by
  category
order by
  TotalSubscribers, TotalVideoViews desc;