我将sql查询编写为
SELECT
pj.PROJECT_ID,
SUM(hr.HOURS) as totalhours,
hr.week,
hr.week as YEAR_Week,
max(rl.IHC_OR_EXTERNAL) as IHC,
max(rl.COMPANY_NAME) as companyName,
max(pj.PROJECT_SEGMENT)
我如何加入这两个选择,并得到该年度的每个团队的和(Hr)在同一栏和和(Hr)在同一年度在不同的一列?
select yearID, TeamID, sum(HR) as TeamTHR
from vwPlayersBatting
group by yearID,teamID
order by yearID
select YearID, sum(hr) as tt
from vwPlayersBatting
group by yearID
order by yearID