Calculate the average value of orders placed by customers located in the United States who have made at least 3 orders in the last month, using data from the "orders" and "customers" tables. Use a join operation in your 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

Calculate the average value of orders placed by customers located in the United States who have made at least 3 orders in the last month, using data from the "orders" and "customers" tables. Use a join operation in your query.

Practice this question with AI

Go Premium

Community Answers

Unlock Full Access

Practice More Questions