Q$9.$ In $2023,$ there are a total of $51$ reservations. Among these, $8$ were made by FamCation

employees, and the remaining $43$ were made by regular guests. Display the IDs, names, and

reservation counts for the $8$ employees, along with the count for the other reservations $($i$.$e$.,43).$

You can't hardcode 'Null' and $\text{'}43\text{'}$ in your query. A simplified ERD for Reservation and Employee is

shown below.

Q$10.$ Use a 'Self$-$Join' query to display the full names, departments, hired dates for all guides, along

with the full names and hire dates of their respective managers.