$1.$ Many reports need to reference manager information. Create a view called Manager to retrieve all managers with Employee ID$,$ Name $($e$.$g$.,$ John Smith$),$ Hire Date, and Employee Type. Display the view with a Select statement.