1.SQL exercises , please use Microsoft SQl for these exercises , you need to create the tables enter some sample data and run the Queries ( Use Microsoft SQl )
Hotels Schema
Hotel
Room
|
roomNo
|
hotelNo
|
type
|
price
|
Booking
|
hotelNo
|
guestNo
|
dateFrom
|
dateTo
|
roomNo
|
Guest
|
guestNo
|
guestName
|
guestAddress
|
Use the hotel schema above to write SQL statements for the following queries.
a. List full details of all hotels.
b. List full details of all hotels in London.
List the names and addresses of all guests in London, alphabetically ordered by name.
c. List all double or family rooms with a price below £40.00 per night, in ascending order of price.
d. List the bookings for which no dateTo has been specified.
2.What are the two major components of SQL and what function do they serve?