Basic SELECT statement: Get the average salary and number of employees
MySQL Basic Select Statement: Exercise-8 with Solution
Write a query to get the average salary and number of employees in the employees table.
Sample table: employees
Code:
-- Calculating the average salary and counting the total number of employees
SELECT AVG(salary), COUNT(*)
-- Selecting data from the employees table
FROM employees;
Explanation:
- This SQL query calculates the average salary and counts the total number of employees in the employees table.
- The AVG() function calculates the average value of the specified column (salary in this case).
- The COUNT(*) function counts the number of rows in the table, which effectively counts the total number of employees.
Relational Algebra Expression:
Relational Algebra Tree:
Pictorial Presentation of the above query
Result :
MySQL Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query to get the maximum and minimum salary from employees table.
Next: Write a query to get the number of employees working with the company.
What is the difficulty level of this exercise?
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics