Skip to main content
All Problems
medium0% acceptance

Deposit Volume by Day of Week

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