SELECT t.team_key, SUM( bos.points_scored_total )FROM basketball_offensive_stats bosJOIN stats s ON s.stat_repository_id = bos.idJOIN persons p ON s.stat_holder_id = p.idJOIN person_phases pp ON pp.person_id = p.idJOIN teams t ON t.id = pp.membership_idJOIN sub_seasons subs ON subs.id = s.stat_coverage_idWHERE s.stat_repository_type = 'basketball_offensive_stats'AND s.stat_holder_type = 'persons'AND subs.sub_season_key = '2007_season_regular'AND t.team_key LIKE 'l.nba%'GROUP BY t.team_key