Write a SQL query for the average transaction amount for customers who have made more than 10 purchases in the last 90 days.

Question

Anonymous · Accepted Answer

select sum(amount)/count( distinct transaction_id) as avg_transaction
FROM transactions WHERE transaction_date >= CURRENT_DATE - INTERVAL '90 days'
GROUP BY customer_id
HAVING COUNT(transaction_id) > 10;

Anonymous · Answer

SELECT customer_id,
AVG(transaction_amount) AS avg_transaction_amount
FROM transactions WHERE transaction_date >= CURRENT_DATE - INTERVAL '90 days'
GROUP BY customer_id
HAVING COUNT(transaction_id) > 10;

Write a SQL query for the average transaction amount for customers who have made more than 10 purchases in the last 90 days.

Answers

Unlock Community Insights

Unlock Community Insights

Try Free AI Interview

Google

Product Manager

Meta

Product Manager

Meta

Engineering Manager

Amazon

Data Scientist