Miscellany

SELECT pp.person_id, p.person_key, dn.full_name, ihos.points-ihos.assists AS goals, ihos.assists, ihos.points, pp.regular_position_id, pos.abbreviationFROM stats s, persons p, display_names dn, ice_hockey_offensive_stats ihos, sub_seasons ss, seasons, positions pos, person_phases ppWHERE s.stat_repository_type = 'ice_hockey_offensive_stats'AND s.stat_repository_id = ihos.idAND s.stat_coverage_type = 'sub_seasons'AND s.stat_coverage_id = ss.idAND ss.season_id = seasons.idAND ss.sub_season_type = 'season-regular'AND seasons.season_key = '2007'AND dn.entity_type = 'persons'AND dn.entity_id = p.idAND s.stat_holder_id = p.idAND pp.person_id = p.idAND pp.regular_position_id = pos.idORDER BY dn.full_name