Practice 3 (continu ed) If you want an extra challenge, complete the following exercises: 11. Create a query that displays the last names and commission amounts. If an employees’ employee does not earn commission, show Label the column COMM. “No Commission.” … 12. Create a query that displays the first eight characters of the last names and employees’ indicates the amounts of their salaries with asterisks. Each asterisk signifies a thousand dollars. Sort the data in descending order of salary. Label the column EMPLOYEES_AND_THEIR_SALARIES. … Oracle Database 10g: SQL Fundamentals I 3-67
Practice 3 (continu ed) If you want an extra challenge, complete the following exercises: 11. Create a query that displays the employees’ last names and commission amounts. If an employee does not earn commission, show “No Commission.” Label the column COMM. … 12. Create a query that displays the first eight characters of the employees’ last names and indicates the amounts of their salaries with asterisks. Each asterisk signifies a thousand dollars. Sort the data in descending order of salary. Label the column EMPLOYEES_AND_THEIR_SALARIES. … Oracle Database 10g: SQL Fundamentals I 3-67