我对sql非常陌生，有一个关于足球数据库的问题，该数据库包含以下表格：

Create Table Team(
TId char(3) Primary Key,                       // One example for a TId is "GER". It is an abbrevation for the country
Country varchar(50) Not Null,
Coach varchar(50) Not Null
)

Create Table Match(
MId Integer Primary Key,                      // Every match has an ID
Date date Null,
Stadium varchar(100) Not Null,
Team1 char(3) Not Null,
Team2 char(3) Not Null,
Foreign Key(Team1) references Team(TId),
Foreign Key(Team2) references Team(TId)
);

Create Table Goal(
MId Integer Null,
TId char(3) Null,
Player varchar(100) Not Null,
Minute Integer Null,
Primary Key(MId, Minute),
Foreign Key(MId) references Match(MId),
Foreign Key(TId) references Team(TId)
);

我需要编写一个sql查询，返回所有比赛的列表，包括日期、球场和两队的进球数。应该是这样的

Select date, stadium, Team1, Count(Goals Team1), Team2, Count(Goals Team2) 

From match

...

我试着先开始计算一个团队的进球数，想用一个案例来说明，但没能做到：

Select s.SId, s.Team1,
Case When s.SId IN (Select distinct SId From Tor) Then Count(t.SId) 
Else "Not In"   
End As text
From Spiel s, Tor t, Team te
Where s.SId = t.SId
Group by s.SId

如果你知道怎么做我会很高兴的。提前谢谢。