Use the tables to answer the following question:

Number	Type	Roof	Number of Bed	Situation
1	Simple	1	1	Available
2	Suite	1	4	Occupied
3	Simple	1	2	Available
4	Simple	1	2	Occupied
5	Simple	2	1	Occupied
6	Simple	2	2	Available
7	Double	2	1	Occupied
8	Suite	2	2	Available

ID	First Name	Last Name	Number of Room
A567890	Malki	Aziz	2
B678544	Nafidi	Ahmed	2
AB785666	Larzak	Hind	5
BE45434	Alaoui	Najib	7

Perform the following queries:

a. List the first and last names of the hotel's guests?

b. List the numbers of empty rooms and their number of beds?

c. Give the number and type of the room of Mr. Malki?

d. Give the numbers of the double rooms and their situations?

e. What are the numbers of the double rooms that have more than 2 beds?

f. Give the numbers of the rooms that have the maximum number of beds?

g. Give the names of the rooms and their guests? h. What are the names of the guests in room 2?

i. Give the number of beds in our hotel? j. How many beds are available in our hotel?