blob: 6c72b90a64a9d834af186bc5925dfc1c14f4840c (
plain)
1
2
3
4
5
6
7
8
9
|
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;
|