Skip to main content
Practice

Calculate Average Spending per Client

A colleague from the analytics team wants to understand how much, on average, each customer spends per transaction.

You're asked to run a quick report showing these averages so they can identify high-value clients.

To get this insight, you'll use AVG() along with GROUP BY to calculate the average transaction amount per customer.


Task​

From the transactions table in the bank_transactions.sqlite database, display:

  • customer_id
  • average_spending (use an alias for the average)

Round the result to 2 decimal places, and sort by average_spending in descending order to see the top spenders first.


How to solve it​

Write a SQL query that calculates the average amount spent per transaction for each customer.

Use GROUP BY to group data by customer_id, and use ROUND(AVG(...), 2) to format the average.

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.