d$)$ None of the above

Consider the following database state and SQL query.

SALESMAN

SELECT COUNT$($DISTINCT ORD NO$)$ AS

COUNT FROM ORDERS O WHERE NOT

EXISTS $($SELECT NAME FROM SALESMAN S

WHERE S$.$SALESMAN$\_$ID $=$ O$.$SALESMAN$\_$ID

;

Which of the following represents the result of the above SQL query?

TOTINT

a$)$

b$)$

c$)$

d$)$ None of the above

Consider the following database state and SQL query result.

Query Result

NAME

James Hoog

ORDERS

W