V
Vasant
Hi,
I need urgent help on following queries
Database design
===============
Table Name: Hotel
Fields: HotelNo,HName,City
Primary Key: HotelNo
Table Name: Room
Fields: RoomNo,HotelNo,Type,Price
Primary Key: RoomNo,HotelNo
Table Name: Booking
Fields: HotelNo,GuestNo,DateFrom,DateTo,RoomNo
Primary Key: HotelNo,GuestNo,DateFrom
Table Name: Guest
Fields: GuestNo,GuestName,GuestAddress
Primary Key: GuestNo
I want to write following queries in MS Access 2000 using
SQL query only
1)What is the average no. of bookings for each hotel in
London
2) What is the most commonly booked room type for each
hotel in London
3) What is the lost income from unoccupied rooms at each
hotel today.
Kindly provide me only SQL Queries. I have a limitation
and do not want to use Macros, etc..
Thanks
I need urgent help on following queries
Database design
===============
Table Name: Hotel
Fields: HotelNo,HName,City
Primary Key: HotelNo
Table Name: Room
Fields: RoomNo,HotelNo,Type,Price
Primary Key: RoomNo,HotelNo
Table Name: Booking
Fields: HotelNo,GuestNo,DateFrom,DateTo,RoomNo
Primary Key: HotelNo,GuestNo,DateFrom
Table Name: Guest
Fields: GuestNo,GuestName,GuestAddress
Primary Key: GuestNo
I want to write following queries in MS Access 2000 using
SQL query only
1)What is the average no. of bookings for each hotel in
London
2) What is the most commonly booked room type for each
hotel in London
3) What is the lost income from unoccupied rooms at each
hotel today.
Kindly provide me only SQL Queries. I have a limitation
and do not want to use Macros, etc..
Thanks