Untitled

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;