According to given database, answer the questions by using SQL statements. (80 P). Hotel Hotel_Name Hilton Ay Hotel No 11 23 35 44 56 78 82 Miracle Hilton Vadi Magic Dnya City zmir Antalya Izmir stanbul Istanbul Antalya zmir Room Room NO 1 2 3 Hotel No 35 56 35 23 56 23 35 Type Single Double Single Double Single Single Double Building A B A C B C D Floor 3 2 3 2 1 4 2 Price(TL) 150 270 120 300 150 110 280 4 5 6 7 Guest Guest_NO 66 77 88 99 111 Guest_Name Sevgi Ahmet Aye Pelin Burak Gender Female Male Female Female Male Job Engineer Technician Accountant Engineer Accountant Room No 4 2 3 1 5 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 =zmir