This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: In-class Exercises Solutions R: 2/1/10 dd 1.From the EMPLOYEE table, select all fields (columns) for all employees. Sort the query in ascending order by last name. (Hint: you can show all fields for a particular table by including the “*” field in the design view.) 2.From the EMPLOYEE table, select only the first and last names and salary of all employees. 3.Select employees who received a “Poor” performance rating. In the results show only the first and last names of the employees. 4.Show the first and last name only of employees who received a “Good” performance rating and earn more than $50,000. Practice on paper or online: Fill out the Query design grid. Hint: be sure to enter the field names, table names, and the criteria.5.From the EMPLOYEE table, select the SSN, first and last names, and performance rating of all employees who work at the Chicago location:6.Select records for employees who have either “Emily” or “Frank” as their first name. Show the first and last name of these employees as well as their salary. Equals 7.Select employees with the first name of Holly and received a “Good” performance rating, but in the same query select all employees who received an “Average” performance rating. Display SSN and first and last names in the results. Practice on paper or online:8.Create a query that shows only the last and first name, location city, and position title of employees who earn less than $50,000. 9.Select all of the employees that received either an “Average” or “Poor” performance rating and work in Chicago. Show first name, last name, and performance rating from the Employee table and location city from the Location table....
View Full Document
- Winter '11
- Salary, Personal name, Surnames