📝 Question
#1066
Aggregate functions are functions that take a ___________ as input and return a single value.
✓
Correct Answer
A. Collection of values
💡
Explanation
None. 2. SELECT __________ FROM instructor WHERE dept name= ’Comp. Sci.’; a) Mean(salary) b) Avg(salary) c) Sum(salary) d) Count(salary) Avg() is used to find the mean of the values. 3. SELECT COUNT (____ ID) FROM teaches WHERE semester = ’Spring’ AND YEAR = 2010; a) Distinct b) Count c) Avg d) Primary key Distinct keyword is used to select only unique items from the relation.
⌨️ Press
A
B
C
D
to select