Table: song_chart_positions
Columns: year
title
singapore_987fm_top_position
singapore_power98_top_position
album

Question: What album came out before 2008 called We're not Made in the USA?
SQL: SELECT "album" FROM song_chart_positions WHERE "year" < 2008 AND "title" = 'we''re not made in the usa'

Question: What is the average year for Faces?
SQL: SELECT AVG("year") FROM song_chart_positions WHERE "title" = 'faces'