I made this sql:
select t.teamnaam, l.roepnaam
from team t left outer join lid l on t.trainer = l.l_code
where t.teamnaam like 'H%'
UNION
select '---------', ''
UNION
select 'Aantal teams', string(count(teamnaam))
from team where teamnaam like 'H%'
UNION
select 'Aantal teams met trainer'...