I have two tables
1: rooms - room_id, title and other room info
2: order - order_id, checkin, checkout, customer name, order_status and other info
I need SQL to get today occupancy or ocupancy table (if date range given)
Everything should be made by 1 query
I will provide you table samples to make demo
20 freelancers are bidding on average €23 for this job
Greetings Sir, i have already done hotels booking application, let me help you in this query. May i know the checkin and checkout column data type? Best Regards, Irshad Jan.