Question 16Display only the jobs with maximum salary greater than or equal to 3000.

Question

Bright Tutorials · Accepted Answer

SELECT Job 
FROM Empl 
GROUP BY Job HAVING MAX(Sal) >= 3000;Output+-----------+
| Job       |
+-----------+
| PRESIDENT |
| ANALYST   |
+-----------+

Grouping Records, Joins in SQL — Question 17