Course Hero Logo

Aggregate functions on a single set of tuples a find

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 11 - 14 out of 30 pages.

Aggregate functions ona single set of tuplesa) Find the average account balance.:
b) Find the total account balance of Mirpur branch.:
c) Find the average account balance, maximum account balance at each branch.
d) Find numbers of depositors for each branch.
e) Find branch name and average balance where average balance is greaterthan 1200.
f) Find branch name and average balance of Mirpur, Firmgate or Dhanmonidibranch where average balance is greater than 1200.
g) Find the minimum loan amount.
h) Count the number of tuples in customer relation.
i) Find the average balance for each customer who lives in Dhaka and has atleast three accounts.=
group byD.customer_namehavingcount(distinctD.account_no) >=33.6 Null ValuesIt is possible for tuples to have a null value, denoted bynull, for some of theirattributes.nullsignifies an unknown value or that a value does not exist. Thepredicateis nullcan be used to check for null values. The predicateis notnulltests for the absence of a null value.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 30 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
Mahfuz Reza
Tags
clause, relation, branch name, Mirpur branch

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture