Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 this question and the output that he need
what the code for this output
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started