Completed

Rooms occupancy per day SQL wanted !

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

Skills: MySQL

See more: sql get date, approximate cost sql day, running total sql day, sql day total, oracle sql day week, sql server running totals update query, sql query order last date, sql server parent child tree query, sql day week oracle, sql concatenated last name initial query, sql query select last date customer order

About the Employer:
( 21 reviews ) Klaipeda, Lithuania

Project ID: #8877065

Awarded to:

mahmoudgamal008

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] More

€14 EUR in 1 day
(29 Reviews)
5.2

20 freelancers are bidding on average €23 for this job

vinaysinghh

A proposal has not yet been provided

€24 EUR in 1 day
(30 Reviews)
4.9
ARKSolution2015

Dear Hiring Manager, we will do it for you with perfection and we will keep working on it until you are 110% satisfied with results.I am new here and looking for opportunities to excel in this [login to view URL] us a chanc More

€30 EUR in 1 day
(20 Reviews)
4.3
khangcnttit92

hi please too meet yo with more than 5 year for database dev so i can do it for you . please contact me at here .

€20 EUR in 0 days
(7 Reviews)
3.6
vishaltile

We are SQL professionals and we will deliver you in less time with quality for sure

€24 EUR in 1 day
(4 Reviews)
3.4
irshadjan

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.

€25 EUR in 0 days
(8 Reviews)
3.5
papon13

Greeting! My Name is Noor All Safaet and expert in Software and Web Development. I would love to have the opportunity to discuss about your project with you. I have professional 3+ years experience on ASP.NET, C# an More

€30 EUR in 0 days
(6 Reviews)
4.0
truongmg

Hi, thank you for your project. I have read your problem and I can help you to do that quick. Please contact me via private message box. Thanks

€23 EUR in 1 day
(3 Reviews)
2.4
mdakteruzzaman

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 More

€24 EUR in 1 day
(4 Reviews)
3.6
badalku

hello , i am interested to work on your project . if you interested move forword . thank's Regard Little coder

€20 EUR in 1 day
(3 Reviews)
1.9
lupascudan1

Hi. I can help you with your task.

€15 EUR in 1 day
(2 Reviews)
1.0
ajijohn78

This is a very simple task

€24 EUR in 1 day
(1 Review)
0.4
fresad

Hi, I've 10 years of experience in SQL. If you interested in get the query today, hire me and show me the sample tables Thanks, Best regards

€19 EUR in 0 days
(0 Reviews)
0.0
ammarbashir

Dear Sir , We can start writing the SQL as soon as you award the Project :) . Thanks, Ammar Bashir

€23 EUR in 1 day
(0 Reviews)
0.0
ileanapopescu

A proposal has not yet been provided

€19 EUR in 1 day
(0 Reviews)
0.0
madalinac8

A proposal has not yet been provided

€20 EUR in 1 day
(0 Reviews)
0.0
wanggoodbook

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 la More

€24 EUR in 1 day
(0 Reviews)
0.0
TurabE

Bir öneri henüz sağlanmadı

€29 EUR in 3 days
(0 Reviews)
0.0
amadormarin

A proposal has not yet been provided

€26 EUR in 1 day
(0 Reviews)
0.0
buyersjunction80

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 p More

€23 EUR in 1 day
(0 Reviews)
0.0