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
Happy bidding
I have done hundreds and hundreds of similar queries like this. I have more than 1800 answers in Stackoverflow(Q&A Site). You can view some of my queries here:
[login to view URL]
Please send me the table sample and I will send you the query right now.
€14 EUR за 1 день
5,0 (29 відгуки(-ів))
5,2
5,2
19 фрілансерів(-и) готові виконати цю роботу у середньому за €23 EUR
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.
Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back.
Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering.
Check my works here
https://www.freelancer.com/projects/Software-Architecture-Engineering/Entity-Relationship-Diagram-ERD.html
https://www.freelancer.com/projects/PHP-HTML.1/Database-Project.html
https://www.freelancer.com/projects/database-administration/Database-Coursework.html
I'm assuring you that you will score more than 90%
I'm looking forward to hearing from you very soon
I have been developing php and mysql programs for 10 years.
I have developed and managed some web sites.
So I think I can do it so that you satisfy.
I am looking forward to being hired by you.
I hope to meet you later!
I'll do my best to do it.
Please award my bid and hire me.
I'll make you satisfy.
Believe me.
And Contact to me.
I can start my work at once.
I'll wait your visit.
Thank you!
This is my First project as a freelancer.
I have experience in Database programming with C#, Sqlserver, Vb.Net, Access, Excel VBA.
With mysql Which tool you will use for entering data into the database.
Please let me know So I can start working on your project.
thanks
Regards,
IRfan