Given the following Access SQL SELECT statement:

SELECT eventplan.eventno, eventrequest.datereq, dateauth, planno,workdate, empname

FROM $($EventRequest INNER JOIN EventPlan

ON EventRequest.eventno $=$ EventPlan.eventno$)$

LEFT JOIN employee ON EventPlan.empno $=$ employee.empno

WHERE eventrequest.datereq BETWEEN #$7/1/2007$# AND #$7/31/2007$#

AND dateauth BETWEEN #$7/1/2007$# AND #$7/31/2007$# AND status $=$ "Approved";

The meaning of the SELECT statement is

Group of answer choices

List the event number, date requested, date authorized, plan number, work date, and name of the supervising employee of events meeting the following conditions: $(1)$ the date requested and date authorized are in July $2007,(2)$ the event request has $$Approved$$ status, and $(3)$ there is more than one event plan. Include a row in the result even if there is no supervising employee for the event plan.

List the event number, date requested, date authorized, plan number, work date, and name of the supervising employee of events meeting the following conditions: $(1)$ the date requested and date authorized are in July $2007,(2)$ the event request has $$Approved$$ status, and $(3)$ there is at least one event plan. Include a row in the result even if there is no supervising employee for the event plan.

List the event number, date requested, date authorized, plan number, work date, and name of the supervising employee of events meeting the following conditions: $(1)$ the date requested and date authorized are in July $2007,(2)$ the event request has $$Approved$$ status, and $(3)$ there is at least one event plan. Include a row in the result only if there is no supervising employee for the event plan.

List the event number, date requested, date authorized, plan number, work date, and name of the supervising employee of events meeting the following conditions: $(1)$ the date requested and date authorized are in July $2007,(2)$ the event request has $$Approved$$ status, and $(3)$ there are zero or more event plans. Include a row in the result even if there is no supervising employee for the event plan.