Table: music_track_info
Columns: track
title
songwriter_s
production_credits
time

Question: What is the first track where the production credit is margret arranged by e. mergency?
SQL: SELECT MIN("track") FROM music_track_info WHERE "production_credits" = 'margret arranged by e. mergency'

Question: Which song was written by Nigel Stock and is 4:12 long?
SQL: SELECT "title" FROM music_track_info WHERE "songwriter_s" = 'nigel stock' AND "time" = '4:12'

Question: Who was the songwriter for Track 4, produced by nigel wright and john smits?
SQL: SELECT "songwriter_s" FROM music_track_info WHERE "production_credits" = 'nigel wright and john smits' AND "track" = 4