AND deptno = 30
OR mgr = 7782
If you want extra challenge, complete the following exercises:
12. Display the name, job, and salary for all employees whose job is Clerk or Analyst and
their salary is not equal to $1000, $3000, or $5000.
13. Modify p2q6.sql to display the name, salary, and commission for all employees whose
commission amount is greater than their salary increased by 10%. Rerun your query. Resave
your query as p2q13.sql.
1. Write a query to display the current date. Label the column Date.
2. Display the employee number, name, salary, and salary increase by 15% expressed as a
whole number. Label the column New Salary. Save your SQL statement to a file named
3. Run your query in the file p3q2.sql.