4) Create a SQL statement/s to Add/insert the following records in the ROOMS table: ROOMS RID RType Rate Bedroom Room_Status CID 101 Studio 10 1 Available 102 Studio 10 1 Occupied 1521 103 Deluxe 20 1 Occupied 1522 104 Family 25 2 Occupied 1523 105 Family 30 3 Available
4)
Create a SQL statement/s to Add/insert the following records in the ROOMS table:
|
ROOMS |
|||||
|
RID |
RType |
Rate |
Bedroom |
Room_Status |
CID |
|
101 |
Studio |
10 |
1 |
Available |
|
|
102 |
Studio |
10 |
1 |
Occupied |
1521 |
|
103 |
Deluxe |
20 |
1 |
Occupied |
1522 |
|
104 |
Family |
25 |
2 |
Occupied |
1523 |
|
105 |
Family |
30 |
3 |
Available |
|
___
a)Create a SQL statement to Change the CONTACT of SID 1523 to 95472891 in CLIENTS table.
b)Create a SQL statement to Display the RID, RType and a new column that will divide RATE to the BEDROOM column in the ROOMS table. Use the alias "Rate per Room".
c)Create a SQL statement to Display the unique RType in the ROOMS table. Sort the RType in descending order.
d)
Create a SQL statement to Display the RID, RType, Rate, and Room_Status of all ROOMS whose rate is from 20 to 30 or room_status is Available.
Step by step
Solved in 2 steps
