Query: starwars_starship_manufacturer_distribution

select
  manufacturer,
  count(*) as "Number of Starships"
from
  starships
group by
  manufacturer;