The following code is an example of a$($n$)$:

SELECT CUSTOMER.CustomerID, OrderID, OrderTotal

FROM CUSTOMER JOIN ORDER

ON CUSTOMER.CustomerID $=$ ORDER.CustomerID

WHERE OrderTotal $>=$

$($SELECT AVG$($OrderTotal$)$ FROM ORDER$)$;

Group of answer choices

Aggregate subquery

Compound subquery

Rows subquery

Scalar subquery

Table subquery