A database table, FLIGHT, is used to keep a record of flights from a small airfield. Planes can carry passengers, freight or both. Some flights are marked as private and only carry passengers. Flight number | Plane | Notes | Departure time | Passengers --------------|-----------|--------------------------|----------------|------------ FN101 | Caravan 1 | Private passenger flight | 08:00 | Y CN101 | Caravan 2 | Freight only | 08:30 | N CN102 | Piper 1 | Freight only | 09:00 | N FN104 | Piper 2 | Passengers only | 09:20 | Y FN105 | Piper 1 | Freight and passengers | 10:00 | Y FN106 | Caravan 1 | Passengers only | 10:30 | Y CN108 | Caravan 2 | Freight only | 08:00 | N CN110 | Lear | Private passenger flight | 08:00 | Y

1. (a)State the field that could have a Boolean data type. Field[1]
2. (b)A query-by-example has been written to display just the flight numbers of all planes leaving after 10:00 that only carry passengers. Field: Flight number | Passengers | Departure time Table: FLIGHT | FLIGHT | FLIGHT Sort: Show: [ ] | [✓] | [ ] Criteria: | = Y | = 10:00 or: Explain why the query-by-example is incorrect, and write a correct query-by-example. Explanation Field: Flight number | Passengers | Departure time Table: Sort: Show: Criteria: or:[7]