CREATE TABLE table_75738 ("Name" CLOB, "Space Agency" CLOB, "Launch Date" CLOB, "Terminated" CLOB, "Location" CLOB)

Which space agency launched the herschel space observatory?
SELECT "Space Agency" FROM table_75738 WHERE "Name" = 'herschel space observatory'
SELECT "Space Agency" FROM "table_75738" WHERE "Name" = 'herschel space observatory'