Table: powderfinger_hottest100
Columns: year
organisation
ceremony
award
result

Question: What's the award for #100?
SQL: SELECT "award" FROM powderfinger_hottest100 WHERE "result" = '#100'

Question: Which award was nominated for in 2000?
SQL: SELECT "award" FROM powderfinger_hottest100 WHERE "year" = 2000 AND "result" = 'nominated'

Question: What were the results before the year 2000?
SQL: SELECT "result" FROM powderfinger_hottest100 WHERE "year" < 2000