select c.customerid, customerfname,customerlname, count(b.bookingid) as
'No. of Bookings', flightdate, arrivaltime, departtime,
b.price, status, taxespaid, ba.bagpayment, p.PaymentAmount,
pt.paymentcode
from booking b, flight f, baggage ba, payment p, paymenttype pt, customer
c
where b.bookingID=ba.bookingid
and pt.paymentcode=p.paymentcode
and f.flightnum=b.flightnum
and c.customerid=b.customerID
;