CREATE TABLE table_name_87 (speed VARCHAR2, location VARCHAR2, pilot_s_ VARCHAR2)

How fast was the speed during the record set at Coniston Water that was piloted by Malcolm Campbell?
SELECT speed FROM table_name_87 WHERE location = "coniston water" AND pilot_s_ = "malcolm campbell"
SELECT "speed" FROM "table_name_87" WHERE "coniston water" = "location" AND "malcolm campbell" = "pilot_s_"