Exercise MCK

Manage Employees

id	pob	viv	cvegeo	pob_fem	pob_mas	cve_agee	nom_agee	nom_abrev
1	1425607	386671	01	728924	696683	01	Aguascalientes	Ags.
2	3769020	1149563	02	1868431	1900589	02	Baja California	BC
3	798447	240660	03	392568	405879	03	Baja California Sur	BCS
4	928363	260824	04	471424	456939	04	Campeche	Camp.
5	3146771	901249	05	1583102	1563669	05	Coahuila de Zaragoza	Coah.
6	731391	227050	06	370769	360622	06	Colima	Col.
7	5543828	1351630	07	2837881	2705947	07	Chiapas	Chis.
8	3741869	1146915	08	1888047	1853822	08	Chihuahua	Chih.
9	9209944	2757433	09	4805017	4404927	09	Ciudad de México	CDMX
10	1832650	493989	10	927784	904866	10	Durango	Dgo.
11	6166934	1587234	11	3170480	2996454	11	Guanajuato	Gto.
12	3540685	942509	12	1840073	1700612	12	Guerrero	Gro.
13	3082841	857462	13	1601462	1481379	13	Hidalgo	Hgo.
14	8348151	2332218	14	4249696	4098455	14	Jalisco	Jal.
15	16992418	4569533	15	8741123	8251295	15	México	Mex.
16	4748846	1285469	16	2442505	2306341	16	Michoacán de Ocampo	Mich.
17	1971520	560941	17	1020673	950847	17	Morelos	Mor.
18	1235456	361596	18	623178	612278	18	Nayarit	Nay.
19	5784442	1655690	19	2893492	2890950	19	Nuevo León	NL
20	4132148	1126544	20	2157305	1974843	20	Oaxaca	Oax.
21	6583278	1713865	21	3423163	3160115	21	Puebla	Pue.
22	2368467	668771	22	1211647	1156820	22	Querétaro	Qro.
23	1857985	575635	23	921206	936779	23	Quintana Roo	Q. Roo
24	2822255	775016	24	1449804	1372451	24	San Luis Potosí	SLP
25	3026943	855271	25	1532128	1494815	25	Sinaloa	Sin.
26	2944840	876826	26	1472643	1472197	26	Sonora	Son.
27	2402598	669414	27	1228927	1173671	27	Tabasco	Tab.
28	3527735	1069380	28	1791595	1736140	28	Tamaulipas	Tamps.
29	1342977	341656	29	693083	649894	29	Tlaxcala	Tlax.
30	8062579	2391262	30	4190805	3871774	30	Veracruz de Ignacio de la Llave	Ver.
31	2320898	658351	31	1180619	1140279	31	Yucatán	Yuc.
32	1622138	442835	32	831080	791058	32	Zacatecas	Zac.
33	1425607	386671	01	728924	696683	01	Aguascalientes	Ags.
34	3769020	1149563	02	1868431	1900589	02	Baja California	BC
35	798447	240660	03	392568	405879	03	Baja California Sur	BCS
36	928363	260824	04	471424	456939	04	Campeche	Camp.
37	3146771	901249	05	1583102	1563669	05	Coahuila de Zaragoza	Coah.
38	731391	227050	06	370769	360622	06	Colima	Col.
39	5543828	1351630	07	2837881	2705947	07	Chiapas	Chis.
40	3741869	1146915	08	1888047	1853822	08	Chihuahua	Chih.
41	9209944	2757433	09	4805017	4404927	09	Ciudad de México	CDMX
42	1832650	493989	10	927784	904866	10	Durango	Dgo.
43	6166934	1587234	11	3170480	2996454	11	Guanajuato	Gto.
44	3540685	942509	12	1840073	1700612	12	Guerrero	Gro.
45	3082841	857462	13	1601462	1481379	13	Hidalgo	Hgo.
46	8348151	2332218	14	4249696	4098455	14	Jalisco	Jal.
47	16992418	4569533	15	8741123	8251295	15	México	Mex.
48	4748846	1285469	16	2442505	2306341	16	Michoacán de Ocampo	Mich.
49	1971520	560941	17	1020673	950847	17	Morelos	Mor.
50	1235456	361596	18	623178	612278	18	Nayarit	Nay.
51	5784442	1655690	19	2893492	2890950	19	Nuevo León	NL
52	4132148	1126544	20	2157305	1974843	20	Oaxaca	Oax.
53	6583278	1713865	21	3423163	3160115	21	Puebla	Pue.
54	2368467	668771	22	1211647	1156820	22	Querétaro	Qro.
55	1857985	575635	23	921206	936779	23	Quintana Roo	Q. Roo
56	2822255	775016	24	1449804	1372451	24	San Luis Potosí	SLP
57	3026943	855271	25	1532128	1494815	25	Sinaloa	Sin.
58	2944840	876826	26	1472643	1472197	26	Sonora	Son.
59	2402598	669414	27	1228927	1173671	27	Tabasco	Tab.
60	3527735	1069380	28	1791595	1736140	28	Tamaulipas	Tamps.
61	1342977	341656	29	693083	649894	29	Tlaxcala	Tlax.
62	8062579	2391262	30	4190805	3871774	30	Veracruz de Ignacio de la Llave	Ver.
63	2320898	658351	31	1180619	1140279	31	Yucatán	Yuc.
64	1622138	442835	32	831080	791058	32	Zacatecas	Zac.
65	1425607	386671	01	728924	696683	01	Aguascalientes	Ags.
66	3769020	1149563	02	1868431	1900589	02	Baja California	BC
67	798447	240660	03	392568	405879	03	Baja California Sur	BCS
68	928363	260824	04	471424	456939	04	Campeche	Camp.
69	3146771	901249	05	1583102	1563669	05	Coahuila de Zaragoza	Coah.
70	731391	227050	06	370769	360622	06	Colima	Col.
71	5543828	1351630	07	2837881	2705947	07	Chiapas	Chis.
72	3741869	1146915	08	1888047	1853822	08	Chihuahua	Chih.
73	9209944	2757433	09	4805017	4404927	09	Ciudad de México	CDMX
74	1832650	493989	10	927784	904866	10	Durango	Dgo.
75	6166934	1587234	11	3170480	2996454	11	Guanajuato	Gto.
76	3540685	942509	12	1840073	1700612	12	Guerrero	Gro.
77	3082841	857462	13	1601462	1481379	13	Hidalgo	Hgo.
78	8348151	2332218	14	4249696	4098455	14	Jalisco	Jal.
79	16992418	4569533	15	8741123	8251295	15	México	Mex.
80	4748846	1285469	16	2442505	2306341	16	Michoacán de Ocampo	Mich.
81	1971520	560941	17	1020673	950847	17	Morelos	Mor.
82	1235456	361596	18	623178	612278	18	Nayarit	Nay.
83	5784442	1655690	19	2893492	2890950	19	Nuevo León	NL
84	4132148	1126544	20	2157305	1974843	20	Oaxaca	Oax.
85	6583278	1713865	21	3423163	3160115	21	Puebla	Pue.
86	2368467	668771	22	1211647	1156820	22	Querétaro	Qro.
87	1857985	575635	23	921206	936779	23	Quintana Roo	Q. Roo
88	2822255	775016	24	1449804	1372451	24	San Luis Potosí	SLP
89	3026943	855271	25	1532128	1494815	25	Sinaloa	Sin.
90	2944840	876826	26	1472643	1472197	26	Sonora	Son.
91	2402598	669414	27	1228927	1173671	27	Tabasco	Tab.
92	3527735	1069380	28	1791595	1736140	28	Tamaulipas	Tamps.
93	1342977	341656	29	693083	649894	29	Tlaxcala	Tlax.
94	8062579	2391262	30	4190805	3871774	30	Veracruz de Ignacio de la Llave	Ver.
95	2320898	658351	31	1180619	1140279	31	Yucatán	Yuc.
96	1622138	442835	32	831080	791058	32	Zacatecas	Zac.
97	1425607	386671	01	728924	696683	01	Aguascalientes	Ags.
98	3769020	1149563	02	1868431	1900589	02	Baja California	BC
99	798447	240660	03	392568	405879	03	Baja California Sur	BCS
100	928363	260824	04	471424	456939	04	Campeche	Camp.
101	3146771	901249	05	1583102	1563669	05	Coahuila de Zaragoza	Coah.
102	731391	227050	06	370769	360622	06	Colima	Col.
103	5543828	1351630	07	2837881	2705947	07	Chiapas	Chis.
104	3741869	1146915	08	1888047	1853822	08	Chihuahua	Chih.
105	9209944	2757433	09	4805017	4404927	09	Ciudad de México	CDMX
106	1832650	493989	10	927784	904866	10	Durango	Dgo.
107	6166934	1587234	11	3170480	2996454	11	Guanajuato	Gto.
108	3540685	942509	12	1840073	1700612	12	Guerrero	Gro.
109	3082841	857462	13	1601462	1481379	13	Hidalgo	Hgo.
110	8348151	2332218	14	4249696	4098455	14	Jalisco	Jal.
111	16992418	4569533	15	8741123	8251295	15	México	Mex.
112	4748846	1285469	16	2442505	2306341	16	Michoacán de Ocampo	Mich.
113	1971520	560941	17	1020673	950847	17	Morelos	Mor.
114	1235456	361596	18	623178	612278	18	Nayarit	Nay.
115	5784442	1655690	19	2893492	2890950	19	Nuevo León	NL
116	4132148	1126544	20	2157305	1974843	20	Oaxaca	Oax.
117	6583278	1713865	21	3423163	3160115	21	Puebla	Pue.
118	2368467	668771	22	1211647	1156820	22	Querétaro	Qro.
119	1857985	575635	23	921206	936779	23	Quintana Roo	Q. Roo
120	2822255	775016	24	1449804	1372451	24	San Luis Potosí	SLP
121	3026943	855271	25	1532128	1494815	25	Sinaloa	Sin.
122	2944840	876826	26	1472643	1472197	26	Sonora	Son.
123	2402598	669414	27	1228927	1173671	27	Tabasco	Tab.
124	3527735	1069380	28	1791595	1736140	28	Tamaulipas	Tamps.
125	1342977	341656	29	693083	649894	29	Tlaxcala	Tlax.
126	8062579	2391262	30	4190805	3871774	30	Veracruz de Ignacio de la Llave	Ver.
127	2320898	658351	31	1180619	1140279	31	Yucatán	Yuc.
128	1622138	442835	32	831080	791058	32	Zacatecas	Zac.
129	1425607	386671	01	728924	696683	01	Aguascalientes	Ags.
130	3769020	1149563	02	1868431	1900589	02	Baja California	BC
131	798447	240660	03	392568	405879	03	Baja California Sur	BCS
132	928363	260824	04	471424	456939	04	Campeche	Camp.
133	3146771	901249	05	1583102	1563669	05	Coahuila de Zaragoza	Coah.
134	731391	227050	06	370769	360622	06	Colima	Col.
135	5543828	1351630	07	2837881	2705947	07	Chiapas	Chis.
136	3741869	1146915	08	1888047	1853822	08	Chihuahua	Chih.
137	9209944	2757433	09	4805017	4404927	09	Ciudad de México	CDMX
138	1832650	493989	10	927784	904866	10	Durango	Dgo.
139	6166934	1587234	11	3170480	2996454	11	Guanajuato	Gto.
140	3540685	942509	12	1840073	1700612	12	Guerrero	Gro.
141	3082841	857462	13	1601462	1481379	13	Hidalgo	Hgo.
142	8348151	2332218	14	4249696	4098455	14	Jalisco	Jal.
143	16992418	4569533	15	8741123	8251295	15	México	Mex.
144	4748846	1285469	16	2442505	2306341	16	Michoacán de Ocampo	Mich.
145	1971520	560941	17	1020673	950847	17	Morelos	Mor.
146	1235456	361596	18	623178	612278	18	Nayarit	Nay.
147	5784442	1655690	19	2893492	2890950	19	Nuevo León	NL
148	4132148	1126544	20	2157305	1974843	20	Oaxaca	Oax.
149	6583278	1713865	21	3423163	3160115	21	Puebla	Pue.
150	2368467	668771	22	1211647	1156820	22	Querétaro	Qro.
151	1857985	575635	23	921206	936779	23	Quintana Roo	Q. Roo
152	2822255	775016	24	1449804	1372451	24	San Luis Potosí	SLP
153	3026943	855271	25	1532128	1494815	25	Sinaloa	Sin.
154	2944840	876826	26	1472643	1472197	26	Sonora	Son.
155	2402598	669414	27	1228927	1173671	27	Tabasco	Tab.
156	3527735	1069380	28	1791595	1736140	28	Tamaulipas	Tamps.
157	1342977	341656	29	693083	649894	29	Tlaxcala	Tlax.
158	8062579	2391262	30	4190805	3871774	30	Veracruz de Ignacio de la Llave	Ver.
159	2320898	658351	31	1180619	1140279	31	Yucatán	Yuc.
160	1622138	442835	32	831080	791058	32	Zacatecas	Zac.
161	1425607	386671	01	728924	696683	01	Aguascalientes	Ags.
162	3769020	1149563	02	1868431	1900589	02	Baja California	BC
163	798447	240660	03	392568	405879	03	Baja California Sur	BCS
164	928363	260824	04	471424	456939	04	Campeche	Camp.
165	3146771	901249	05	1583102	1563669	05	Coahuila de Zaragoza	Coah.
166	731391	227050	06	370769	360622	06	Colima	Col.
167	5543828	1351630	07	2837881	2705947	07	Chiapas	Chis.
168	3741869	1146915	08	1888047	1853822	08	Chihuahua	Chih.
169	9209944	2757433	09	4805017	4404927	09	Ciudad de México	CDMX
170	1832650	493989	10	927784	904866	10	Durango	Dgo.
171	6166934	1587234	11	3170480	2996454	11	Guanajuato	Gto.
172	3540685	942509	12	1840073	1700612	12	Guerrero	Gro.
173	3082841	857462	13	1601462	1481379	13	Hidalgo	Hgo.
174	8348151	2332218	14	4249696	4098455	14	Jalisco	Jal.
175	16992418	4569533	15	8741123	8251295	15	México	Mex.
176	4748846	1285469	16	2442505	2306341	16	Michoacán de Ocampo	Mich.
177	1971520	560941	17	1020673	950847	17	Morelos	Mor.
178	1235456	361596	18	623178	612278	18	Nayarit	Nay.
179	5784442	1655690	19	2893492	2890950	19	Nuevo León	NL
180	4132148	1126544	20	2157305	1974843	20	Oaxaca	Oax.
181	6583278	1713865	21	3423163	3160115	21	Puebla	Pue.
182	2368467	668771	22	1211647	1156820	22	Querétaro	Qro.
183	1857985	575635	23	921206	936779	23	Quintana Roo	Q. Roo
184	2822255	775016	24	1449804	1372451	24	San Luis Potosí	SLP
185	3026943	855271	25	1532128	1494815	25	Sinaloa	Sin.
186	2944840	876826	26	1472643	1472197	26	Sonora	Son.
187	2402598	669414	27	1228927	1173671	27	Tabasco	Tab.
188	3527735	1069380	28	1791595	1736140	28	Tamaulipas	Tamps.
189	1342977	341656	29	693083	649894	29	Tlaxcala	Tlax.
190	8062579	2391262	30	4190805	3871774	30	Veracruz de Ignacio de la Llave	Ver.
191	2320898	658351	31	1180619	1140279	31	Yucatán	Yuc.
192	1622138	442835	32	831080	791058	32	Zacatecas	Zac.
193	1425607	386671	01	728924	696683	01	Aguascalientes	Ags.
194	3769020	1149563	02	1868431	1900589	02	Baja California	BC
195	798447	240660	03	392568	405879	03	Baja California Sur	BCS
196	928363	260824	04	471424	456939	04	Campeche	Camp.
197	3146771	901249	05	1583102	1563669	05	Coahuila de Zaragoza	Coah.
198	731391	227050	06	370769	360622	06	Colima	Col.
199	5543828	1351630	07	2837881	2705947	07	Chiapas	Chis.
200	3741869	1146915	08	1888047	1853822	08	Chihuahua	Chih.
201	9209944	2757433	09	4805017	4404927	09	Ciudad de México	CDMX
202	1832650	493989	10	927784	904866	10	Durango	Dgo.
203	6166934	1587234	11	3170480	2996454	11	Guanajuato	Gto.
204	3540685	942509	12	1840073	1700612	12	Guerrero	Gro.
205	3082841	857462	13	1601462	1481379	13	Hidalgo	Hgo.
206	8348151	2332218	14	4249696	4098455	14	Jalisco	Jal.
207	16992418	4569533	15	8741123	8251295	15	México	Mex.
208	4748846	1285469	16	2442505	2306341	16	Michoacán de Ocampo	Mich.
209	1971520	560941	17	1020673	950847	17	Morelos	Mor.
210	1235456	361596	18	623178	612278	18	Nayarit	Nay.
211	5784442	1655690	19	2893492	2890950	19	Nuevo León	NL
212	4132148	1126544	20	2157305	1974843	20	Oaxaca	Oax.
213	6583278	1713865	21	3423163	3160115	21	Puebla	Pue.
214	2368467	668771	22	1211647	1156820	22	Querétaro	Qro.
215	1857985	575635	23	921206	936779	23	Quintana Roo	Q. Roo
216	2822255	775016	24	1449804	1372451	24	San Luis Potosí	SLP
217	3026943	855271	25	1532128	1494815	25	Sinaloa	Sin.
218	2944840	876826	26	1472643	1472197	26	Sonora	Son.
219	2402598	669414	27	1228927	1173671	27	Tabasco	Tab.
220	3527735	1069380	28	1791595	1736140	28	Tamaulipas	Tamps.
221	1342977	341656	29	693083	649894	29	Tlaxcala	Tlax.
222	8062579	2391262	30	4190805	3871774	30	Veracruz de Ignacio de la Llave	Ver.
223	2320898	658351	31	1180619	1140279	31	Yucatán	Yuc.
224	1622138	442835	32	831080	791058	32	Zacatecas	Zac.