Welcome to your AGGREGATE FUNCTION IN SQL

1. Aggregate functions should not be used in the ‘where’ clause we can use them in the ‘have’ clause.

a. Yes

b. No

2. Which aggregate function is used to find the maximum number?

a. max

b. min

3. Which aggregate function is used to find the sum of values?

a. total

b. sum

4. select avg(salary) as avg_salary is a correct syntax?

a. Yes

b. No

5. Display the number of rows present in any table.

a. select count (*) from employee.

b. select * from employee;

6. Display the maximum salary from the employee table.

a. select max(salary) as highest_salary from employee;

b. select min(salary) as highest_salary from employee;

7. How many types of aggregate functions are there?

a. Five

b. Four

8. What is the 'min' aggregate function?

a. minimum

b. maximum

9. Display the minimum salary from the employee table.

a. select min(salary) as minimum_salary from employee;

b. select max(salary) as minimum_salary from employee;

10. Which function is used to find the count of values?

a. count

b. avg

AGGREGATE FUNCTION IN SQL