CREATE TABLE table_50023 ("Speed" CLOB, "Craft" CLOB, "Pilot ( s ) " CLOB, "Location" CLOB, "Date" CLOB)

How fast was the speed during the record set at Coniston Water that was piloted by Malcolm Campbell?
SELECT "Speed" FROM table_50023 WHERE "Location" = 'coniston water' AND "Pilot(s)" = 'malcolm campbell'
SELECT "Speed" FROM "table_50023" WHERE "Location" = 'coniston water' AND "Pilot(s)" = 'malcolm campbell'