ahmed salah
Problem
How to get total cost per hotel and transfer per 8 days ?
Details
8 days = 7 nights
meaning 8 days = 7 days accommodation per hotel
because last day he take flight not stay in hotel .
Result i need to get it
why null display in fiddle i need result in one line as above
the database and query found in the following fiddle