I have to made a result of soccerteams who does NEVER played on field 1
There are 3 tables that can be used for this one (the connections)
table 1 named: team table 2 named: game table 3 named: home
t_code g_code...
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'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.