Question $40$

SELECT

FROM Agent A$,$ SalesOrder S

WHERE A$.$Agent$\_$ID$=$S$.$Agent$\_$ID

$($please fill in this blank$)$

AND COUNT$($Order$\_$ID$)>=10$

AND COUNT$($Order$\_$ID$)10$

GROUP BY Agent$\_$LName

AND COUNT$($Order$\_$ID$)10$

ORDER BYAgent$\_$LName

GROUP BY Agent$\_$LName

HAVING COUNT$($Order$\_$ID$)>=10$

$?$

GROUP BY Agent$\_$LName