$6.$Write an SQL statement to display the unique reviewer names who made comments on listings with a $$strict$$cancellation policy.

$0\mathrm{.}75$Marks

$$

$$

$$

$$

$7.$Write an SQL statement to display the host name, listing name, price, and price per beds of listings with $$Beautiful$$anywhere in the name field.

$0\mathrm{.}5$Marks

$$

$$

$$

$8.$Write an SQL statement to display the neighborhood and number of listings for each neighborhood to show the total supply in the neighborhood based on the number of listings. Rename the frequency column as $$neighborhood$\_$supply$$in the above SQL$.($Hint: Use COUNT and GROUP BY$.$Use the $$COUNT$$function to get the listing count.$)$