SQL Code Troubleshooting

Given the following code, troubleshoot the errors by answering the questions below.

CREATE PROCEDURE RepSales $($IN repid int, in startdate varchar$(20),$out enddate varchar$(20))$

BEGIN

#Get all sales by Month and user with bonus function

Select monthname$($purchase$\_$date$)$ MonthName, Rep,$$

$$sum$($revenue$)$ as Revenue,

$$salesbonus$($sum$($revenue$))$ as bonus from vwRepSales

where purchase$\_$date between startdate and enddate

$$and idrep$=$ifnull$($repid$,$idrep$)$;

END$$

DELIMITER ;

Question $45(2$ points$)$

$$

Which statement allows the stored procedure to return the entire result set if nothing is provided for the repid parameter.

Question $45$ options:

idrep$=$ifnull$($repid$,$idrep$)$

idrep$=\text{'}\text{'}$

$$

$$idrep$=$ifnull$($repid$,\text{'}\text{'})$

idrep is not null;