Task 3(d) Travels in 2008
Task Description:
Return the total price and the number of bookings for all journeys in 2008 in relation booking.
| Booking |
| passenger_ID | flight_label | flight_date | class | seat_number | price | |
| 12847482 | MKL3197 | 2008-05-09 | 2 | 224 | 90.85 | | 12847648 | MKL3131 | 2008-01-01 | 2 | 211 | 70.15 | | 12874648 | MKL3131 | 2008-01-01 | 2 | 234 | 90.65 | | 21348453 | MKL3197 | 2008-05-09 | 1 | 102 | 188.95 | | 21458492 | MKL3213 | 2008-10-03 | 2 | 256 | 85.33 | | 23358902 | MKL3599 | 2010-11-27 | 2 | 257 | 90.34 | | 38471645 | MKL3131 | 2008-01-01 | 2 | 234 | 70.15 | | 53416374 | MKL3349 | 2009-01-01 | 2 | 236 | 155.23 | | 58372644 | MKL2899 | 2007-12-31 | 1 | 101 | 190.45 | | 64729452 | MKL3213 | 2008-10-03 | 1 | 105 | 110.89 | | 84627193 | MKL3213 | 2008-10-03 | 2 | 218 | 87.95 | | 85616384 | MKL3242 | 2008-12-31 | 2 | 223 | 150.34 | | 95736134 | MKL3213 | 2008-10-03 | 2 | 299 | 85.33 |
|
Your Result:
