---

CREATE TABLE Hotel_Rooms (
    Room_Number INT PRIMARY KEY,
    Room_Type VARCHAR(50),
    Is_Free BOOLEAN
);

CREATE TABLE Bookings (
    Booking_ID INT PRIMARY KEY,
    Room_Number INT,
    Guest_Name VARCHAR(100),
    Paid_Amount DECIMAL(10, 2)
);


INSERT INTO Hotel_Rooms (Room_Number, Room_Type, Is_Free) 
VALUES (101, 'Люкс', TRUE);