Now You Try It
Commonwealth Auto maintains information on all the skills the company requires to do business. This information is maintained in the SKILL table.
Enter a statement to access all skill information. It isn't important whether you use uppercase or lowercase in your SQL statement.
What table do you need to access?
You need to access the SKILL table.
The result looks like this:
SKILL_ID SKILL_NAME SKILL_DESC -------- ---------- ---------- 5420 Writing General writing skills 4444 Assembly Auto body assembly experience 5160 Calculus Knowledge of advanced mathematics 1000 Management Experience managing people 4420 Telephone Basic customer support 7000 Sales Background in sales techniques 4410 Typing Minimum 60 wpm 6666 Billing Basic billing procedures 3065 Electronics Electronic diagnosis and repair 5430 Mktng Writing Background in promotional writing 6470 Window Installation Installation of automotive windows 5130 Basic Math Knowledge of basic math functions 5500 Gen Mktng Knowledge of basic marketing concepts 5180 Statistics Creating & evaluating statistics 6670 Gas Engine Repair Experience in gasoline engine repair 6770 Purchasing Basic buying & negotiation procedures 4370 Filing Ability to organize correspondence/invoices 1030 Acct Mgt Experience in managing acctng activities 5309 Appraising Used car evaluation 4490 Gen Ledger Experience with general ledger 6650 Diesel Engine Repair Experience in diesel engine repair 4430 Interviewing Basic interviewing experience 3333 Bodywork Experience in repairing auto bodies 3088 Brake work Brake diagnosis and repair 5200 Gen Acctng Familiarity with basic AR and AP 4250 Data Entry Familiarity with computer keyboard 26 rows processed
If your results do not match what you see above, check “Exercise 3-1 Answer” in 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.
|
|