Question
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;a.
The having clause checks whether the query result is true or not
b.
The having clause does not check for any condition
c.
The having clause allows only those tuples that have average balance 10000
d.
None of the mentioned
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Choose the correct option regarding the query:
Similar Questions
Discover Related MCQs
Q. The _____ aggregation operation adds up all the values of the attribute
View solution
Q. State true or false: Any attribute which is present in the having clause without being aggregated must not be present in the group by clause.
View solution
Q. State true or false: We can rename the resulting attribute after the aggregation function has been applied
View solution
Q. Which keyword is used to rename the resulting attribute after the application of the aggregation function?
View solution
Q. What values does the count(*) function ignore?
View solution
Q. What is a subquery?
View solution
Q. If a set is a collection of values given by the select clause, The ______ connective tests for set membership
View solution
Q. State true or false : Nested Subqueries cannot be used for comparing two different sets
View solution
Q. The ________ comparison checker is used to check “each and every” condition
View solution
Q. The ______ construct returns true if a given tuple is present in the subquery.
View solution
Q. What is a correlated sub-query?
View solution
Q. The _________ construct returns true if the argument in the sub-query is void of duplicates
View solution
Q. State true or false: We can use Subqueries inside the from clause
View solution
Q. SQL subqueries that can occur wherever a value is permitted provided the subquery gives only one tuple with a single attribute are called _________
View solution
Q. Insert the appropriate key word in the blank in the query ( A is a relation)
delete ______ A
where P < 5;
View solution
Q. How many relations can a delete command operate on?
View solution
Q. What is the format of entering date into a database while inserting data into it?
View solution
Q. To change a value in a tuple without changing all the values in the tuple, we use the _____ statement
View solution
Q. State true or false: We cannot write a where clause under an update command
View solution
Q. Scalar Subqueries can be used in the SQL update statement when they are used under the ____ clause
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
.png)
