TB_JOB_HISTORY EMPLOYEE ID START DATE END DATE JOB_ID DEPARTMENT_ID 3/24/2006 12/31/2007 ST CLERK мк МAN 114 50 112 1/15/2000 1/15/2010 MK_MAN AD ASST 20 1/15/2009 12/31/2011 12/31/2010 8/18/2006...

In The SQL Oracle Application

Using the UNION operator, write a query that displays the employee_id, job_id, and salary of ALL present and past employees. If a salary is not found, then just display a 0 (zero) in its place.

TB_JOB_HISTORY<br>EMPLOYEE ID<br>START DATE<br>END DATE<br>JOB_ID<br>DEPARTMENT_ID<br>3/24/2006<br>12/31/2007<br>ST CLERK<br>мк МAN<br>114<br>50<br>112<br>1/15/2000<br>1/15/2010<br>MK_MAN<br>AD ASST<br>20<br>1/15/2009<br>12/31/2011<br>12/31/2010<br>8/18/2006<br>6/10/2006<br>1/5/2000<br>115<br>10<br>111<br>MK REP<br>20<br>116<br>2/10/2001<br>ST CLERK<br>50<br>5/6/2002<br>7/15/2006<br>113<br>AD ASST<br>10<br>117<br>12/31/2015<br>AP MAN<br>30<br>1/15/2000<br>1/15/2000<br>118<br>8/5/2007<br>MR REP<br>40<br>8/15/2010<br>12/31/2007<br>119<br>MR REP<br>40<br>120<br>1/5/2003<br>AP MAN<br>30<br>TB EMPLOYEES<br>EMP_ID<br>LASTNAME<br>FIRSTNAME<br>EMAIL<br>PHONE_NUMBER<br>HIRE DATE<br>JOB ID<br>SALARY<br>COMMISSION PCT<br>MNGR_ID<br>ST CLERK<br>MK_MAN<br>AD ASST<br>мK REP<br>114<br>TALAG<br>JOY<br>italag@gmailLcom<br>745-65-52<br>3/25/2006<br>16975.85<br>0.5<br>113<br>112<br>BERMUDEL<br>RUDY<br>rbermudel@gmail.com<br>152-52-56<br>1/15/2000<br>15000.95<br>0.5<br>111<br>115<br>ASIS<br>ROLLY<br>rasis@gmail.com<br>458-96-54<br>6/15/2006<br>30257.95<br>0.2<br>111<br>111<br>SEVILLA<br>MARIE<br>msevilla@gmail.com<br>851-84-32<br>1/10/2000<br>35741.95<br>0.2<br>116<br>HERRERA<br>ETHEL<br>eherrera@gmail.com<br>741-52-01<br>2/10/2001<br>ST_CLERK<br>50743,52<br>0.3<br>113<br>DE LOS SANTOS<br>edelossantos@gmail.com<br>mgruyal@gmail.com<br>5/10/2002<br>7/20/2006<br>113<br>ERIC<br>952-41-85<br>AD_ASST<br>25984.75<br>0.3<br>117<br>GRUYAL<br>MARVIN<br>365-45-85<br>AP_MAN<br>26415.65<br>0.2<br>113<br>118<br>PAULE<br>BALLERIE<br>bpaule@gmail.com<br>958-42-25<br>1/15/2000<br>MR_REP<br>85213.25<br>0.5<br>111<br>RIEGO<br>MARICAR<br>854-85-32<br>1/15/2000<br>MR_REP<br>АР MAN<br>119<br>mrieg@gmail.com<br>95145.95<br>0.3<br>111<br>120<br>SICAT<br>MILET<br>msicat@gmail.com<br>965-41-03<br>1/10/2003<br>84652.8<br>0.2<br>113<br>

Extracted text: TB_JOB_HISTORY EMPLOYEE ID START DATE END DATE JOB_ID DEPARTMENT_ID 3/24/2006 12/31/2007 ST CLERK мк МAN 114 50 112 1/15/2000 1/15/2010 MK_MAN AD ASST 20 1/15/2009 12/31/2011 12/31/2010 8/18/2006 6/10/2006 1/5/2000 115 10 111 MK REP 20 116 2/10/2001 ST CLERK 50 5/6/2002 7/15/2006 113 AD ASST 10 117 12/31/2015 AP MAN 30 1/15/2000 1/15/2000 118 8/5/2007 MR REP 40 8/15/2010 12/31/2007 119 MR REP 40 120 1/5/2003 AP MAN 30 TB EMPLOYEES EMP_ID LASTNAME FIRSTNAME EMAIL PHONE_NUMBER HIRE DATE JOB ID SALARY COMMISSION PCT MNGR_ID ST CLERK MK_MAN AD ASST мK REP 114 TALAG JOY italag@gmailLcom 745-65-52 3/25/2006 16975.85 0.5 113 112 BERMUDEL RUDY [email protected] 152-52-56 1/15/2000 15000.95 0.5 111 115 ASIS ROLLY [email protected] 458-96-54 6/15/2006 30257.95 0.2 111 111 SEVILLA MARIE [email protected] 851-84-32 1/10/2000 35741.95 0.2 116 HERRERA ETHEL [email protected] 741-52-01 2/10/2001 ST_CLERK 50743,52 0.3 113 DE LOS SANTOS [email protected] [email protected] 5/10/2002 7/20/2006 113 ERIC 952-41-85 AD_ASST 25984.75 0.3 117 GRUYAL MARVIN 365-45-85 AP_MAN 26415.65 0.2 113 118 PAULE BALLERIE [email protected] 958-42-25 1/15/2000 MR_REP 85213.25 0.5 111 RIEGO MARICAR 854-85-32 1/15/2000 MR_REP АР MAN 119 [email protected] 95145.95 0.3 111 120 SICAT MILET [email protected] 965-41-03 1/10/2003 84652.8 0.2 113

Jun 04, 2022

SOLUTION.PDF

TB_JOB_HISTORY EMPLOYEE ID START DATE END DATE JOB_ID DEPARTMENT_ID 3/24/2006 12/31/2007 ST CLERK мк МAN 114 50 112 1/15/2000 1/15/2010 MK_MAN AD ASST 20 1/15/2009 12/31/2011 12/31/2010 8/18/2006...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment