Table: duffy_discography
Columns: year
song
album_appearance
album_artist
notes

Question: What is the lowest Year, when Notes is "Spanish adaptation of "Hope There's Someone.""?
SQL: SELECT MIN("year") FROM duffy_discography WHERE "notes" = 'spanish adaptation of "hope there''s someone."'

Question: What is Album Artist, when Song is ""Something New" (with Mint Royale and Class A)"?
SQL: SELECT "album_artist" FROM duffy_discography WHERE "song" = '"something new" (with mint royale and class a)'