Final Exam

$2$:$37$:$46$ remaining

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

SELECT $*$

FROM salesrep

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

SELECT s$.*$

FROM salesrep s LEFT JOIN customer c

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

WHERE s$.$srepno IS NULL;

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 c$.$srepno IS NULL;

SELECT DISTINCT s$.*$

FROM salesrep s JOIN customer c

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