The operations team wants to understand deposit patterns by day of week. For deposit transactions only, return the day of the week (0=Sunday through 6=Saturday using strftime), the count of deposits, and the average deposit amount rounded to 2 decimals. Sort by day_of_week.
Schema
🔑idINT
🔗account_idINT
transaction_dateTEXT
typeTEXT
amountREAL
balance_afterREAL
descriptionTEXT
reference_numberTEXT
postgresql
Run your query to see results
Press Ctrl + Enter to execute