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$=$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 A$.$Agent$\_$LName$=$'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$=1.$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'