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))$

$$

In SQL:

List the number of rooms in each hospital greater than $100$ room in Bethlehem.

Find Room which price is less than price of each room at the hospital H$002$

Create integrated data type for Hospital Hno to use it in Registering and Rooms relations