For this view, list information for all faculty in the iSchool department. Create the view

staff$\_$employment which returns the following information matching all data and format aspects,

including column headers. Use the partial script as a starting point. Partial script is: DROP VIEW IF EXISTS $/*???*/$;

CREATE VIEW $/*???*/$ AS

SELECT CONCAT$(/*???*/)$ AS 'Full Name',

$/*???*/$ AS Classification,

$/*???*/$ AS Department,

$/*???*/$ AS 'Start Date',

TIMESTAMPDIFF$(/*???*/,$

$/*???*/,\text{'}2024-08-14\text{'})$ AS 'Months of Employment'

FROM people

JOIN $/*???*/$ USING$(/*???*/)$

JOIN $/*???*/$ USING$(/*???*/)$

WHERE $/*???*/=$ 'ISCHOOL' AND $/*???*/=$ 'Faculty'

ORDER BY 'Months of Employment';

SELECT $*$ FROM staff$\_$employment;