This table provides information about people who have applied
for jobs with the company. Each row represents an applicant.
The columns are as follows:
TEMPID
Temporary identification of the applicant
NAME
Last name of the applicant
ADDRESS
City and state in which the applicant lives
EDLEVEL
Education level of the applicant
COMMENTS
Notes made by the interviewer
The Q.APPLICANT table is shown in the following figure: Figure 1. The Q.APPLICANT table
TEMPID NAME ADDRESS EDLEVEL COMMENTS
------ --------- ----------------- ------- -----------------------------
400 FROMMHERZ SAN JOSE,CA 12 NO SALES EXPERIENCE
410 JACOBS POUGHKEEPSIE,NY 16 GOOD CANDIDATE FOR WASHINGTON
420 MONTEZ DALLAS,TX 13 OFFER SALES POSITION
430 RICHOWSKI TUCSON,AZ 14 CAN'T START WORK UNTIL 12/96
440 REID ENDICOTT,NY 14 1 YEAR SALES EXPERIENCE
450 JEFFREYS PHILADELPHIA,PA 12 GOOD CLERICAL BACKGROUND
460 STANLEY CHICAGO,IL 11 WANTS PARTIME JOB
470 CASALS PALO ALTO,CA 14 EXPERIENCED SALESMAN
480 LEEDS EAST FISHKILL,NY 12 NEEDS INTERVIEW WITH BROWN
490 GASPARD PARIS,TX 16 WORKED HERE FROM 1/94 TO 6/94