Try Another
The president of the company wants a Christmas card list of all employees. He wants to see the first and last names for each employee and the street and community in which they live.
Enter a SELECT statement to do this, using the EMPLOYEE table.
The result looks like this:
EMP_FNAME EMP_LNAME STREET CITY --------- --------- ------ ---- Samuel Spade 47 London St Canton Catherine Williams 566 Lincoln St Boston Janice Dexter 399 Pine St Medford Cora Parker 2 Spring St Boston Mark White 560 Camden St Canton Marylou Hamel 11 Main St Medford James Gallway 12 East Speen St Stoneham Ronald Wilder 30 Heron Ave Natick Frank Lowe 25 Rutland St Natick Mary Umidy 895A Braintree Circle Medford Cynthia Taylor 201 Washington St Concord John Brooks 129 Bedford St Camden Carl Smith 18 South St Newton Martin Loren 401 Cross St Grover Bruce MacGregor 254 Waterside Rd Camden Michael Smith 201 Summer St Brookline William Griffin 390 Sherman St Taunton Jason Thompson 3 Flintlock St Natick Stephen Wills 34 Avon Dr Canton David Alexander 18 Cross St Grover 55 rows processed
If your results do not match what you see above, check Review Answers for Chapter 3 for the correct SQL syntax. Remember that result tables may be shortened in this guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|