what team pays the lowest average salary?
select * from team as t1 join salary as t2 on t1.team_id = t2.team_id group by t1.team_id order by avg ( t2.salary ) asc limit 1
thanks..how about one last one...what is median salary across all teams?
select avg ( salary ) from salary
Team salaries
select count ( distinct team_id ) from salary