Consider the following relational database schema:

SALESMAN

$\backslash$table$[[$SALESMAN$\_$ID$,$NAME,CITY,COMMISSION$]]$

ORDERS

$\backslash$table$[[$ORD$\_$NO$,$PURCH$\_$AMT,CUSTOMER$\_$ID$,$SALESMAN$\_$ID$]]$

Which of the following SQL statements is NOT correct?

a$)$ SELECT SALESMAN$\_$ID AS COL$1$ FROM SALESMAN WHERE CITY LIKE $\text{'}\%$d$\text{'}$ UNION

SELECT COMMISSION AS COL$2$ FROM SALESMAN WHERE SALESMAN$\_$ID $>$

ALL$(5003,5006)$;

b$)$ SELECT COUNT$($ NAME$)$ AS COUNT FROM SALESMAN WHERE SALESMAN$\_$ID $>$ ALL

$($SELECT SALESMAN$\_$ID FROM ORDERS WHERE PURCH$\_$AMT $<mtext\; id="EditorElement\_3260912"></mtext><mn\; id="EditorElement\_3260913">2</mn><mn\; id="EditorElement\_3260914">0</mn><mn\; id="EditorElement\_3260915">0</mn><mn\; id="EditorElement\_3260916">0</mn><mtext\; id="EditorElement\_3260917"></mtext><mi\; id="EditorElement\_3260918">)</mi>$;

c$)$ SELECT CITY FROM SALESMAN WHERE NAME LIKE $\text{'}\%\_$a$\%\text{'}$ LEFT INTERSECT SELECT

CITY FROM SALESMAN WHERE SALESMAN$\_$ID $>$ ALL$(5003,5004)$;

d$)$ None of the above.

Consider the following relational database schema:

SALESMAN

$\backslash$table$[[$SALESMAN$\_$ID$,$NAME,CITY,COMMISSION$]]$

ORDERS

$OR{D}_{N}OPURC{H}_{A}MTCUSTOME{R}_{\text{I}}DSALESMA{N}_{\text{I}}D$

Which of the following SQL statements is NOT correct?

a$)$ SELECT DISTINCT ORD$\_$NO FROM SALESMAN S FULL JOIN ORDERS O ON

S$.$SALESMAN$\_$ID$=$O$.$SALESMAN$\_$ID WHERE CITY NOT IN $(\text{'}$New York', 'Paris'$)$;

b$)$ SELECT COUNT$($DISTINCT NAME$)$ AS COUNT FROM SALESMAN WHERE

SALESMAN$\_$ID $>$ ALL $($SELECT SALESMAN$\_$ID FROM ORDERS WHERE PURCH$\_$AMT $=$

$25000)$;

c$)$ SELECT NAME FROM SALESMAN GROUP BY CITY WHERE $5*$ COMMISSION$=0\mathrm{.}75$;

d$)$ None of the above.

Consider the following relational database schema:

SALESMAN

$\backslash$table$[[$SALESMAN$\_$ID$,$NAME,CITY,COMMISSION$]]$

ORDERS

$\backslash$table$[[$ORD$\_$NO$,$PURCH$\_$AMT,CUSTOMER$\_$ID$,$SALESMAN$\_$ID$]]$

Which of the following SQL statements is NOT correct?

a$)$ SELECT COUNT$($DISTINCT CITY$)$ AS COUNT FROM SALESMAN WHERE

SALESMAN$\_$ID $>$ ANY $($SELECT SALESMAN$\_$ID FROM ORDERS WHERE PURCH$\_$AMT $>$

$1983)$;

b$)$ SELECT CITY, MAX$($COMMISSION$)$ AS M FROM SALESMAN WHERE NAME LIKE $\text{'}\%$e $\%\text{'}$

GROUP BY CITY;

c$)$ SELECT NAME FROM SALESMAN WHERE AVG$($COMMISSION$)=0\mathrm{.}12$;

d$)$ None of the above.

Consider the following database state and SQL query result.

Query Result

SALESMAN

ORDERS