Emp_id Last_name First_name Emp_address Emp_city State_Code Telephone_area_code Telephone_number EEO_1_classification Hire_date Emp_salary Emp_gender Emp_age Job_id ----------- --------------- --------------- -------------------------------------------------- -------------------- ---------- ------------------- ---------------- -------------------------------------------------- ----------------------- --------------------------------------- ---------- ----------- ------ 1 Edelman Glenn 0 Sales Workers 2003-10-07 00:00:00.000 21500.00 M 64 CASHR 2 McMullen Eric 0 Sales Workers 2002-11-01 00:00:00.000 13500.00 M 20 CASHR 3 Slentz Raj 0 Assistant Manager Officials & Managers 2000-06-01 00:00:00.000 48000.00 M 34 ASTMG 4 Broun Erin 0 Sales Worker 2003-03-12 00:00:00.000 10530.00 F 24 BGGER 5 Carpenter Donald 0 Office/Clerical 2003-11-01 00:00:00.000 15000.00 M 18 OFCLR 6 Esquivez David 0 Asst. -Butchers & Seafood Specialists 2003-07-25 00:00:00.000 18500.00 M 25 RBSFP 7 Sharp Nancy 0 Asst. -Butchers & Seafood Specialists 2003-07-12 00:00:00.000 21000.00 F 24 RBSFP (7 row(s) affected) Job_id EEO-1 Classification Job_title Job_description Exempt_Status ------ -------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------------------------- ------------- ACCLK Sales Worker Accounting Clerk Accounting Clerk 0 ASTMG Officials & Managers Asst. Manager Asst. Manager 1 BGGER Sales Workers Bagger Bagger 0 CASHR Sales Workers Cashier Cashier 0 CMPSS Operatives (Semi Skilled) Computer Support Specialist Computer Support Specialist 0 DROFA Officials & Managers Director of Finance & Accounting Director of Finance & Accounting 1 OFCLR Office/Clerical Stocker Stocker 0 RBSFP Operatives (Semi Skilled) Retail Asst. Butchers and Seafood Specialists Retail Asst. Butchers and Seafood Specialists 0 RTABP Operatives (Semi Skilled) Retail Asst. Bakery & Pastry Retail Asst. Bakery & Pastry 0 (9 row(s) affected) Emp_id Last_name First_name Emp_address Emp_city State_Code Telephone_area_code Telephone_number EEO_1_classification Hire_date Emp_salary Emp_gender Emp_age Job_id Job_id EEO-1 Classification Job_title Job_description Exempt_Status ----------- --------------- --------------- -------------------------------------------------- -------------------- ---------- ------------------- ---------------- -------------------------------------------------- ----------------------- --------------------------------------- ---------- ----------- ------ ------ -------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------------------------- ------------- 1 Edelman Glenn 0 Sales Workers 2003-10-07 00:00:00.000 21500.00 M 64 CASHR BGGER Sales Workers Bagger Bagger 0 1 Edelman Glenn 0 Sales Workers 2003-10-07 00:00:00.000 21500.00 M 64 CASHR CASHR Sales Workers Cashier Cashier 0 5 Carpenter Donald 0 Office/Clerical 2003-11-01 00:00:00.000 15000.00 M 18 OFCLR OFCLR Office/Clerical Stocker Stocker 0 (3 row(s) affected) Emp_id Last_name First_name Emp_address Emp_city State_Code Telephone_area_code Telephone_number EEO_1_classification Hire_date Emp_salary Emp_gender Emp_age Job_id Job_id EEO-1 Classification Job_title Job_description Exempt_Status ----------- --------------- --------------- -------------------------------------------------- -------------------- ---------- ------------------- ---------------- -------------------------------------------------- ----------------------- --------------------------------------- ---------- ----------- ------ ------ -------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------------------------- ------------- 1 Edelman Glenn 0 Sales Workers 2003-10-07 00:00:00.000 21500.00 M 64 CASHR BGGER Sales Workers Bagger Bagger 0 1 Edelman Glenn 0 Sales Workers 2003-10-07 00:00:00.000 21500.00 M 64 CASHR CASHR Sales Workers Cashier Cashier 0 5 Carpenter Donald 0 Office/Clerical 2003-11-01 00:00:00.000 15000.00 M 18 OFCLR OFCLR Office/Clerical Stocker Stocker 0 (3 row(s) affected) Emp_id Last_name First_name Emp_address Emp_city State_Code Telephone_area_code Telephone_number EEO_1_classification Hire_date Emp_salary Emp_gender Emp_age Job_id Job_id EEO-1 Classification Job_title Job_description Exempt_Status ----------- --------------- --------------- -------------------------------------------------- -------------------- ---------- ------------------- ---------------- -------------------------------------------------- ----------------------- --------------------------------------- ---------- ----------- ------ ------ -------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------------------------- ------------- 4 Broun Erin 0 Sales Worker 2003-03-12 00:00:00.000 10530.00 F 24 BGGER ACCLK Sales Worker Accounting Clerk Accounting Clerk 0 1 Edelman Glenn 0 Sales Workers 2003-10-07 00:00:00.000 21500.00 M 64 CASHR BGGER Sales Workers Bagger Bagger 0 2 McMullen Eric 0 Sales Workers 2002-11-01 00:00:00.000 13500.00 M 20 CASHR BGGER Sales Workers Bagger Bagger 0 1 Edelman Glenn 0 Sales Workers 2003-10-07 00:00:00.000 21500.00 M 64 CASHR CASHR Sales Workers Cashier Cashier 0 2 McMullen Eric 0 Sales Workers 2002-11-01 00:00:00.000 13500.00 M 20 CASHR CASHR Sales Workers Cashier Cashier 0 5 Carpenter Donald 0 Office/Clerical 2003-11-01 00:00:00.000 15000.00 M 18 OFCLR OFCLR Office/Clerical Stocker Stocker 0 (6 row(s) affected) Emp_id Last_name First_name Emp_address Emp_city State_Code Telephone_area_code Telephone_number EEO_1_classification Hire_date Emp_salary Emp_gender Emp_age Job_id Job_id EEO-1 Classification Job_title Job_description Exempt_Status ----------- --------------- --------------- -------------------------------------------------- -------------------- ---------- ------------------- ---------------- -------------------------------------------------- ----------------------- --------------------------------------- ---------- ----------- ------ ------ -------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------------------------- ------------- 4 Broun Erin 0 Sales Worker 2003-03-12 00:00:00.000 10530.00 F 24 BGGER ACCLK Sales Worker Accounting Clerk Accounting Clerk 0 2 McMullen Eric 0 Sales Workers 2002-11-01 00:00:00.000 13500.00 M 20 CASHR BGGER Sales Workers Bagger Bagger 0 2 McMullen Eric 0 Sales Workers 2002-11-01 00:00:00.000 13500.00 M 20 CASHR CASHR Sales Workers Cashier Cashier 0 (3 row(s) affected) Last_name First_name --------------- --------------- Carpenter Donald (1 row(s) affected) AverageSalaray EEO_1_classification --------------------------------------- -------------------------------------------------- 48000.000000 Assistant Manager Officials & Managers 19750.000000 Asst. -Butchers & Seafood Specialists 15000.000000 Office/Clerical 10530.000000 Sales Worker 17500.000000 Sales Workers (5 row(s) affected) JobClassification AverageSalaray NumberOfPeople -------------------------------------------------- --------------------------------------- -------------- Office/Clerical 15000.000000 1 Sales Worker 10530.000000 1 Sales Workers 17500.000000 4 (3 row(s) affected) JobClassification Last_name -------------------------------------------------- --------------- Office/Clerical Carpenter Sales Worker Broun Sales Workers Edelman Sales Workers McMullen (4 row(s) affected) Emp_salary Last_name JobClassification --------------------------------------- --------------- -------------------------------------------------- 10530.00 Broun Sales Worker 13500.00 McMullen Sales Workers 15000.00 Carpenter Office/Clerical 21500.00 Edelman Sales Workers (4 row(s) affected) emp_salary Last_name Exempt_Status --------------------------------------- --------------- ------------- 10530.00 Broun 0 13500.00 McMullen 0 13500.00 McMullen 0 15000.00 Carpenter 0 21500.00 Edelman 0 21500.00 Edelman 0 (6 row(s) affected)