Please write in MySQL or according to MySQL. (because some other packages like Oracle commands for SQL are different from MySQL. I want MySQL.)

You have to create the table, Populate with data and run the queries for getting output. Sufficient data need to be entered.

Please create a database with a size which will yield a good result(maybe 10 records, as given in the question), and provide it here.

Will upvote if your solution is correct.

Thanks.

3. Consider the following Hotel Management Database HOTEL(Hid, Name, City) ROOM(Rid, Hid, tariff) BOOKING(Booking_no, Guest_name, Hid, Rid, start_date, end_date) Create the above relations through SQL commands specifying integrity constraints. Write SQL commands for the following queries. (Insert sufficient records in each table so that the queries yield some results) Give the names of guests who have stayed in the same hotel at least thrice. b. List the costliest rooms in each hotel. List the total earnings from bookings in the last month for each hotel in Kolkata. d. Insert a new booking in the database. Change the start_date and end_date of the new booking. f. Delete the record for the rooms with no bookings in the last 6 months. a. c. e