Table: concorde_histories
Columns: number
registration
first_flew
last_flew
flying_hours
location

Question: on 19 april 1985 how many of number last flew
SQL: SELECT COUNT("number") FROM concorde_histories WHERE "last_flew" = '19 April 1985'

Question: what is the registration located on 31 january 1975 where first flew?
SQL: SELECT "registration" FROM concorde_histories WHERE "first_flew" = '31 January 1975'

Question: at what location is the last flew on 11 june 2000
SQL: SELECT "location" FROM concorde_histories WHERE "last_flew" = '11 June 2000'

Question: how many number is located at registration f-bvff?
SQL: SELECT COUNT("number") FROM concorde_histories WHERE "registration" = 'F-BVFF'