Direction: Choose the correct option
Q1.
Which SQL function counts the number of rows?
Direction: Choose the correct option
Q2.
SELECT AVG(salary) FROM employees;What does AVG() calculate?Direction: Choose the correct option
Q3.
SELECT SUM(salary) FROM employees;What does this return?Direction: Choose the correct option
Q4.
SELECT MAX(salary), MIN(salary) FROM employees;What information does this provide?Direction: Choose the correct option
Q5.
SELECT COUNT(*) AS total, AVG(salary) AS avg_salary FROM employees;What does AS do here?