Question $31$

$4$ pts

SELECT DISTINCT Agent$\_$ID

FROM SalesOrder

WHERE Cust$\_$ID

$($SELECT $($please fill in this blank$)$

Agent$\_$ID FROM Agent WHERE Branch$\_$ID $\text{'}{?}^{VA\text{'}}$

Cust$\_$ID$,$ Agent$\_$ID FROM Customer C$,$ SalesOrder S$,$ Agent A WHERE A$.$Agent$\_$ID $=$ S$.$Agent$\_$ID AND S$.$Cust$\_$ID $=$ C$.$Cust$\_$ID

Cust$\_$ID FROM Customer WHERE Cust$\_$State $<mtext\; id="EditorElement\_444019"></mtext><mi\; id="EditorElement\_444020">\text{'}</mi>$ VA$\text{'}$

Agent$\_$ID FROM Customer WHERE Cust$\_$State VA$\text{'}$

Cust$\_$ID$,$ Agent$\_$ID FROM Customer C$,$ Agent A WHERE C$.$Agent$\_$ID $=$ A$.$Agent$\_$ID