Table: nhl_game_stats_23
Columns: date
visitor
score
home
decision
attendance
record

Question: For all games with los angeles as visitor, what is the highest attendance of all?
SQL: SELECT MAX("attendance") FROM nhl_game_stats_23 WHERE "visitor" = 'los angeles'

Question: For all games with calgary as home, what is the average number of attendees?
SQL: SELECT AVG("attendance") FROM nhl_game_stats_23 WHERE "home" = 'calgary'