Following query will retrieve vendors who have average invoice amount $<10000$

SELECT vendor$\_$id$,$ AVG$($invoice$\_$amount$)$

FROM invoice

WHERE AVG$($invoice$\_$amount$)<10000$

GROUP BY vendor$\_$id;