Retrieving Information from a Table › Testing Your Knowledge

Testing Your Knowledge

Using the sample tables in Appendix A, "Sample Tables and Database", code a SELECT statement for each of the queries listed below. , contains one possible answer. Remember, there can be more that one way to achieve the same result when you use the SELECT statement.

1. List the salary range for each job class
2. List all employees who have both a:
   • Manager with ID 0007 or 0003
   • Job that begins with the number 3
3. Identify all employees whose sex code was entered incorrectly (that is, is not M or F)
4. List the number of years employees have from January 1, 1988 until they reach retirement age (65)