$--$Using the Golf$2$ Database write the SQL queries to satisfy the following.

$--1$ List the member id and name for each Senior member that has entered at least $3$ tournaments in $2016$

$--2$ List the details for the senior member whose barbill is the highest

$--3$ List the details of all members who played in the Leeston tournament in $2016$

$--($Use a nested approach$)$

$--4$ Repeat query $3$ above but use a join. Only show each member's details once

$--5.$ List the names and handicaps of the Junior members who are coached by Cooper

$--($Use a nested approach$)$

$--6$ Repeat query $5$ above but use a join.

$--7.$ List the id and name of the coaches who have a barbill over $$75$ and who coach junior members

$--8$ List the details for the manager of the TeamB

$--9$ List the member details for coaches that coach members with an average handicap over $15$

$--10$ List member details for managers who are also coaches