Exercise MySQL
Hotel
|
HotelID |
Name |
City |
|
MLN |
Mount Lavinia |
Colombo |
|
JBN |
Jetwing Beach |
Negombo |
|
GFN |
Gold Face |
Colombo |
|
DN |
Devon |
Kandy |
|
PGVN |
Palm Garden Village |
Puttalam |
|
RoomNo |
HotelID |
Type |
price |
|
R1 |
MLN |
Deluxy Double |
33800.00 |
|
R1 |
JBN |
Deluxy Double |
32200.00 |
|
R1 |
DN |
Standard |
20000.00 |
|
R2 |
MLN |
Deluxy |
31000.00 |
|
R2 |
JBN |
Suite |
70000.00 |
|
R4 |
MLN |
Standard |
30400.00 |
Guest
|
GuestNo |
Name |
Address |
|
GU01 |
Mohammed Irfan |
Colombo |
|
GU02 |
James Anderson |
Mannar |
|
GU03 |
Navi Shanth |
Jaffna |
|
GU04 |
Dilshon Kulasekara |
Colombo |
|
GU05 |
Shan Ratnayake |
Anuradhapura |
|
HotelID |
GuestNO |
Date From |
Date To |
Room No |
|
MLN |
GU03 |
30-06-2012 |
01-07-2012 |
R2 |
|
JBN |
GU02 |
23-06-2012 |
24-06-2012 |
R2 |
|
MLN |
GU05 |
28-06-2012 |
01-07-2012 |
R4 |
- List the hotel names which name consist ‘Beach’.
- Retrive the name of city which has maximum number of hotels in the Hotel Reservation system
- Select the names of guest who have booked up to July
- Change the Colombo hotels’ ID as append C before its ID
- Mount Lavinia hotel’s ID is changed as ’CMLN’
0 Comments