Table: music_credits
Columns: year
artist
album
label
credit

Question: What album had the reunion label in 2006?
SQL: SELECT "album" FROM music_credits WHERE "label" = 'reunion' AND "year" = 2006

Question: Who was the artist for the album, Christmas under the reunion label with the guitar?
SQL: SELECT "artist" FROM music_credits WHERE "label" = 'reunion' AND "credit" = 'guitar' AND "album" = 'christmas'

Question: What is the most recent year for an album listed with a piano credited?
SQL: SELECT MAX("year") FROM music_credits WHERE "credit" = 'piano'