Observe The Given Sql Query And Choose The Correct Optionp Pre #16
Observe the given SQL query and choose the correct option.</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</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.
Observe the given SQL query and choose the correct option.
select branch_name, count (distinct customer_name) from depositor, account where depositor.account_number = account.account_number group by branch_id
The query is syntactically correct but gives the wrong answer
The query is syntactically wrong
The query is syntactically correct and gives the correct answer
The query contains one or more wrongly named clauses.
