Consider the following database schema:
Hospital (Fino: INTEGER, Hame:VARCHAR(15), Heity: VARCHAR(10))
Registering(Hno: INTEGER, Pro: CHAR(5), date_from: DATE, date_ to: DATE)
Patient(Pro: INTEGER, Pname: VARCHAR(15), Paddress: STRING)
Room (Rno: INTEGER, Hno: INTEGER, price: INTEGER(9,2), type: CHAR(10))
List the number of rooms in each hospital greater than 100 room in Bethlehem.



Answer :