These exercises can be used for extra practice after you have discussed the following topics: basic SQL
SELECT statement, basic iSQL*Plus commands, and SQL functions.
1. Show all data of the clerks who have been hired after the year 1997
2. Show the last name, job, salary, and commission of those employees who earn commission. Sort
the data by the salary in descending order.
3. Show the employees that have no commission with a 10% raise in their salary (round off the