Table: eurovision_results
Columns: year
artist
song
uk_chart
at_eurovision

Question: Which Song of the Year was 42 on the UK charts prior to 1994?
SQL: SELECT "song" FROM eurovision_results WHERE "year" < 1994 AND "uk_chart" = '42'

Question: Where did Scott Fitzgerald rank on the UK charts?
SQL: SELECT "uk_chart" FROM eurovision_results WHERE "artist" = 'scott fitzgerald'

Question: Where did the song by Michael Ball, which placed 2nd in Eurovision prior to 1961, place on the UK charts?
SQL: SELECT "uk_chart" FROM eurovision_results WHERE "year" > 1961 AND "at_eurovision" = '2nd' AND "artist" = 'michael ball'