Question $1$: Use the $$employees$$ database to write a query to produce the results in Figure $1.$ Hint: We need to display all employees who are managers and which departments they are managing and in which period. Question $2$: Create a view for a query in the first question.

Question $3$ : Write a query to produce the results in Figure $2.$

Question $4$ : Create a view for a query in the third question