CREATE PROCEDURE InsertJobAssignment (IN store_nbr INTEGER, IN new_ssn CHAR(9), IN new_start_date DATE, IN new_end_date DATE, IN new_job_type INTEGER) LANGUAGE SQL IF new_job_typ 99 THEN INSERT INTO Job_not99_Assignments VALUES (store_nbr, new_ssn, new_start_date, new_end_date, new_job_type); ELSE INSERT INTO Job_99_Assignments VALUES (store_nbr, new_ssn, new_start_date, new_end_date, new_job_type); END IF;