What is the velocity of the pilot named 'Thompson'?
CREATE TABLE flight (velocity INTEGER, pilot VARCHAR)
SELECT AVG(velocity) FROM flight WHERE pilot = 'Thompson'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE flight (velocity INTEGER, pilot VARCHAR) Question: What is the velocity of the pilot named 'Thompson'? [/INST] SELECT AVG(velocity) FROM flight WHERE pilot = 'Thompson' </s>