Question: this information this question and the output that he need what the code for this output ENO E_HEAD_NO 101 102 103 104 ENAME AHMAD AMMAR

this information
this information this question and the output that he need what the
this question and the output that he need
code for this output ENO E_HEAD_NO 101 102 103 104 ENAME AHMAD
what the code for this output

ENO E_HEAD_NO 101 102 103 104 ENAME AHMAD AMMAR REHAN BOTHIMAH EMPLOYEE DOB 12-Jun-91 9-Jan-84 18-Feb-85 21-Mar-80 101 101 101 GENDER MALE MALE MALE FEMALE JOB_TYPE JNO JTYPE JDESS 1000 PROFESSOR MANAGING 1001 ASST. PROF TEACHING 1002 ASSC. PROF TEACHING 1003 LECTURER LAB ENO 101 102 JNO 1001 1002 1003 1000 EMP_JOB JDATE 17-May-18 22-May-15 28-May-15 23-Jun-17 SALARY 18000 9000 4000 17000 103 104 TAX 0 TAX_RATE LSAL 0 5001 10000 HSAL 5000 9999 20000 5 10 Write a query to display the following columns ENAME EMPITYPE EMP TAX, EMPLOYEE SALARY AFTER DEDUCTING PERCENTAGE OF TAX, EMPLOYEE HEAD NAME, HEAD TYPE..HEAD TAX, EMP HEAD SALARY AFTER DEDUCTING PERCENTAGE OF TAX OUTPUT ENAME EMP TYPE EMP TAX SAALRY AFTER TAX EMP HEAD N BOTHIMAH PROFESSOR 10 15300 AHMAD AMMAR ASSC. PROF 5 8550 AHMAD REHAN LECTURER 0 4000 AHMAD For the toolbar, press ALT+F10 IPC) O ALTFN+F10 (Mac) HEAD JTYPE ASST PROF ASST. PROF ASST. PROF HEAD TAX HEAD SAALRY AFTER TAX 10 16200 10 16200 10 16200

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!