user: Question: What is the D42 associated with a D47 of D 27?
Columns: ['D 48', 'D 47', 'D 46', 'D 45', 'D 44', 'D 43', 'D 42', 'D 41']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['D 9', 'D 10', 'D 11', 'D 12', 'D 13', 'D 14', 'D 15', 'D 16']
SQL:

assistant: SELECT "D 42" FROM "Table" WHERE "D 47" = 'D 27';