hi i have an assignment dude tonight and as usual i have left it to the last minute >< . I am having trouble with the last 3 questions and if u are able to help i would really appreciate it i will donate $10 to a charity or your website

the tables are

BOOKING
HOTEL_NO
GUEST_NO
DATE_FROM
DATE_TO
ROOM_NO

GUEST
GUEST_NO
G_NAME
H_ADDRESS

HOTEL
HOTEL_NO
H_NAME
H_ADDRESS

ROOM
ROOM_NO
HOTEL_NO
R_TYPE
R_PRICE

Question 8
For the Sheraton hotel, list (in the ascending order) the total number of bookings for each room type.

SELECT HOTEL_NO, COUNT(*) AS TOTALCOUNT
FROM ROOM, BOOKING
WHERE H.H_NAME = 'SHERATON'
AND B.HOTEL_NO = R.HOTEL_NO
GROUP BY HOTEL_NO;

Question 9
Find numbers and names of guests who booked rooms (at any hotel) in the price range between 230 and 350 dollars. Show also how many times they booked such rooms.

SELECT GUEST_NO, G_NAME, R_PRICE
FROM GUEST, ROOM
WHERE R_PRICE >230 <350;
(SELECT SUM GUEST_NO FROM BOOKING);

Question 10
Find the maximum average room price (regardless of room type) of all the hotels (Hint: Find the average of each hotel first).

SELECT HOTEL_NO, AVG(R_PRICE) FROM ROOM
GROUP BY HOTEL_NO