# Question

For each of the SQL aggregate functions sum, count, min and max, show how to compute the aggregate value on a multiset S1 ∪ S2, given the aggregate values on multisets S1 and S2.

Based on the above, give expressions to compute aggregate values with grouping on a subset S of the attributes of a relation r (A, B, C, D, E), given aggregate values for grouping on attributes T ⊇ S, for the following aggregate functions:

a. sum, count, min and max

b. avg

c. standard deviation

Based on the above, give expressions to compute aggregate values with grouping on a subset S of the attributes of a relation r (A, B, C, D, E), given aggregate values for grouping on attributes T ⊇ S, for the following aggregate functions:

a. sum, count, min and max

b. avg

c. standard deviation

## Answer to relevant Questions

Show how to express group by cube (a, b, c, d) using rollup; your answer should have only one group by clause.Consider the balance attribute of the account relation. Write an SQL query to compute a histogram of balance values, dividing the range 0 to the maximum account balance present, into three equal ranges.Compute the relevance (using appropriate definitions of term frequency and inverse document frequency) of each of the questions in this chapter to the query “SQL relation.”Suppose you want to store line segments in an R-tree. If a line segment is not parallel to the axes, the bounding box for it can be large, containing a large empty area.• Describe the effect on performance of having large ...Explain how a TP monitor manages memory and processor resources more effectively than a typical operating system.Post your question

0