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

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 in the last month, by performing a join between the "orders" and "customers" tables.

Practice this question with AI

Go Premium

Practice More Questions

Community Answers

Unlock Full Access

Everything You Need to Ace DS Interviews