Untitled
unknown
plain_text
5 months ago
636 B
3
Indexable
SELECT d.Department AS Department, COUNT(e.ID) AS No_of_Employees FROM TBL_Department d LEFT JOIN TBL_Employee e ON d.ID = e.DepartmentID GROUP BY d.Department ORDER BY d.Department ASC; ------------------------------------------ USE EmpDb; SELECT employee_id, first_name, last_name, salary, CASE WHEN salary >= 50000 THEN 'High Salary' WHEN salary BETWEEN 30000 AND 49999 THEN 'Medium Salary' WHEN salary < 30000 THEN 'Low Salary' END AS salary_category FROM employees ORDER BY employee_id ASC;
Editor is loading...
Leave a Comment