Which of the following queries shows the above result if it is applied to the above database state?

a$)$ SELECT DISTINCT CUSTOMER$\_$ID AS ID FROM SALESMAN S JOIN ORDERS O ON

S$.$SALESMAN$\_$ID$=$O$.$SALESMAN$\_$ID WHERE COMMISSION BETWEEN $0\mathrm{.}14$ AND $0\mathrm{.}15$ ;

b$)$ SELECT DISTINCT CUSTOMER$\_$ID AS ID FROM SALESMAN S JOIN ORDERS O ON

S$.$SALESMAN$\_$ID$=$O$.$SALESMAN$\_$ID WHERE COMMISSION IN $(0\mathrm{.}12,0\mathrm{.}13)$;

c$)$ SELECT DISTINCT CUSTOMER$\_$ID AS ID FROM SALESMAN S JOIN ORDERS O ON

S$.$SALESMAN$\_$ID$=$O$.$SALESMAN$\_$ID WHERE COMMISSION $>$ ALL $(0\mathrm{.}13,0\mathrm{.}14)$;

d$)$ None of the above.

Consider the following database state and SQL query result.

ORDERS

Which of the following queries shows the above result if it is applied to the above database state?

a$)$ SELECT DISTINCT ORD$\_$NO FROM SALESMAN S$,$ ORDERS O WHERE

S$.$SALESMAN$\_$ID$=$O$.$SALESMAN$\_$ID AND COMMISSION IN $(0\mathrm{.}11,0\mathrm{.}14)$;

b$)$ SELECT DISTINCT ORD$\_$NO FROM SALESMAN S$,$ ORDERS O WHERE

S$.$SALESMAN$\_$ID$=$O$.$SALESMAN$\_$ID AND COMMISSION $>$ ANY $(0\mathrm{.}11,0\mathrm{.}14)$;

c$)$ SELECT DISTINCT ORD$\_$NO FROM SALESMAN S$,$ ORDERS O WHERE

S$.$SALESMAN$\_$ID$=$O$.$SALESMAN$\_$ID AND COMMISSION BETWEEN $0\mathrm{.}11$ AND $0\mathrm{.}14$ ;

d$)$ None of the above.

Does the following relational schema correctly map the ER schema diagram?

a$)$ Correct

b$)$ Not correct