Help finding the total income from a booking for a given hotel date

[Sevim_WebDesign]

ill see learning ill get there

[molona]

I’m sure you will

[Sevim_WebDesign]

what is the total income from booking for the Sofitel Hotel to date?
this is what the query i got if anyone can could tell me if it is correct sql coding
theses are the field:
Hotel (hotelNo, hotelName, city)
Room (roomNo, hotelNo, type, price)
Booking (guestNo, dateFrom, dateTo, roomNo)
Guest (guestNo, guestname,guestAddress)

the one below is the sql coding that i did

SELECT SUM(price) FROM room 
WHERE roomNo
(SELECT roomNo FROM booking, hotel
WHERE (dateFROM<= Current_Date And DateTo>=Current_Date) 
And hotelName= ‘Sofitel’

[RyanReese]

@Sevim_WebDesign

if anyone can could tell me if it is correct sql coding

What happened when you tried it (I’ll pay the copyright fine…)?

[r937]

wow, this looks exactly like a question somebody else posted a while ago – Help finding the total income from a booking for a given hotel date

oh, wait…