Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
this question and the output that he need
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Explain in detail the different methods of performance appraisal .

Answered: 1 week ago

Question

=+4 How did it affect HR?

Answered: 1 week ago