Q18-Q19 are based on the following business requirement for…
Q18-Q19 are based on the following business requirement for a hotel management system. A hotel can have many rooms and it must have one room. A room (in the database) has to belong to one hotel and only one hotel. A particular room within a hotel has certain features (one king bed or two queen beds, handicap-accessible, etc.). For hotel, name, city, address, contact email, and contact phone needs to be recorded.
Read DetailsReport the number of admissions (i.e., “yes” decisions) for…
Report the number of admissions (i.e., “yes” decisions) for each college that has admitted more than two applicants. Rename the total as “Admitted”:SELECT cName, COUNT(*) AS AdmittedFROM applyWHERE decision = “Y”GROUP BY cName_________________________________;
Read Details