gs gs114 Introduction to Relational Model and SQL - Aggregate Functions - Quiz No.1
gs gs114 Relational Database Management System Quiz
This quiz belongs to book/course code gs gs114 Relational Database Management System of gs organization. We have 63 quizzes available related to the book/course Relational Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Introduction to Relational Model and SQL. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
select branch_name, count (distinct customer_name) from depositor, account where depositor.account_number = account.account_number group by branch_id
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;