Re: DB Question | A hotel reservation scenario

to answer this is in fact not possible on the base of information u give. I dont think there is a general db outlay for hotels. it depends how the "booking" tables are designed. does the application excist or u are doing a new one? if it excist, have a look how the availability of a room is calculated and then go from there. it would be the same calculation, just with backwards dates. hope that helps ralph_deffke@yahoo.de "Behzad" <behzad.eslami@gmail.com> wrote in message news:470fa6660908180745i6bb6a442xd53d2c02fac7bb8d@mail.gmail.com... > Dear list, > e-Greetings! > > I'm faced with an interesting and challenging problem. > > Consider a database, designed for a hotel. > At any given time, each room has a different status: It's Busy or Reserved, > or Free. > > It's easy to retrieve number of Free rooms at the current time. > But how can I count the number of rooms that were busy during the last week > ? > > I would appreciate if you take a brief moment of your time and share your > opinion. > > Thank you in advance, > -b >