sql hw

/* Drop tables if needed by uncommenting the following statements */ drop table country; drop table city; drop table river; /* create three tables */ CREATE TABLE country (name varchar(35), cont varchar(35), pop real, gdp real, life_exp real, shape char(15), primary key (name) ); CREATE TABLE city (name varchar(35), country varchar(35), pop real, capital char(1), shape char(13), primary key (name) ); CREATE TABLE river (name varchar(35), origin varchar(35), length int, shape char(15), primary key (name) ); /* load data into three tables */ INSERT INTO country(name,cont,pop,gdp,life_exp,shape) VALUES('Canada','NAM',30.1,658.0,77.08,'Polygonid-1'); INSERT INTO country(name,cont,pop,gdp,life_exp,shape) VALUES('Mexico','NAM',107.5,694.3,69.36,'Polygonid-2'); INSERT INTO country(name,cont,pop,gdp,life_exp,shape) VALUES('Brazil','SAM',183.3,1004.0,65.60,'Polygonid-3'); INSERT INTO country(name,cont,pop,gdp,life_exp,shape) VALUES('Cuba','NAM',11.7,16.9,75.95,'Polygonid-4'); INSERT INTO country(name,cont,pop,gdp,life_exp,shape) VALUES('USA','NAM',270.0,8003.0,75.75,'Polygonid-5'); INSERT INTO country(name,cont,pop,gdp,life_exp,shape) VALUES('Argentina','SAM',36.3,348.2,70.75,'Polygonid-6'); INSERT INTO city(name,country,pop,capital,shape) VALUES('Havana','Cuba',2.1,'Y','Pointid-1'); INSERT INTO city(name,country,pop,capital,shape) VALUES('Washington D.C.','USA',3.2,'Y','Pointid-2'); INSERT INTO city(name,country,pop,capital,shape) VALUES('Monterrey','Mexico',2.0,'N','Pointid-3'); INSERT INTO city(name,country,pop,capital,shape) VALUES('Toronto','Canada',3.4,'N','Pointid-4'); INSERT INTO city(name,country,pop,capital,shape) VALUES('Brasilia','Brazil',1.5,'Y','Pointid-5'); INSERT INTO city(name,country,pop,capital,shape) VALUES('Rosario','Argentina',1.1,'N','Pointid-6'); INSERT INTO city(name,country,pop,capital,shape) VALUES('Ottawa','Canada',0.8,'Y','Pointid-7'); INSERT INTO city(name,country,pop,capital,shape) VALUES('Mexico City','Mexico',14.1,'Y','Pointid-8'); INSERT INTO city(name,country,pop,capital,shape) VALUES('Buenos Aires','Argentina',10.75,'Y','Pointid-9'); INSERT INTO river(name,origin,length,shape) VALUES('Rio Parana','Brazil',2600,'LineStringid-1'); INSERT INTO river(name,origin,length,shape) VALUES('St. Lawrence','USA',1200,'LineStringid-2'); INSERT INTO river(name,origin,length,shape) VALUES('Rio Grande','USA',3000,'LineStringid-3'); INSERT INTO river(name,origin,length,shape) VALUES('Mississippi','USA',6000,'LineStringid-4'); commit;