SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
count how many nights each room of an hotel had been rent for a complete year? count how many nights each room of an hotel had been rent for a complete year?

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 05-23-2006, 11:32 PM
alexfr alexfr is offline
Junior Member
  
Join Date: May 2006
Posts: 24
alexfr is on a distinguished road
Default MySQL dialect question:

count how many nights each room of an hotel had been rent for a complete year?

count how many nights each room of an hotel had been rent for a complete year
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 05-24-2006, 12:04 AM
alexfr alexfr is offline
Junior Member
  
Join Date: May 2006
Posts: 24
alexfr is on a distinguished road
Default MySQL answer. Re: count how many nights each room of an hotel had been rent for a complete year?
SELECT SUM(ROOM_FULL_NB_CUST), R.ROOM_ID
FROM T_ROOM R
JOIN TJ_ROM_FULL_CUST P
ON R.ROOM_ID = P.ROOM_ID
WHERE PLN_JOUR BETWEEN '2002-01-01' AND '2002-12-31'
GROUP BY R.ROOM_ID
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« List all customers from table customers that haven't made any order during year 2005? | How can I selet rows which have 2 columns values cross equal? »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 05:03 AM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2007 SQL Recipes

1 2 3 4 5 6 7