Akila0-code
commented
5 hours ago s Objective: Practice basic SELECT, WHERE, ORDER BY, and LIMIT. You have a database with two tables: Employees and Departments. Employees (emp_id, emp_name, department_id, salary, hire_date); Departments (department_id, department_name);
- Write a query to select all employees from the Employees table.
- Find all employees who earn more than 50,000
- List all employees hired after January 1, 2020.
- Sort the employees by salary in descending order and limit the result to 5 rows.
- Find the names of employees and the names of their departments.
- Find the total number of employees in each department.
- Calculate the average salary of employees in each department.
- Identify departments that have more than 3 employees.
- Calculate the total salary paid to employees in each department.
- Find all pairs of employees who work in the same department and compare their salaries. Show the employee names, department names, and their respective salaries.
- Find all departments where the average employee salary is greater than 70,000. Use the HAVING clause.
- List departments that have more than 10 employees.
- Find departments where the total salary paid to employees exceeds 500,000.
- Find employees who work in the 'HR' department.
- List departments with the number of employees in each.
- Find the department(s) with the highest average employee salary. (use LIMIT).
- List departments where no employees have a salary more than 100,000
اريد حل هذا التمرين بالعربية Objective: Practice basic SELECT, WHERE, ORDER BY, and LIMIT. You have a database with two tables: Employees and Departments. Employees (emp_id, emp_name, department_id, salary, hire_date); Departments (department_id, department_name);