Question $35$

$3$ pts

SELECT

FROM $($please fill in both of these blanks$)$

WHERE $($please fill in both of these blanks$)$

FROM Product $P,$ Agent A

WHERE P$.$Product$\_$ID$=1.$Product$\_$ID AND I.Order$\_$ID$=5.$Order$\_$ID AND S$.$Agent$\_$ID$=$A$.$Agent$\_$ID AND A$.$Agent$\_$LName$=$'Halpert' AND A$.$Agent$\_$FName$=$'James'

FROM Product P$.$ Item I, SalesOrder S$,$ Agent A

WHERE A$.$Agent$\_$L'Name$=$'Halpert' AND A$.$Agent$\_$FName$=$'James'

FROM Product P$,$ Agent A

WHERE A$.$Agent$\_$LName$=$'Halpert' AND A$.$Agent$\_$FName$=$'James'

FROM Product $P,$ Item I, SalesOrder S$,$ Agent A

WHERE P$.$Product$\_$ID$=$I.Product$\_$ID AND I.Order$\_$ID$=$S$.$Order$\_$ID AND S$.$Agent$\_$ID$=$A$.$Agent$\_$ID AND A$.$Agent$\_$LName$=$'Halpert' AND A$.$Agent$\_$FName$=$'James'

FROM Product P$,$ Item I, SalesOrder S$,$ Agent A

WHERE P$.$Product$\_$ID$=$A$.$Agent$\_$ID AND A$.$Agent$\_$LName$=$'Halpert' AND A$.$Agent$\_$FName$=$'James'