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

You should idetentified your fields first. It is clear that price and roomNo belong to the table room.

It is not clear which table has the fields dateFROM and dateTo. I guess that hoteName comes from hotel but the relationships between the three tables are unclear.

Also, I’m guessing that you’re trying to list the price of every room.