Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Practice

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 ...