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.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!