Query: youtube_channel_distribution_type

select
  channel_type,
  count(*) as NumberOfChannels
from
  youtube_statistics
group by
  channel_type
order by
  NumberOfChannels desc;