Question
Which SQL query will correctly calculate the average
salary of employees in each department and group them by department in a table named 'employees'?Solution
To calculate the average salary of employees in each department, we need to use the AVG() aggregate function in SQL. The GROUP BY clause is essential here, as it groups the results by department, ensuring the average is calculated for each individual department, not for the entire table. The correct SQL query is: SELECT department, AVG(salary) FROM employees GROUP BY department This query returns the department and the average salary of employees in that department. Why other options are wrong: b) SELECT department, SUM(salary) FROM employees GROUP BY department : This calculates the sum of the salary, not the average. It’s useful when you want the total salary for each department. c) SELECT department, AVG(salary) FROM employees : This query is incomplete because it lacks the GROUP BY clause. Without it, it would give the average salary for the entire table, not by department. d) SELECT AVG(salary) FROM employees GROUP BY department : This query incorrectly places the aggregate function without selecting the department column, which will result in an error or incorrect output. e) SELECT department, COUNT(salary) FROM employees GROUP BY department : This counts the number of salaries in each department, not the average salary.
Which type of surface irrigation, fields is divided into strips that are separated by border ridges running through gradient of field?
The following operations are practiced in the cultivation of tobacco
1. Priming
2. Topping
3. Desuckering
The correct sequen...
Global Warming Potential of Nitrous Oxide (Nâ‚‚O) is ____ for 100 year timescale.Â
Which of the following is also known as downy mildew fungus" ?
The most widely grown species of rose for cut flower production under protected cultivation is:
Given below are two statements:
Statement I: Orobanche (Broomrape) is a total-root parasitic weed in rapeseed mustard.
Statement II: Strig...
Which of the following statements is/are true?
Statement A: Organic matter in the soil improves soil fertility and nutrient availability.
...
“Economics is the study of the administration of scarce resources and the determinants of employment and income.” Definition of Economics was given ...
Citrus canker is caused by
Income elasticity of inferior goods is ........................?