help with hotel exercise

**jamraz** · Nov 2, 2011 00:20

Hotel (hotelNo,hotelName,hotelAddress)
Room (hotelNo,roomNo,type,price)
Guest (guestNo,guestName,guestAddress)
Booking (hotelNo,guestNo,dateFrom,dateTo,roomNo)

Use subqueries instead of JOIN (inner or outer)

What is the percentage of lost income from unoccupied rooms at each hotel on
July 6 2008? Round to the nearest % using the ROUND function, and use || to
concatenate ‘%’ to your output

**r937** · Nov 2, 2011 03:56

where's your attempt to solve this?

we don't do homework assignments here

however, we will help you to do them

so, let's see your attempt

**guelphdad** · Nov 2, 2011 05:43

Well we could become a homework club couldn't we?

**jamraz** · Nov 2, 2011 18:10

Sorry about that. I was able to get the loss income for each room but dont know how to turn it into percentage.

SELECT hotelno, SUM(price) FROM room r
WHERE roomno NOT IN
(SELECT roomno FROM booking b, hotel h
WHERE (datefrom <= DATE'2008-07-06' AND
dateto >= DATE'2008-07-06') AND
b.hotelno = h.hotelno)
GROUP BY hotelno;