-
Notifications
You must be signed in to change notification settings - Fork 183
/
Base de datos a crear.txt
236 lines (223 loc) · 20.2 KB
/
Base de datos a crear.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
CREATE DATABASE Alumnos /*** Ejecutar primero esta línea y después copiar las demás lineas***/
USE Alumnos;
CREATE TABLE Datos_Personales (
Id_num INTEGER IDENTITY(1, 1),
Nombre VARCHAR(255) NOT NULL,
Correo VARCHAR(255),
Direccion VARCHAR(255),
Ciudad VARCHAR(255) NOT NULL,
Telefono VARCHAR(15),
Genero CHAR(1),
Estado_Civil VARCHAR(12),
PRIMARY KEY (Id_num)
);
INSERT INTO Datos_Personales VALUES ('Letha Bolt', '[email protected]', '2638 Riverview Pkwy', 'Wabash', '(564) 517-5025', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Vanita Kelleher', '[email protected]', NULL, 'Concord', '(684) 186-0087', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Marcos Abraham', '[email protected]', '80 White Woodfort Ln', 'Clayton', '(260) 313-6443', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Miyoko Mckinney', '[email protected]', '925 Hope St', 'Scottdale', '(868) 864-8718', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Adolph Francisco', '[email protected]', '3755 Red Burwood Way', 'Mount Horeb', '(451) 929-8321', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Oma Lawler', NULL, NULL, 'Kings Point', '(133) 683-0582', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Felix Alba', '[email protected]', '3813 Hope St', 'Hoopeston', '(765) 713-9006', 'F', 'Widow');
INSERT INTO Datos_Personales VALUES ('Eusebia Noland', '[email protected]', '1168 Lake Circle', 'Concord', '(447) 838-0332', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Denisha Mcginnis', '[email protected]', '74 Burwood Way', 'Brookings', '(730) 273-6683', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Stanford Sullivan', '[email protected]', '3836 Hunting Hill Pkwy', 'Beavercreek', '(812) 252-0427', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Nathan Salisbury', '[email protected]', '3603 Stonewood Ct', 'Dublin', '(977) 813-8110', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Burton Bunnell', '[email protected]', '3490 Quailwood Street', 'Breese', '(826) 366-1014', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Adah Jameson', '[email protected]', NULL, 'Bedford Heights', '(914) 159-1651', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Adam Geer', '[email protected]', '402 Bayview Avenue', 'Aberdeen', '(961) 069-2786', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Freeman Selby', '[email protected]', '647 Hidden Front Blvd', 'Pleasant Prairie', '(768) 048-0640', 'F', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Laura Barger', '[email protected]', '3744 Woodhurst Pkwy', 'Chickasaw', '(790) 495-8216', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Ariel Hermann', '[email protected]', '683 SW Stonewood Way', 'Brigantine', '(552) 037-7186', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Adam Maddox', '[email protected]', '2254 W Riverview Lane', 'Merrill', '(247) 811-3933', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Winnifred Brantley', '[email protected]', '1314 New Glenwood Hwy', 'Lincoln Park', '(594) 490-9628', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Gayle Baugh', '[email protected]', '781 North Hunting Hill Ln', 'Lompoc', '(438) 866-0472', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Delcie Abney', '[email protected]', '502 New Highland Highway', 'Madisonville', '(227) 049-9918', 'M', NULL);
INSERT INTO Datos_Personales VALUES ('Kasey Furr', '[email protected]', '2961 Deepwood Dr', 'Arlington', '(768) 693-9345', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Gertie Abel', '[email protected]', '1156 Town Avenue', 'North Richland Hills', '(487) 479-9336', 'F', 'Widowed');
INSERT INTO Datos_Personales VALUES ('Myles Angel', '[email protected]', '2008 Town Cir', 'Brenham', '(857) 863-6779', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Jerome Gipson', '[email protected]', NULL, 'Chehalis', NULL, 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Lilla Perez', '[email protected]', NULL, 'Big Rapids', '(104) 855-4937', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Josephine Norwood', '[email protected]', '81 Beachwood Lane', 'Lindale', '(273) 600-9445', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Elli Robertson', '[email protected]', '51 Stonewood Pkwy', 'Sheridan', '(553) 638-6830', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Curtis Hutson', '[email protected]', '725 NW Waterview Way', 'Cathedral City', '(442) 344-5339', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Melia Gates', '[email protected]', '75 Beachwood Way', 'San Angelo', '(535) 013-0514', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Marc Pickering', '[email protected]', '222 Burwood Pkwy', 'Fair Haven', '(875) 375-2382', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Alida Jobe', '[email protected]', '959 East Meadowview Drive', 'Snoqualmie', '(610) 362-5075', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Cordelia Key', '[email protected]', '2004 Mountain Dr', 'Philadelphia', '(243) 459-7372', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Reba Gregg', '[email protected]', '2008 3rd Ct', 'Valdosta', '(845) 678-6842', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Jarod Bourgeois', '[email protected]', '894 Old Rock Hill Way', 'Williams', '(384) 573-9515', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Oliva Coble', '[email protected]', '2274 E Lake Ct', 'Ringwood', '(135) 721-2385', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Corey Musgrove', '[email protected]', '1052 Deepwood Cir', 'Walnut Ridge', '(533) 039-4249', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Bud Grubbs', '[email protected]', '138 1st Drive', 'Mahtomedi', '(649) 790-3129', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Newton Graves', '[email protected]', '2747 W Hope Hwy', 'Star', '(861) 866-2316', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Tamica Goins', '[email protected]', '3082 West Quailwood Loop', 'Lewisville', '(403) 014-5022', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Bertram Herzog', '[email protected]', '609 Rose Hill Court', 'Winthrop Harbor', '(153) 734-4222', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Malcolm Coward', '[email protected]', '238 Pine Tree Dr', 'Park Ridge', NULL, 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Carley Valdez', '[email protected]', '17 Bayview Lane', 'Big Spring', '(821) 308-8608', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Lizzie Krueger', '[email protected]', '3747 Sharp Hill Dr', 'Champlin', '(864) 550-3567', 'F', NULL);
INSERT INTO Datos_Personales VALUES ('Celestine Hong', NULL, NULL, 'Beckley', '(360) 865-3659', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Shonda Leake', '[email protected]', '327 New Church St', 'Albion', '(598) 443-5163', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Hubert Waldrop', NULL, '2147 Riverview Dr', 'Aberdeen', '(995) 647-4714', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Alphonso Meeks', '[email protected]', '2621 Mountain Circle', 'Cahokia', '(447) 684-3013', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Aimee Stamm', '[email protected]', '806 Rose Hill Highway', 'Clarksville', NULL, 'M', NULL);
INSERT INTO Datos_Personales VALUES ('Sonia Ackerman', '[email protected]', '3566 Old Hope Cir', 'Canal Fulton', '(866) 682-6586', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Bertrada Zabel', '[email protected]', 'Monett', 'Middlesbrough', '(564) 517-5025', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Heiderose Blind', '[email protected]', NULL, 'Stoke-on-Trent', '(684) 186-0087', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Joko Adler', '[email protected]', 'Hanover', 'Oxford', '(260) 313-6443', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Hemma Küchenmeister', '[email protected]', 'West Bountiful', 'Liverpool', '(868) 864-8718', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Helwig Hummel', '[email protected]', 'Kiryas Joel', 'Milton Keynes', '(451) 929-8321', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Orthey Feuerbach', NULL, NULL, 'Gloucester', '(133) 683-0582', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Hannfried Blume', '[email protected]', 'Hampton', 'West Bromwich', '(765) 713-9006', 'F', 'Widow');
INSERT INTO Datos_Personales VALUES ('Xenja Bohnke', '[email protected]', 'Watauga', 'Colchester', '(447) 838-0332', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Selinda Reinrhard', '[email protected]', 'River Rouge', 'London', '(730) 273-6683', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Pontianus Unger', '[email protected]', 'Cleburne', 'Huddersfield', '(812) 252-0427', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Berengar Gering', '[email protected]', 'Valdosta', 'Walsall', '(977) 813-8110', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Clemendina Singer', '[email protected]', 'Centralia', 'Wolverhampton', '(826) 366-1014', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Adine Abicht', '[email protected]', NULL, 'Peterborough', '(914) 159-1651', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Falina Fischer', '[email protected]', 'Aberdeen', 'Sheffield', '(961) 069-2786', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Lovis Kloz', '[email protected]', 'Peekskill', 'Sunderland', '(768) 048-0640', 'F', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Amrei Menger', '[email protected]', 'Presque Isle', 'Newcastle upon Tyne', '(790) 495-8216', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Catrin Niemann', '[email protected]', 'Madera', 'Bolton', '(552) 037-7186', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Conny Dippel', '[email protected]', 'Burbank', 'Watford', '(247) 811-3933', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Armgard Gerngross', '[email protected]', 'El Monte', 'Coventry', '(594) 490-9628', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Korth Schiefer', '[email protected]', 'Sherwood', 'Slough', '(438) 866-0472', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Lenchen Zinger', '[email protected]', 'Poteau', 'Bournemouth', '(227) 049-9918', 'M', NULL);
INSERT INTO Datos_Personales VALUES ('Barthel Zenner', '[email protected]', 'Oxford', 'York', '(768) 693-9345', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Krispin Zeiger', '[email protected]', 'Troutdale', 'Luton', '(487) 479-9336', 'F', 'Widowed');
INSERT INTO Datos_Personales VALUES ('Wilbrecht Ebel', '[email protected]', 'Palm Bay', 'Sutton Coldfield', '(857) 863-6779', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Dieter Gardenberg', '[email protected]', NULL, 'Crawley', NULL, 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Rüder Geller', '[email protected]', NULL, 'Ipswich', '(104) 855-4937', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('California Zeiger', '[email protected]', 'Malone', 'Bradford', '(273) 600-9445', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Fredegar Menzel', '[email protected]', 'Kaysville', 'Southampton', '(553) 638-6830', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Lisa-Maria Geller', '[email protected]', 'Coachella', 'Manchester', '(442) 344-5339', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Aurion Stumpf', '[email protected]', 'Aberdeen', 'Plymouth', '(535) 013-0514', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Friedwart Möbius', '[email protected]', 'Slatington', 'Kingston upon Hull', '(875) 375-2382', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Cölestin Köstlin', '[email protected]', 'Satellite Beach', 'Dudley', '(610) 362-5075', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Abeline Gelen', '[email protected]', 'Amsterdam', 'Swindon', '(243) 459-7372', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Balte Feierbach', '[email protected]', 'Washington Court House', 'Northampton', '(845) 678-6842', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Chlothar Bohrmann', '[email protected]', 'Absecon', 'Derby', '(384) 573-9515', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Dietlana Kronberg', '[email protected]', 'Melrose Park', 'Poole', '(135) 721-2385', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Mirinda Schwarz', '[email protected]', 'Hazel Park', 'Leeds', '(533) 039-4249', 'M', 'Divorced');
INSERT INTO Datos_Personales VALUES ('Diepold Buchholz', '[email protected]', 'Lakeland', 'Southend-on-Sea', '(649) 790-3129', 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Janeric Pritzel', '[email protected]', 'Herndon', 'Brighton', '(861) 866-2316', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Adriane Finkelstein', '[email protected]', 'Warwick', 'Norwich', '(403) 014-5022', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Volbrecht Brandt', '[email protected]', 'Collinsville', 'Telford', '(153) 734-4222', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Haiko Zenner', '[email protected]', 'Cheboygan', 'Birmingham', NULL, 'M', 'Married');
INSERT INTO Datos_Personales VALUES ('Avenell Rüdiger', '[email protected]', 'Olympia Fields', 'Eastbourne', '(821) 308-8608', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Annalena Genkel', '[email protected]', 'Lewisville', 'Portsmouth', '(864) 550-3567', 'F', NULL);
INSERT INTO Datos_Personales VALUES ('Haita Rosenblatt', NULL, NULL, 'Bristol', '(360) 865-3659', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Yente Ulbricht', '[email protected]', 'Watauga', 'St Helens', '(598) 443-5163', 'M', 'Single');
INSERT INTO Datos_Personales VALUES ('Justus Dannenberg', NULL, 'Picayune', 'Blackburn', '(995) 647-4714', 'F', 'Married');
INSERT INTO Datos_Personales VALUES ('Ottfried Schneidermann', '[email protected]', 'Allegan', 'Leicester', '(447) 684-3013', 'F', 'Single');
INSERT INTO Datos_Personales VALUES ('Almute Ebert', '[email protected]', 'Katy', 'Reading', NULL, 'M', NULL);
INSERT INTO Datos_Personales VALUES ('Friederun Appel', '[email protected]', 'Ste. Genevieve', 'Exeter', '(866) 682-6586', 'M', 'Married');
CREATE TABLE Ciudad(
Ciudad VARCHAR(255) NOT NULL,
Pais VARCHAR(100) NOT NULL,
PRIMARY KEY (Ciudad)
);
INSERT INTO Ciudad VALUES ('Aberdeen','United Kingdom');
INSERT INTO Ciudad VALUES('Albion','United States');
INSERT INTO Ciudad VALUES('Arlington','United States');
INSERT INTO Ciudad VALUES('Beavercreek','United States');
INSERT INTO Ciudad VALUES('Beckley','United States');
INSERT INTO Ciudad VALUES('Bedford Heights','United States');
INSERT INTO Ciudad VALUES('Big Rapids','United States');
INSERT INTO Ciudad VALUES('Big Spring','United States');
INSERT INTO Ciudad VALUES('Birmingham','United Kingdom');
INSERT INTO Ciudad VALUES('Blackburn','United Kingdom');
INSERT INTO Ciudad VALUES('Bolton','United Kingdom');
INSERT INTO Ciudad VALUES('Bournemouth','United Kingdom');
INSERT INTO Ciudad VALUES('Bradford','United States');
INSERT INTO Ciudad VALUES('Breese','United States');
INSERT INTO Ciudad VALUES('Brenham','United States');
INSERT INTO Ciudad VALUES('Brigantine','United States');
INSERT INTO Ciudad VALUES('Brighton','United Kingdom');
INSERT INTO Ciudad VALUES('Bristol','United Kingdom');
INSERT INTO Ciudad VALUES('Brookings','United States');
INSERT INTO Ciudad VALUES('Cahokia','United States');
INSERT INTO Ciudad VALUES('Canal Fulton','United States');
INSERT INTO Ciudad VALUES('Cathedral City','United States');
INSERT INTO Ciudad VALUES('Champlin','United States');
INSERT INTO Ciudad VALUES('Chehalis','United States');
INSERT INTO Ciudad VALUES('Chickasaw','United States');
INSERT INTO Ciudad VALUES('Clarksville','United States');
INSERT INTO Ciudad VALUES('Clayton','United States');
INSERT INTO Ciudad VALUES('Colchester','United Kingdom');
INSERT INTO Ciudad VALUES('Concord','United States');
INSERT INTO Ciudad VALUES('Coventry','United Kingdom');
INSERT INTO Ciudad VALUES('Crawley','United States');
INSERT INTO Ciudad VALUES('Derby','United States');
INSERT INTO Ciudad VALUES('Dublin','United States');
INSERT INTO Ciudad VALUES('Dudley','United Kingdom');
INSERT INTO Ciudad VALUES('Eastbourne','United States');
INSERT INTO Ciudad VALUES('Exeter','United Kingdom');
INSERT INTO Ciudad VALUES('Fair Haven','United States');
INSERT INTO Ciudad VALUES('Gloucester','United Kingdom');
INSERT INTO Ciudad VALUES('Hoopeston','United States');
INSERT INTO Ciudad VALUES('Huddersfield','United Kingdom');
INSERT INTO Ciudad VALUES('Ipswich','United States');
INSERT INTO Ciudad VALUES('Kings Point','United Kingdom');
INSERT INTO Ciudad VALUES('Kingston upon Hull','United Kingdom');
INSERT INTO Ciudad VALUES('Leeds','United Kingdom');
INSERT INTO Ciudad VALUES('Leicester','United States');
INSERT INTO Ciudad VALUES('Lewisville','United States');
INSERT INTO Ciudad VALUES('Lincoln Park','United States');
INSERT INTO Ciudad VALUES('Lindale','United States');
INSERT INTO Ciudad VALUES('Liverpool','United Kingdom');
INSERT INTO Ciudad VALUES('Lompoc','United States');
INSERT INTO Ciudad VALUES('London','United Kingdom');
INSERT INTO Ciudad VALUES('Luton','United Kingdom');
INSERT INTO Ciudad VALUES('Madisonville','United States');
INSERT INTO Ciudad VALUES('Mahtomedi','United States');
INSERT INTO Ciudad VALUES('Manchester','United States');
INSERT INTO Ciudad VALUES('Merrill','United States');
INSERT INTO Ciudad VALUES('Middlesbrough','United Kingdom');
INSERT INTO Ciudad VALUES('Milton Keynes','United Kingdom');
INSERT INTO Ciudad VALUES('Mount Horeb','United States');
INSERT INTO Ciudad VALUES('Newcastle upon Tyne','United Kingdom');
INSERT INTO Ciudad VALUES('North Richland Hills','United States');
INSERT INTO Ciudad VALUES('Northampton','United Kingdom');
INSERT INTO Ciudad VALUES('Norwich','United Kingdom');
INSERT INTO Ciudad VALUES('Oxford','United Kingdom');
INSERT INTO Ciudad VALUES('Park Ridge','United States');
INSERT INTO Ciudad VALUES('Peterborough','United Kingdom');
INSERT INTO Ciudad VALUES('Philadelphia','United States');
INSERT INTO Ciudad VALUES('Pleasant Prairie','United States');
INSERT INTO Ciudad VALUES('Plymouth','United Kingdom');
INSERT INTO Ciudad VALUES('Poole','United Kingdom');
INSERT INTO Ciudad VALUES('Portsmouth','United States');
INSERT INTO Ciudad VALUES('Reading','United Kingdom');
INSERT INTO Ciudad VALUES('Ringwood','United States');
INSERT INTO Ciudad VALUES('San Angelo','United States');
INSERT INTO Ciudad VALUES('Scottdale','United States');
INSERT INTO Ciudad VALUES('Sheffield','United Kingdom');
INSERT INTO Ciudad VALUES('Sheridan','United States');
INSERT INTO Ciudad VALUES('Slough','United Kingdom');
INSERT INTO Ciudad VALUES('Snoqualmie','United States');
INSERT INTO Ciudad VALUES('Southampton','United Kingdom');
INSERT INTO Ciudad VALUES('Southend-on-Sea','United States');
INSERT INTO Ciudad VALUES('St Helens','United Kingdom');
INSERT INTO Ciudad VALUES('Star','United States');
INSERT INTO Ciudad VALUES('Stoke-on-Trent','United Kingdom');
INSERT INTO Ciudad VALUES('Sunderland','United States');
INSERT INTO Ciudad VALUES('Sutton Coldfield','United Kingdom');
INSERT INTO Ciudad VALUES('Swindon','United Kingdom');
INSERT INTO Ciudad VALUES('Telford','United Kingdom');
INSERT INTO Ciudad VALUES('Valdosta','United States');
INSERT INTO Ciudad VALUES('Wabash','United States');
INSERT INTO Ciudad VALUES('Walnut Ridge','United States');
INSERT INTO Ciudad VALUES('Walsall','United Kingdom');
INSERT INTO Ciudad VALUES('Watford','United Kingdom');
INSERT INTO Ciudad VALUES('West Bromwich','United Kingdom');
INSERT INTO Ciudad VALUES('Williams','United States');
INSERT INTO Ciudad VALUES('Winthrop Harbor','United States');
INSERT INTO Ciudad VALUES('Wolverhampton','United States');
INSERT INTO Ciudad VALUES('York','United Kingdom');
CREATE TABLE Region(
Pais VARCHAR(100) NOT NULL,
Region VARCHAR(100) NOT NULL,
PRIMARY KEY (Pais)
);
INSERT INTO Region VALUES('United States','America');
INSERT INTO Region VALUES('United Kingdom','Europe');