create or replace view NFS_Excel as
select
	Merk.Naam as "Merk",
	`Type`.Naam as "Type",
	round(`Type`.Vermogen * 1.3637) as "Vermogen [pk]",
	`Type`.Vermogen as "Vermogen [kW]",
	concat(Locatie.Naam, ", ", Land.Naam) as "Hoofdkantoor"
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;
