Use the Employees table (copy and paste the code in SQL command line) Based on the given table: Employees table as shown below, write the PL/SQL that applies single row function in order to get the printed output per number. Write your answer in a short bond paper. Copy and paste the PL/SQL code on the space provided after each questions.

8:47 pm Thu 28 Jan 75% 205 SHELLEY 206 WILLIAM Not Secure - Ims.amauonline.com HIGGINS AC MGR 12000 GIETZ AC ACCOUNT 8300 101 205 110 110 1. NAME King, Steven Hunold, Alexander Ernst, Bruce Lorentz, Diana FIRSTNAME SALARY BONUS 2. 24000 $$$26300 17000 $$$18600 17000 $$$18600 STEVEN NENA LEX ALEXANDER BRUCE DIANA ELENI JONATHAN MICHAEL PAT 6000 $$$$6500 4200 $$$$4520 10500 $$$11450 8600 $$$$9360 13000 $$$14200 6000 $$$$6500 SALARY RPAD(SALARY,4, '@ 3. LASTNAME ERNST LORENTZ MOURGOS TAYLOR GRANT WHALEN FAY GIETZ RECORD 6000 6000 4200 4200 5800 5800 8600 8600 7000 7000 4400 4400 6000 6000 8300 8300 4. LNAME kingwith a salary of 24000 hunoldwith a salary of 4 6 5. NAME INSTR(LASTNAME, 'A') Matosthat Belongs To Department Id Number50 2 Vargasthat Belongs To Department Id Number 50 2 Higginsthat Belongs To Department Id Number 110 6. (LASTNAME ||FIRSTNAME JOB_ID ABELELLEN TAYI ORIONATHAN SAREP SA REP 8:47 pm Thu 28 Jan 75% FAY GIETZ RECORD Not Secure - Ims.amauonline.com 6000 6000 8300 8300 4. LNAME kingwith a salary of 24000 hunoldwith a salary of 4 6 5. NAME INSTR (LASTNAME, 'A') Matosthat Belongs To Department Id Number 50 2 Vargasthat Belongs To Department Id Number 50 2 Higgins that Belongs To Department Id Number 110 0 6. (LASTNAME FIRSTNAME JOB_ID ABELELLEN TAYLORJONATHAN GRANTKIMBERLEY FAYPAT TRIM LASTNAME SA_REP SA REP SA_REP MK_REP DEPARTMENT_ID MANAGER_ID 7. MOURGOS MOURGOS 50 100 8. EXCESS SALARY 0 0 0 9 TRUNC (563.396,2) TRUNC (563.396,1) TRUNC (563.396,-2) TRUNC (563.396,-1) 563.39 563.3 500 560 10. ROUND(563.396,2) ROUND(563.396,1) ROUND(563.396,-2) ROUND(563.396,-1) 563.4 563.4 600 560 8:47 pm Thu 28 Jan 75% 205 SHELLEY 206 WILLIAM Not Secure - Ims.amauonline.com HIGGINS AC MGR 12000 GIETZ AC ACCOUNT 8300 101 205 110 110 1. NAME King, Steven Hunold, Alexander Ernst, Bruce Lorentz, Diana FIRSTNAME SALARY BONUS 2. 24000 $$$26300 17000 $$$18600 17000 $$$18600 STEVEN NENA LEX ALEXANDER BRUCE DIANA ELENI JONATHAN MICHAEL PAT 6000 $$$$6500 4200 $$$$4520 10500 $$$11450 8600 $$$$9360 13000 $$$14200 6000 $$$$6500 SALARY RPAD(SALARY,4, '@ 3. LASTNAME ERNST LORENTZ MOURGOS TAYLOR GRANT WHALEN FAY GIETZ RECORD 6000 6000 4200 4200 5800 5800 8600 8600 7000 7000 4400 4400 6000 6000 8300 8300 4. LNAME kingwith a salary of 24000 hunoldwith a salary of 4 6 5. NAME INSTR(LASTNAME, 'A') Matosthat Belongs To Department Id Number50 2 Vargasthat Belongs To Department Id Number 50 2 Higginsthat Belongs To Department Id Number 110 6. (LASTNAME ||FIRSTNAME JOB_ID ABELELLEN TAYI ORIONATHAN SAREP SA REP 8:47 pm Thu 28 Jan 75% FAY GIETZ RECORD Not Secure - Ims.amauonline.com 6000 6000 8300 8300 4. LNAME kingwith a salary of 24000 hunoldwith a salary of 4 6 5. NAME INSTR (LASTNAME, 'A') Matosthat Belongs To Department Id Number 50 2 Vargasthat Belongs To Department Id Number 50 2 Higgins that Belongs To Department Id Number 110 0 6. (LASTNAME FIRSTNAME JOB_ID ABELELLEN TAYLORJONATHAN GRANTKIMBERLEY FAYPAT TRIM LASTNAME SA_REP SA REP SA_REP MK_REP DEPARTMENT_ID MANAGER_ID 7. MOURGOS MOURGOS 50 100 8. EXCESS SALARY 0 0 0 9 TRUNC (563.396,2) TRUNC (563.396,1) TRUNC (563.396,-2) TRUNC (563.396,-1) 563.39 563.3 500 560 10. ROUND(563.396,2) ROUND(563.396,1) ROUND(563.396,-2) ROUND(563.396,-1) 563.4 563.4 600 560