Find the average value of orders placed by customers located in the United States who have made at least 3 orders over the past month, by performing a join between the "orders" and "customers" tables in your SQL query.

Question

Anonymous · Accepted Answer

SELECT

C.CUSTOMER_ID,

SUM(AMOUNT)  / COUNT(O.ORDER_ID)   AS AVERAGE_ORDER_VALUE

FROM
orders o

JOIN  CUSTOMERS  C ON O.CUST_ID = C.CUSTOMER_ID

WHERE
location = 'USA' AND and o.order_date >= DATEADD( month, -1, GETDATE())

GROUP BY

C.CUSTOMER_ID

HAVING

COUNT(O.ORDER_ID) >= 3

Find the average value of orders placed by customers located in the United States who have made at least 3 orders over the past month, by performing a join between the "orders" and "customers" tables in your SQL query.

Practice this question with AI

Go Premium

Community Answers

Unlock Full Access

Practice More Questions