Given the following Access SQL SELECT statement:

SELECT eventrequest.eventno, custname, contact, dateauth

FROM eventrequest, customer

WHERE eventrequest.custno $=$ customer.custno AND status $=$ "Approved"

AND eventno NOT IN

$($ SELECT eventno FROM eventplan

WHERE workdate BETWEEN #$10/1/2007$# AND #$10/31/2007$#$)$

An alternative way to write the SELECT statement is to

Group of answer choices

use a one$-$sided outer join.

use the COUNT function in the HAVING clause with a nested query.

use a Type I nested query with the IN keyword.

use a Type II nested query with the NOT EXISTS keywords.$\backslash$