Table schema:
CREATE TABLE table_name_97 (crowd INTEGER, home_team VARCHAR)

Question: What is the average crowd for the home team of North Melbourne?
SQL: SELECT AVG(crowd) FROM table_name_97 WHERE home_team = "north melbourne"