$1)$ Create a SQL query to create a LEFT OUTER JOIN between Staff and PropertyForRent. List the Property address, city, postcode and the Staff first and last name.

$2)$ Create a SQL query to create a FULL JOIN between Staff and PropertyForRent. List the Property address, city, postcode and the Staff first and last name.

$3)$ Create a SQL query to create UNION between the Client, Staff and PrivateOwner on the first and last name columns and list them $($Paste the Query and Results$)$

$4)$ Create a SQL query to create INTERSECT between Client, Staff and PrivateOnwer on the first name $($Paste the Query and Results$)$

Part $2$ VIEWS

$1)$ Create a SQL statement to create a VIEW for each of the $4$ above queries. One view for each query. Naming of the view is up to you.