How can I retrieve specific data from any Database in the context of SQL?
I am a data analyst in a particular company and today I need to retrieve some data from my database of employees and their departments. In other words, I have two tables: “Employees” and “Department”. The employee table includes the name, ID, and salary of the employees and the department table has the department ID. Now I am asked to find these values from the Database:-
List all employees with their department names and their salaries. Find the total number of employees in every department Determining the average salary of the employees of each department. Identifying the department which has the highest paid employee and their information.
Here are the solutions given related to the employee and department table queries in SQL:-
List all employees with their department names and their salaries:-
SELECT e.name, d.department_name, e.salary
FROM Employees e
INNER JOIN Department d ON e.department_id = d.department_id;
Find the total number of employees in every department:-
SELECT d.department_name, COUNT(e.employee_id) AS total_employees
FROM Employees e
INNER JOIN Department d ON e.department_id = d.department_id
GROUP BY d.department_name;
Determining the average salary of the employees of each department:-
SELECT d.department_name, AVG(e.salary) AS average_salary
FROM Employees e
INNER JOIN Department d ON e.department_id = d.department_id
GROUP BY d.department_name;
Identifying the department which has the highest paid employee and their information:-
SELECT d.department_name, e.name AS employee_name, e.salary
FROM Employees e
INNER JOIN Department d ON e.department_id = d.department_id
WHERE e.salary = (SELECT MAX(salary) FROM Employees)
LIMIT 1;This above example in the context of SQL would help you in retrieving the data from the database of employees and their departments.
Level up your career with Online SQL Server course! Start your journey to success today. Enroll now and unleash your full potential!