August 2002
Intermediate to advanced
528 pages
10h 12m
English
| 1: | From the database select the employees who have purchased glasses. Display the last name, first name, eyeglasses purchase date, and optician. |
| 2: | From the database select the employees who have purchased glasses and the employees who have not purchased glasses. Display the last name, first name, eyeglasses purchase date, and optician. |
| 3: | From the database select the employees who have purchased glasses. Display the department name, last name, first name, eyeglasses purchase date, and optician. |
| 4: | Reperform question 3. Be sure to qualify each of the columns this time. |
| 5: | Determine the minimum wages paid to an employee. |
| 6: | Determine the maximum wages paid to an employee. |
| 7: | Determine the employee’s street that has the largest and smallest ... |