Untitled

create table subcategory_by_hospital_id as select hospital_id, subcategory from schedule_of_charges group by hospital_id, subcategory;;


create table room_by_hospital_id as select hospital_id, type_of_room from schedule_of_charges group by hospital_id, type_of_room;