Database system

week2_retailstore.accdb

EMP_CODE	EMP_TITLE	EMP_LNAME	EMP_FNAME	EMP_INITIAL	EMP_DOB	JOB_CODE	STORE_CODE
1	Mr.	Williamson	John	W	5/21/64	SEC	3
2	Ms.	Ratula	Nancy		2/9/69	MGR	2
3	Ms.	Greenboro	Lottie	R	10/2/61	GEN	4
4	Mrs.	Rumpersfro	Jennie	S	6/1/71	GEN	5
5	Mr.	Smith	Robert	L	11/23/59	GEN	3
6	Mr.	Renselaer	Cary	A	12/25/65	GEN	1
7	Mr.	Ogallo	Roberto	S	7/31/62	MGR	3
8	Ms.	Johnsson	Elizabeth	I	9/10/68	SEC	1
9	Mr.	Eindsmar	Jack	W	4/19/55	SEC	2
10	Mrs.	Jones	Rose	R	3/6/66	GEN	4
11	Mr.	Broderick	Tom		10/21/72	GEN	3
12	Mr.	Washington	Alan	Y	9/8/74	GEN	2
13	Mr.	Smith	Peter	N	8/25/64	GEN	3
14	Ms.	Smith	Sherry	H	5/25/66	GEN	4
15	Mr.	Olenko	Howard	U	5/24/64	GEN	5
16	Mr.	Archialo	Barry	V	9/3/60	GEN	5
17	Ms.	Grimaldo	Jeanine	K	11/12/70	MGR	4
18	Mr.	Rosenberg	Andrew	D	1/24/71	GEN	4
19	Mr.	Rosten	Peter	F	10/3/68	GEN	4
20	Mr.	Mckee	Robert	S	3/6/70	MGR	1
21	Ms.	Baumann	Jennifer	A	12/11/74	SEC	3

REGION_CODE	REGION_DESCRIPT
1	East
2	West

STORE_CODE	STORE_NAME	STORE_YTD_SALES	REGION_CODE
1	Access Junction	1003455.76	2
2	Database Corner	1421987.39	2
3	Tuple Charge	986783.22	1
4	Attribute Alley	944568.56	2
5	Primary Key Point	2930098.45	1

SELECT EMPLOYEE.JOB_CODE, Count(EMPLOYEE.JOB_CODE) AS CountOfJOB_CODE FROM EMPLOYEE GROUP BY EMPLOYEE.JOB_CODE;