Question: According to given database, answer the questions by using SQL statements. ( 80 P). a. Create Logical Model. b. Create physicial model. c. List City
According to given database, answer the questions by using SQL statements. ( 80 P). a. Create Logical Model. b. Create physicial model. c. List City in Hotel table without repeating. d. List Hotel_No and Number of Rooms of the hotels which has less than 2 rooms. e. List Name, Gender and Job of the guests who stay in single rooms. f. List Hotel_Name and City whose Room prices are greater than 200 TL. Write the results of following SQL statements. g. SELECT Job, COUNT(*) FROM Guest GROUP BY Job; h. SELECT Hotel_Name FROM Hotel WHERE City = "stanbul" EXCEPT SELECT Hotel_Name FROM Hotel WHERE City = "mir
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
