Your browser does not support JavaScript!

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT FIRSTNAME, SALARY, LPAD(SALARY * 0.10 + SALARY - 100, 8, =E2=80=98$') AS BONUSFROM EMPLOYEESWHERE DEPARTMENT_ID NOT IN (10, 110, 50AND SALARY=17000;

  • NENA       17000              $$$18600LEX          17000              $$$18600 Correct
  • NENA       17000              $$$17000LEX          17000              $$$17000
  • NENA       17000              17000$$$LEX          17000              17000$$$
  • NENA       17000              18600$$$LEX          17000              18600$$$
Similar IT-6202 questions