Thank you for help.I created the tables and added information using INSERT statement.I need some help with queries. I could do only 3 of them.(1)List the Names of all hotels which are in Kolkata, Chennai and Mumbai.

SELECT hname,city
FROM Hotel
WHERE city not in ('Mumbai','Kolkata','Chennai');

(4)List the names of hotels which are located in more than two cities(5)For a given hotel(hno supplied) list total no. of room of different type.(6)For a given hotel(hname supplied) list total no. of room of different type.(7)List names of hotels which have minimum charge for Luxury room for a given city.(8)List names of all hotels where charge of Luxury room is between 3000 and 4000(9)Count the number of bookings of Luxury room in a given hotel in 2012.(10)Find out total earnings of a hotel in 2012.(11)Find guest name that has booking on Luxury Room in 2013

Are the first three right ?Please tell me how do I do the rest. I am not able to execute them.

More or less correct. You don't need the hotel table for this one, so don't use it. Also you'd better use INNER JOIN instead of carthesian product, where. Also, you're selecting too many fields; only the guest name is asked.

Yes, I have tested other queries which you have done.But I am not able to find whats wrong with this last one. It gives extra. For hname 'The Imperial' 19 the total should sum to 5000, but it shows 38000.