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