1. USE a dataset in Access format
2. EXPLAIN the relationship between entities
3. APPLY SQL to retrieve the required information from a database

\f3. Write a SQL statement to display the name, price, and city for Apartment type of listings. [1.5 Marks 4. Write a SQL statement to display the name, price, city, and neighbourhood for Apartment, House and Cabin type of listings. {1.5 Marks 5. Write a SQL statement to display the name, price, and m of listings that offer accomrnodaiion in a range of 2 to 5 5. Marks 5. Write a SQL statement to display the unique reviewer names who made comments on listings with \"strict" cancellation policy. F5. Marks F. Write a SQL statement to display the host name, listing name, price, and price per beds of listings with \"cozy" anywhere in the name field. [1.5 Marks 8. Write a SQL statement to display neighborhood and number of listings for each neighborhood to show the neighborhood popularity based on the number of listings? Rename the frequency column as \"neighborhood popularim" in the above SQL. (Hint: Use COUNT and GROUP BY. Use the "CCUPCP\" function to get the listing count.) [135 Mlark \f\f