select
	Land.Naam,
	count(`Type`.ID) as "Aantal types"
from `Type`
left join Merk on Merk.ID = `Type`.MerkID
left join Hoofdkantoor on Hoofdkantoor.MerkID = Merk.ID
left join Locatie on Locatie.ID = Hoofdkantoor.LocatieID
left join Land on Land.ID = Locatie.LandID
group by Land.ID;
