Consider the set of relations
Write an SQL query to:
Calculate, for each department number, the number of employees with a salary greater than Rs. 1,00,000
SELECT Dept-no, count(Employee-no) as total_employees
WHERE Salary > 100000
GROUP BY Dept-no
That is google form link. You may try ...