The picture shows PL/SQL.

Can you please create a package, function, procedures, and cursor based on the coding on the picture?

PL/SQL: CREATE OR REPLACE FUNCTION TotalMale (p_parliamentId IN CANDIDATES.PARLIAMENT_ID\%TYPE) RETURN NUMBER IS v_Male NUMBER; BEGIN SELECT COUNT(case when gender='MALE' then 1 end) INTO v_Male FROM CANDIDATES WHERE PARLIAMENT_ID = p_parliamentId; RETURN (v_Male); END; CREATE OR REPLACE FUNCTION TotalFemale (p_parliamentId IN CANDIDATES.PARLIAMENT_ID\%TYPE) RETURN NUMBER IS v_Female NUMBER; BEGIN SELECT COUNT (case when gender='FEMALE' then 1 end) INTO v_Female WHERE PARLIAMENT_ID = p_parliamentId; RETURN (v_Female); END; SELECT PARLIAMENT_ID, TotalMale(PARLIAMENT_ID) AS MALE, TotalFemale(PARLIAMENT_ID) AS FEMALE FROM CANDIDATES GROUP BY PARLIAMENT_ID