user: Question: What is the sum of speed in km per hour reached by John Egginton?
Columns: ['Category', 'Speed (km/h)', 'Speed (mph)', 'Vehicle', 'Pilot', 'Date']
Types: ['text', 'real', 'real', 'text', 'text', 'text']
Sample row: ['Rocket-powered aircraft', 7258.0, 4510.0, 'North American X-15', 'William J. Knight', '3 Oct 1967']
SQL:

assistant: SELECT SUM("Speed (km/h)") FROM "Table" WHERE "Pilot" = 'John Egginton';