Joining Tables (Solutions)

1

Find a list of employees where the salary paid is in the range $60000to$70000.

DISCUSSION

Here is an alternate solution to this question:

Which syntax for the WHERE clause do you prefer? Why?

NOTE

English is an imprecise language. Technically, the wording of the question implies the following solution – showing just the ID and names of employees who have had a salary in the desired range.

However, knowing the salaries themselves (as in the two queries above) is useful information.

2

Find a list of employees whose salary is not in the range $60000to$70000.

NOTE

Technically, the wording of the question implies the following solution:

3

Find the maximum salary, minimum salary, first name, and last name for employee number 10012.

4

Find the maximum and minimum salary paid to all employees. Include employee names.

5

Find a list of all the job titles held by employee number 499998, and their name. List the job titles in alphabetical order.