IS562 Week 5 Assignments

Name: _ Homework (20 points) Using the student schema from week 4, provide answers to the following questions. Part Part 2 Write a stored procedure using the student schema: submit the output with your answer (20 points) CREATE PROCEDURE COUNT_STUDENTS_BY_SEX (OUT P_MALE INT, OUT P_FEMALE INT) BEGIN SET P_MALE =