Question 3Display only the jobs with maximum salary greater than or equal to 3000.Table: EmplEMPNOENAMEJOBMGRHIREDATESALCOMMDEPTNO8369SMITHCLERK89021990-12-18800NULL208499ANYASALESMAN86981991-02-201600300308521SETHSALESMAN86981991-02-221250500308566MAHADEVANMANAGER88391991-04-022985NULL208654MOMINSALESMAN86981991-09-2812501400308698BINAMANAGER88391991-05-012850NULL308839AMIRPRESIDENTNULL1991-11-185000NULL108844KULDEEPSALESMAN86981991-09-0815000308882SHIAVNSHMANAGER88391991-06-092450NULL108886ANOOPCLERK88881993-01-121100NULL208888SCOTTANALYST85661992-12-093000NULL208900JATINCLERK86981991-12-03950NULL308902FAKIRANALYST85661991-12-033000NULL208934MITACLERK88821992-01-231300NULL10

Question

Accepted Answer

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

EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO
8369	SMITH	CLERK	8902	1990-12-18	800	NULL	20
8499	ANYA	SALESMAN	8698	1991-02-20	1600	300	30
8521	SETH	SALESMAN	8698	1991-02-22	1250	500	30
8566	MAHADEVAN	MANAGER	8839	1991-04-02	2985	NULL	20
8654	MOMIN	SALESMAN	8698	1991-09-28	1250	1400	30
8698	BINA	MANAGER	8839	1991-05-01	2850	NULL	30
8839	AMIR	PRESIDENT	NULL	1991-11-18	5000	NULL	10
8844	KULDEEP	SALESMAN	8698	1991-09-08	1500	0	30
8882	SHIAVNSH	MANAGER	8839	1991-06-09	2450	NULL	10
8886	ANOOP	CLERK	8888	1993-01-12	1100	NULL	20
8888	SCOTT	ANALYST	8566	1992-12-09	3000	NULL	20
8900	JATIN	CLERK	8698	1991-12-03	950	NULL	30
8902	FAKIR	ANALYST	8566	1991-12-03	3000	NULL	20
8934	MITA	CLERK	8882	1992-01-23	1300	NULL	10

JOINS and SET Operations — Question 3

Question 3

Output