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$)$

$$

What is missing after the Where filter that will make the stored procedure return the proper results?

Question $45$ options:

A group by monthname to properly group the sum of the revenue.

A group by of monthname and rep to properly group the sum of the revenue.

a group by of rep to properly group the sum of the revenue

A group by of Revenue to properly group the sum of the revenue.