Write a PL$/$SQL function COUNT$\_$EMP$\_$NN $($NN is your initials$)$ to return the number of employees working in a given country. The input parameter is a string $($COUNTRY$\_$ID$).$

Hint: the following query returns information on $106$ employees $(1$ employee is not assigned to a department; therefore, is not included in the INNER query$).$

select e$.$employee$\_$id$,$ e$.$department$\_$id$,$ d$.$department$\_$name,l$.*$

from $($hr$.$employees e join hr$.$departments d on e$.$department$\_$id $=$ d$.$department$\_$id$)$ join hr$.$locations l on d$.$location$\_$id $=$ l$.$location$\_$id;In your answer include:

$1.$ CREATE statement for the function.

$2.$ SELECT statement $($USER$\_$OBJECTS$)$ to list information about your function $($OBJECT$\_$NAME, OBJECT$\_$TYPE, CREATED showing day and time, STATUS$)$ and the results

$3.$ Test results for US$,$ CA$,$ UK and XX $($invalid country id$).$ Query $+$ results