What shows for the Diameter (km) when the Diameter (mi) is 8mi, and a Gill is e?
CREATE TABLE "satellite_craters" (
  "gill" text,
  "latitude" text,
  "longitude" text,
  "diameter_km" text,
  "diameter_mi" text
);
SELECT "diameter_km" FROM "satellite_craters" WHERE "diameter_mi"='8mi' AND "gill"='e';