Choose The Correct Option Regarding The Queryp Pre Langsql #19

Choose the correct option regarding the query</p> <pre><code class="language-sql"> select branch_name, count (distinct customer_name) from depositor, account where depositor.account_number = account.account_number group by branch_id having avg(balance) = 10000;</code></pre>

This multiple choice question (MCQ) is related to the book/course gs gs114 Relational Database Management System. It can also be found in gs gs114 Introduction to Relational Model and SQL - Aggregate Functions - Quiz No.1.

 select branch_name, count (distinct customer_name) from depositor, account where depositor.account_number = account.account_number group by branch_id having avg(balance) = 10000;