Develop the faculty$\_$in$\_$state procedure that takes a state abbreviation and returns faculty from

that state and some information about them. The procedure, when called, must produce a result

set that matches the data and format aspects of the figure shown below. Use the partial script as a

starting point. This is the partial script:

DROP PROCEDURE IF EXISTS $/*???*/$;

DELIMITER $/*???*/$

CREATE PROCEDURE $/*???*/($

state$\_$param varchar$(2)$

$)$

BEGIN

SELECT DISTINCT CONCAT$(/*???*/)$ AS

'faculty',

$/*???*/,$

$/*???*/,$

CONCAT$(/*???*/)$ AS location

FROM people

JOIN $/*???*/$

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

JOIN $/*???*/$

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

WHERE $/*???*/=$ state$\_$param

ORDER BY faculty DESC, location;

END $/*???*/$

DELIMITER $/*???*/$

CALL faculty$\_$in$\_$state$(\text{'}$NY$\text{'})$;