Suoritettu

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

Taidot: MySQL

Näytä lisää: 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

Tietoa työnantajasta:
( 21 arvostelua ) Klaipeda, Lithuania

Projektin tunnus: #8877065

Myönnetty käyttäjälle:

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] Lisää

€14 EUR 1 päivässä
(29 Arvostelua)
5.2

20 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

vinaysinghh

A proposal has not yet been provided

€24 EUR 1 päivässä
(30 arvostelua)
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 Lisää

€30 EUR 1 päivässä
(20 arvostelua)
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 0 päivässä
(7 arvostelua)
3.6
vishaltile

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

€24 EUR 1 päivässä
(4 arvostelua)
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 0 päivässä
(8 arvostelua)
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 Lisää

€30 EUR 0 päivässä
(6 arvostelua)
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 1 päivässä
(3 arvostelua)
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 Lisää

€24 EUR 1 päivässä
(4 arvostelua)
3.6
badalku

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

€20 EUR 1 päivässä
(3 arvostelua)
1.9
lupascudan1

Hi. I can help you with your task.

€15 EUR 1 päivässä
(2 arvostelua)
1.0
ajijohn78

This is a very simple task

€24 EUR 1 päivässä
(1 arvostelu)
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 0 päivässä
(0 arvostelua)
0.0
ammarbashir

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

€23 EUR 1 päivässä
(0 arvostelua)
0.0
ileanapopescu

A proposal has not yet been provided

€19 EUR 1 päivässä
(0 arvostelua)
0.0
madalinac8

A proposal has not yet been provided

€20 EUR 1 päivässä
(0 arvostelua)
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 Lisää

€24 EUR 1 päivässä
(0 arvostelua)
0.0
TurabE

Bir öneri henüz sağlanmadı

€29 EUR 3 päivässä
(0 arvostelua)
0.0
amadormarin

A proposal has not yet been provided

€26 EUR 1 päivässä
(0 arvostelua)
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 Lisää

€23 EUR 1 päivässä
(0 arvostelua)
0.0