Table: badfinger_songs
Columns: year
song
us_hot_100
uk_singles
album

Question: Which Year has an Album of airwaves, and a US Hot 100 of –?
SQL: SELECT MAX("year") FROM badfinger_songs WHERE "album" = 'airwaves' AND "us_hot_100" = '–'

Question: Which Song has a Year smaller than 1979, and a US Hot 100 of 8?
SQL: SELECT "song" FROM badfinger_songs WHERE "year" < 1979 AND "us_hot_100" = '8'