Skip to main content
All Problems
medium0% acceptance

Average Transaction Amount Per Customer

The analytics team wants to know the average transaction amount for each customer. Return first_name, last_name, and avg_tx_amount (rounded to 2 decimal places). Only include customers who have at least 5 transactions. Sort by avg_tx_amount descending.

Schema

🔑idINT
first_nameTEXT
last_nameTEXT
emailTEXT
phoneTEXTNULL
date_of_birthTEXT
cityTEXT
stateTEXT
countryTEXT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute