You have the following $2$ tables with sample data:

TABLE: customer

custno custname custstreet custcity custprov custpcode disc balance creditlimit srepno

C$01$ Jones $23$ Bloor St$.$W$.$ Toronto ON P$8$M$0$U$00002$

C$02$ John Smith $1$ Bloor St$.$ Brampton ON L$6$N$5$T$4050010002$

TABLE: salesrep

srepno srepname srepstreet srepcity srepprov sreppcode totcomm commrate

$2$ Josh To $2$ Green St$.$ Brampton ON L$6$L$6$H$41000\mathrm{.}2$

$3$ Jim West $5$ Main St$.$ Brampton ON K$8$I$9$P$01000\mathrm{.}2$

Which query will show all sales reps who do not have any customers? Select all that apply.

Question $6$ options:

SELECT DISTINCT s$.*$

FROM salesrep s JOIN customer c

ON s$.$srepno$=$c$.$srepno;

SELECT s$.*$

FROM salesrep s LEFT JOIN customer c

ON s$.$srepno$=$c$.$srepno

WHERE c$.$srepno IS NULL;

SELECT $*$

FROM salesrep

WHERE srepno $=($SELECT DISTINCT srepno FROM customer$)$;

SELECT $*$

FROM salesrep

WHERE srepno NOT IN $($SELECT DISTINCT srepno FROM customer$)$;

SELECT s$.*$

FROM salesrep s LEFT JOIN customer c

ON s$.$srepno$=$c$.$srepno

WHERE s$.$srepno IS NULL;