#309 Average Transaction Amount by Customer Accounts

Companies:

Exon

Themes:

SQLJoinsAggregationPractice

The following tables are given:

Customer
id | name | address
...

Account
id | acc_number | description | customer_id
...

Fin_transaction
id | transactDate | amount | account_id | description
...

A customer may have no personal accounts. A personal account may have no transactions. Write an SQL query that returns the customer name, the description of their personal account, and the average transaction amount for that account.

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.