Develop an SQL query that uses a join between the "orders" and "customers" tables to calculate the average order value for United States-based customers who have made 3 or more orders in the last month.

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

Develop an SQL query that uses a join between the "orders" and "customers" tables to calculate the average order value for United States-based customers who have made 3 or more orders in the last month.

Practice this question with AI

Go Premium

Community Answers

Unlock Full Access

Practice More Questions