Question 3Give commission of Rs.500 to all employees who joined in year 1982 (table Empl).

Question

Accepted Answer

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-231300NULL10UPDATE Empl
SET COMM = 500
WHERE YEAR(HIREDATE) = 1982;ExplanationSince there are no employees who joined in the year 1982 according to the data provided in the "Empl" table, executing the given SQL query will result in no changes to the "COMM" column.

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

Table Creation and Data Manipulation Commands — Question 3

Question 3

Explanation