CREATE TABLE table_name_18 (home_team VARCHAR2, away_team VARCHAR2)

If the Away team is north melbourne, what's the Home team score?
SELECT home_team AS score FROM table_name_18 WHERE away_team = "north melbourne"
SELECT "home_team" AS "score" FROM "table_name_18" WHERE "away_team" = "north melbourne"