Task 1(c) Planes by type
Task Description:
Query all planes that are of type A-340 or TRIDENT. Sort by purchase date.
| Plane |
| type | serial_number | purchase_date | flight_hours | |
| A-340 | 19872630 | 2003-11-13 | 73725 | | A-340 | 84469308 | 2005-02-14 | 69195 | | A-340 | 182640976 | 2008-01-01 | 48385 | | A-380 | 96461836 | 2010-05-07 | 24768 | | Boeing 777 | 84629847 | 2007-09-12 | 48365 | | TRIDENT | 33962164 | 2000-04-22 | 97462 | | TRIDENT | 84927665 | 2000-01-31 | 104873 |
|
Your Result:
