user: Question: In which category is Frank Scarabino a pilot?
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 "Category" FROM "Table" WHERE "Pilot" = 'Frank Scarabino';