Q:

Observe the given SQL query and choose the correct option

mhmadesk
Save to bookmark
|
2022-07-13
|
  413 
Medium
0

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
  1. The query is syntactically correct but gives the wrong answer
  2. The query is syntactically wrong
  3. The query is syntactically correct and gives the correct answer
  4. The query contains one or more wrongly named clauses.
Database, MCQ Questions, Database MCQ-questions,
login and add your own answer to this question

All Answers

mhmadesk
2022-07-13
need an explanation for this answer? contact us directly to get an explanation for this answer

 (b).The query is syntactically wrong

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now