Q:

Choose the correct option regarding the query:

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

Choose the correct option regarding the query:

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;
  1. The having clause checks whether the query result is true or not
  2. The having clause does not check for any condition
  3. The having clause allows only those tuples that have average balance 10000
  4. None of the mentioned
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

 (c).The having clause allows only those tuples that have average balance 10000

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