And Another
Commonwealth Auto has employees who live in several different communities. The Accounting department needs to know which employees live in Boston because a city tax is being levied on those residents and the payroll must be adjusted.
Use the EMPLOYEE table to write a SELECT statement that selects all employees who live in Boston. Type in the value exactly as you expect to find it in the table, using uppercase and lowercase letters. Enclose the value in quotes because CITY is defined as a character column. Display employee ID, first and last name, and city and order the result by employee ID.
The result looks like this:
EMP_ID EMP_FNAME EMP_LNAME CITY ------ --------- --------- ---- 1003 James Baldwin Boston 2010 Cora Parker Boston 2437 Henry Thompson Boston 3411 Catherine Williams Boston 3841 Michelle Cromwell Boston 4962 Peter White Boston 6 rows processed
If your results do not match what you see above, check Review Answers for Chapter 4 for the correct SQL syntax. Remember that result tables may be shortened in this guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|