Table: australian_football_championships
Columns: year
champion
runner_up
score
venue

Question: What score has a year later than 1974, with hawthorn as the champion?
SQL: SELECT "score" FROM australian_football_championships WHERE "year" > 1974 AND "champion" = 'hawthorn'

Question: What champion has north melbourne as the runner-up?
SQL: SELECT "champion" FROM australian_football_championships WHERE "runner_up" = 'north melbourne'