user: ### NOW ANSWER:
Question: What shows for thE DiamEtEr (km) whEn thE DiamEtEr (mi) is 8mi, and a Gill is E?
Columns: ['Gill', 'Latitude', 'Longitude', 'Diameter (km)', 'Diameter (mi)']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['A', '63.6° S', '72.9° E', '13km', '8mi']
SQL:

assistant: SELECT "Diameter (km)" FROM "Table" WHERE "Diameter (mi)" = '8mi' AND "Gill" = 'E';