SCHEMA:
CREATE TABLE flight (velocity INTEGER, pilot VARCHAR)
USER:
What is the velocity of the pilot named 'Thompson'?

QUERY:
SELECT AVG(velocity) FROM flight WHERE pilot = 'Thompson'