Write a PostgreSQL query to return the top 3 customers by transaction volume in each region. Rank customers by total transaction count, break ties by higher total transaction amount, and then by lower customer_id.
Schema
Tables
customers
regions
transactions
Tablescustomersregionstransactions
Interviewer
Whenever you're ready, walk me through your approach or go straight to the code. The requirements and the three tables are in the Question tab.