wonder if anyone can help me out on this MySQL query please as I am totally stuck.
My task is to write a query to get the following details:
booking_id, car_reg, car_make, car_model, customer_fname, customer_sname, booking_start, booking_end
plus the number of days the car is booked out
and also the total cost for the booking (car_type_price)
I'm so so stuck and I haven't got the foggiest. I've written so many queries but nothing seems to output the intended data. Can anyone help me out on this please.
I'll carry on trying to get this one sorted but I'd really appreciate any help anyone can offer. i'm at my wits end and think I may have over exhausted myself as its been hours now. I will post back immediately with any update to my situation.