Objectives: learn to use the IN and NOT IN operators and the wildcard search operator. Along with a derived value as a column in a result set.

For this assignment we will be using the emp table.

Open ApEx and navigate to the SQL Workshop SQL Scripts screen:

1. Create a file called ps3a.sql script. Write a SQL query that displays the employee number, employee name, manager and job for all employees that have a manger with the ID number of 7839, 7566 or 7902. Use the IN operator to obtain your result set. Copy and paste your query and result set screen shot into your assignment.

2. Create a file called ps3b.sql. Write a SQL query that displays the employee number, employee name job and salary for everyone not in the clerk or salesperson job description. Use the not in operator to filter the results in the result set. Copy and paste your query and result set screen shot into your assignment.

3. Create a file called ps3c.sql. Write a SQL query that will return the empno, ename, job and salary for any employees whose name begins with M. Copy and paste your query and result set screen shot into your assignment.

4. Create a file called ps4d.sql Create a SQL script will show the empno, ename, job, base salary and amount of salary after the raise amount of 20% is applied. The mathematical operation of the sal * 20% will be one of the columns in the result set. Create a column alias for this new derived column called Raise. Copy and paste your query and result set screen shot into your assignment.