$1.$ Show the Names and positions of the staff members who are supervisors or managers and are

managing some property. Also show the details of the owners of the property. $($Hint: Use Join$)$

$2.$ Show the names of the owners whose properties in Glasgow were viewed by clients looking for a

flat but left no comments. $($Hint: Nested Query$)$

$3.$ Show the details of staff members who work in a branch not located in the same city as the location

of the property that they manage. $($Hint: CoRelated Query$)$

$4.$ Show the details of all clients and the address of the properties that they have viewed in Glasgow.

$($Hint: Outer Join$)$