API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 24th, 2019
128
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.73 KB | None | 0 0
raw download clone embed print report
  1. Leaked AUSTRALIA BASE Included CIA AGENT NGUYEN RICARD !
  2. Cybernatic Spy By : Vinz'joe
  3. ---------------------
  4. im nub |
  5. ---------------------
  6. --
  7. -- The SQL for the CIA World Fact Book Database
  8. -- Database Design by Richard Nguyen, Spring 2006
  9. --
  10. -- Only data for a small number of has been entered
  11. --
  12.  
  13. DROP table CIA_Language CASCADE;
  14. DROP table CIA_Religion CASCADE;
  15. DROP table CIA_Ethnic CASCADE;
  16. DROP table CIA_Neighbour CASCADE;
  17. DROP table CountryOcean CASCADE;
  18. DROP table CIA_Country CASCADE;
  19. DROP table CIA_Ocean CASCADE;
  20.  
  21.  
  22.  
  23. --
  24. -- Table creation
  25. --
  26.  
  27.  
  28.  
  29. Create table CIA_Country
  30. (
  31. Country TEXT, -- Name of the Country
  32. Location TEXT, -- Geographic location
  33. Land DOUBLE PRECISION, -- Land area, in square kilometers
  34. HighestName TEXT, -- Name of the highest point. null if no name.
  35. Highest INTEGER, -- Highest point in metres
  36. LowestName TEXT, -- Name of the lowest point. null if no name.
  37. Lowest INTEGER, -- Lowest point in metres. <0 below sea level
  38. Arable DOUBLE PRECISION, -- Arable land, as a percentage of land area
  39. Population NUMERIC, -- The total population of the nation
  40. SexRatio DOUBLE PRECISION, -- Ratio of males to females
  41. Age14 DOUBLE PRECISION, -- Percent of population 14 years or younger
  42. Age65 DOUBLE PRECISION, -- Percent of population 65 years or older
  43. PopGrowth DOUBLE PRECISION, -- Population growth rate, as percentage
  44. Migration DOUBLE PRECISION, -- Migration rate, per thousand people
  45. InfantMort DOUBLE PRECISION, -- Infant mortality, per thousand live births
  46. LifeExpectM DOUBLE PRECISION, -- Male life expectancy at birth, in years
  47. LifeExpectF DOUBLE PRECISION, -- Female life expectancy at birth, in years
  48. HIV DOUBLE PRECISION, -- Adult prevalence rate, as a percentage
  49. Literacy DOUBLE PRECISION, -- As a percentage of total population
  50. Government TEXT, -- Type of government
  51. Capital TEXT, -- Capital city; legislative if multiple
  52. Independence INTEGER, -- Year gained independence; negative if BC
  53. Chief TEXT, -- Chief of State
  54. GDP DOUBLE PRECISION, -- (purchasing power parity) in $USbillons
  55. Growth DOUBLE PRECISION, -- GDP . real growth rate, as a percentage
  56. OilProd DOUBLE PRECISION, -- bbl/day
  57. OilConsum DOUBLE PRECISION, -- bbl/day
  58. OilExport DOUBLE PRECISION, -- bbl/day
  59. CurrAccount DOUBLE PRECISION, -- Current account balance; $USbillions/year
  60. Mobiles DOUBLE PRECISION, -- Number of mobile phones, in millions
  61. Internet NUMERIC, -- The number of Internet users
  62. Paved INTEGER, -- Amount of paved road, in kilometers
  63. Unpaved INTEGER, -- Amount of unpaved road, in kilometers
  64. Military DOUBLE PRECISION, -- Military expenditure in billions of dollars
  65.  
  66. CONSTRAINT CIA_CountryPK PRIMARY KEY (Country),
  67.  
  68. CONSTRAINT CIA_Country_Land CHECK (Land > 0),
  69.  
  70. CONSTRAINT CIA_Country_Height CHECK (Highest > Lowest),
  71.  
  72. CONSTRAINT CIA_Country_Arable CHECK ((Arable >= 0) AND (Arable <= 100)),
  73.  
  74. CONSTRAINT CIA_Country_Population CHECK (Population > 0),
  75.  
  76. CONSTRAINT CIA_Country_Age14 CHECK ((Age14 >= 0) AND (Age14 <= 100)),
  77.  
  78. CONSTRAINT CIA_Country_Age65 CHECK ((Age65 >= 0) AND (Age65 <= 100)),
  79.  
  80. CONSTRAINT CIA_Country_PopGrowth CHECK ((PopGrowth >= -100) AND
  81. (PopGrowth <= 100)),
  82.  
  83. CONSTRAINT CIA_Country_Migration CHECK ((Migration >= -1000) AND
  84. (Migration <= 1000)),
  85.  
  86. CONSTRAINT CIA_Country_InfantMort CHECK ((InfantMort >= 0) AND
  87. (InfantMort <= 1000)),
  88.  
  89. CONSTRAINT CIA_Country_LifeExpectM CHECK ((LifeExpectM > 0) AND
  90. (LifeExpectM < 100)),
  91.  
  92. CONSTRAINT CIA_Country_LifeExpectF CHECK ((LifeExpectF > 0) AND
  93. (LifeExpectF < 100)),
  94.  
  95. CONSTRAINT CIA_Country_HIV CHECK ((HIV >= 0) AND (HIV <= 100)),
  96.  
  97. CONSTRAINT CIA_Country_Literacy CHECK ((Literacy >= 0) AND
  98. (Literacy <= 100)),
  99.  
  100. CONSTRAINT CIA_Country_Independence CHECK (Independence < 2007),
  101.  
  102. CONSTRAINT CIA_Country_OilProd CHECK (OilProd >= 0),
  103.  
  104. CONSTRAINT CIA_Country_OilConsum CHECK (OilConsum >= 0),
  105.  
  106. CONSTRAINT CIA_Country_OilExport CHECK (OilExport >= 0),
  107.  
  108. CONSTRAINT CIA_Country_Mobiles CHECK (Mobiles >= 0),
  109.  
  110. CONSTRAINT CIA_Country_Internet CHECK (Internet >= 0),
  111.  
  112. CONSTRAINT CIA_Country_Paved CHECK (Paved >= 0),
  113.  
  114. CONSTRAINT CIA_Country_Unpaved CHECK (Unpaved >= 0),
  115.  
  116. CONSTRAINT CIA_Country_Military CHECK (Military >= 0)
  117. );
  118.  
  119.  
  120. Create table CIA_Ocean
  121. (
  122. Ocean TEXT, -- Name of the ocean
  123. Area NUMERIC, -- in millions of square kilometers
  124. DeepestName TEXT, -- Name of the deepest point. null if no name.
  125. Deepest INTEGER, -- Deepest point in metres
  126.  
  127. CONSTRAINT CIA_OceanPK PRIMARY KEY (Ocean)
  128. );
  129.  
  130.  
  131. Create table CountryOcean
  132. (
  133. Country TEXT, -- Name of the country
  134. Ocean TEXT, -- Name of the ocean
  135.  
  136. CONSTRAINT CountryOceanPK PRIMARY KEY (Country,Ocean),
  137.  
  138. CONSTRAINT CountryOceanFK_Invalid_Country FOREIGN KEY (Country)
  139. REFERENCES CIA_Country
  140. ON DELETE CASCADE
  141. ON UPDATE CASCADE,
  142.  
  143. CONSTRAINT CountryOceanFK_Invalid_Ocean FOREIGN KEY (Ocean)
  144. REFERENCES CIA_Ocean
  145. ON DELETE CASCADE
  146. ON UPDATE CASCADE
  147. );
  148.  
  149.  
  150. Create table CIA_Neighbour
  151. (
  152. CountryA TEXT, -- Name of one neighbour country
  153. CountryB TEXT, -- Name of the other neighbour country
  154. Length DOUBLE PRECISION, -- Length of the border between neighbours
  155.  
  156. CONSTRAINT CIA_NeighbourPK PRIMARY KEY (CountryA,CountryB),
  157.  
  158. CONSTRAINT CIA_NeighbourFK_Invalid_CountryA FOREIGN KEY (CountryA)
  159. REFERENCES CIA_Country (Country)
  160. ON DELETE CASCADE
  161. ON UPDATE CASCADE,
  162.  
  163. CONSTRAINT CIA_NeighbourFK_Invalid_CountryB FOREIGN KEY (CountryB)
  164. REFERENCES CIA_Country (Country)
  165. ON DELETE CASCADE
  166. ON UPDATE CASCADE,
  167.  
  168. CONSTRAINT CIA_Neighbour_Same_Country CHECK (CountryA <> CountryB),
  169.  
  170. CONSTRAINT CIA_Neighbour_Alphabetical CHECK (CountryA < CountryB),
  171.  
  172. CONSTRAINT CIA_Neighbour_Length CHECK (Length > 0)
  173. );
  174.  
  175.  
  176. Create table CIA_Language
  177. (
  178. Country TEXT,
  179. Language TEXT,
  180. Percentage DOUBLE PRECISION,
  181.  
  182. CONSTRAINT CIA_LanguagePK PRIMARY KEY (Country,Language),
  183.  
  184. CONSTRAINT CIA_LanguageFK FOREIGN KEY (Country) REFERENCES CIA_Country
  185. ON DELETE CASCADE
  186. ON UPDATE CASCADE,
  187.  
  188. CONSTRAINT CIA_Language_Percentage CHECK
  189. (((Percentage > 0) AND (Percentage <= 100)) OR (Percentage IS NULL))
  190. );
  191.  
  192.  
  193. Create table CIA_Religion
  194. (
  195. Country TEXT,
  196. Religion TEXT,
  197. Percentage DOUBLE PRECISION,
  198.  
  199. CONSTRAINT CIA_ReligionPK PRIMARY KEY (Country,Religion),
  200.  
  201. CONSTRAINT CIA_ReligionFK FOREIGN KEY (Country) REFERENCES CIA_Country
  202. ON DELETE CASCADE
  203. ON UPDATE CASCADE,
  204.  
  205. CONSTRAINT CIA_Religion_Percentage CHECK
  206. (((Percentage > 0) AND (Percentage <= 100)) OR (Percentage IS NULL))
  207. );
  208.  
  209.  
  210. Create table CIA_Ethnic
  211. (
  212. Country TEXT,
  213. Ethnic TEXT,
  214. Percentage DOUBLE PRECISION,
  215.  
  216. CONSTRAINT CIA_EthnicPK PRIMARY KEY (Country,Ethnic),
  217.  
  218. CONSTRAINT CIA_EthnicFK FOREIGN KEY (Country) REFERENCES CIA_Country
  219. ON DELETE CASCADE
  220. ON UPDATE CASCADE,
  221.  
  222. CONSTRAINT CIA_Ethnic_Percentage CHECK
  223. (((Percentage > 0) AND (Percentage <= 100)) OR (Percentage IS NULL))
  224. );
  225.  
  226.  
  227.  
  228. --
  229. -- CIA_Country insertion
  230. --
  231.  
  232.  
  233.  
  234. INSERT INTO CIA_Country VALUES ('Bolivia','Central South America',1084390,'Nevado Sajama',6542,'Rio Paraguay',90,2.78,8989046,0.98,35,4.6,1.45,-1.22,51.77,63.21,68.61,0.1,87.2,'Republic','La Paz',1825,'Morales',25.95,4,42000,48000,null,462,0.18,350000,4314,56448,0.13);
  235.  
  236. INSERT INTO CIA_Country VALUES ('India','Southern Asia',2973190,'Kanchenjunga',8598,'Indian Ocean',0,48.83,1095351995,1.06,30.8,4.9,1.38,-0.07,54.63,63.9,65.57,0.9,59.5,'Federal Republic','New Delhi',1947,'Kalam',3611,7.6,785000,2320000,350000,-12.95,69.19,50600000,2411001,1440439,19.04);
  237.  
  238. INSERT INTO CIA_Country VALUES ('Palau','Oceania',458,'Mount Ngerchelchuus',242,'Pacific Ocean',0,8.7,20579,1.13,26.3,4.6,1.31,1.85,14.46,67.26,73.77,null,92,'Constitutional','Koror',1994,'Remengesau',0.174,1,null,null,null,null,0.001,null,36,25,null);
  239.  
  240. INSERT INTO CIA_Country VALUES ('Vatican City','Southern Europe',0.44,'null',75,null,19,0,932,null,null,null,0.01,null,null,null,null,null,100,'Ecclesiastical','Vatican City',1929,'Benedict',null,null,null,null,null,null,null,null,null,null,null);
  241.  
  242. INSERT INTO CIA_Country VALUES ('Argentina',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  243.  
  244. INSERT INTO CIA_Country VALUES ('Brazil',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  245.  
  246. INSERT INTO CIA_Country VALUES ('Chile',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  247.  
  248. INSERT INTO CIA_Country VALUES ('Paraguay',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  249.  
  250. INSERT INTO CIA_Country VALUES ('Peru',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  251.  
  252. INSERT INTO CIA_Country VALUES ('Bangladesh',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  253.  
  254. INSERT INTO CIA_Country VALUES ('Bhutan',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  255.  
  256. INSERT INTO CIA_Country VALUES ('Burma',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  257.  
  258. INSERT INTO CIA_Country VALUES ('China',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  259.  
  260. INSERT INTO CIA_Country VALUES ('Nepal',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  261.  
  262. INSERT INTO CIA_Country VALUES ('Pakistan',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  263.  
  264. INSERT INTO CIA_Country VALUES ('Italy',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
  265.  
  266.  
  267.  
  268. --
  269. -- CIA_Ocean insertion
  270. --
  271.  
  272.  
  273.  
  274. INSERT INTO CIA_Ocean VALUES
  275. (
  276. 'Pacific', -- Ocean
  277. 179.7, -- Area in millions of square kilometers
  278. 'Mariana Trench', -- DeepestName
  279. 10911 -- Deepest point in metres
  280. );
  281.  
  282. INSERT INTO CIA_Ocean VALUES
  283. (
  284. 'Atlantic', -- Ocean
  285. 106.4, -- Area in millions of square kilometers
  286. 'Puerto Rico Trench', -- DeepestName
  287. 8605 -- Deepest point in metres
  288. );
  289.  
  290. INSERT INTO CIA_Ocean VALUES
  291. (
  292. 'Indian', -- Ocean
  293. 73.556, -- Area in millions of square kilometers
  294. 'Java Trench', -- DeepestName
  295. 7450 -- Deepest point in metres
  296. );
  297.  
  298. INSERT INTO CIA_Ocean VALUES
  299. (
  300. 'Southern', -- Ocean
  301. 20.327, -- Area in millions of square kilometers
  302. 'South Sandwich Trench', -- DeepestName
  303. 7235 -- Deepest point in metres
  304. );
  305.  
  306. INSERT INTO CIA_Ocean VALUES
  307. (
  308. 'Arctic', -- Ocean
  309. 14.056, -- Area in millions of square kilometers
  310. 'Eurasian Basin', -- DeepestName
  311. 5450 -- Deepest point in metres
  312. );
  313.  
  314.  
  315.  
  316. --
  317. -- CountryOcean insertion
  318. --
  319.  
  320.  
  321.  
  322. INSERT INTO CountryOcean VALUES ('India','Indian');
  323. INSERT INTO CountryOcean VALUES ('Palau','Pacific');
  324.  
  325.  
  326.  
  327. --
  328. -- CIA_Neighbour insertion
  329. --
  330.  
  331.  
  332.  
  333. INSERT INTO CIA_Neighbour VALUES ('Argentina','Bolivia',832);
  334. INSERT INTO CIA_Neighbour VALUES ('Bolivia','Brazil',3400);
  335. INSERT INTO CIA_Neighbour VALUES ('Bolivia','Chile',861);
  336. INSERT INTO CIA_Neighbour VALUES ('Bolivia','Paraguay',750);
  337. INSERT INTO CIA_Neighbour VALUES ('Bolivia','Peru',900);
  338. INSERT INTO CIA_Neighbour VALUES ('Bangladesh','India',4053);
  339. INSERT INTO CIA_Neighbour VALUES ('Bhutan','India',605);
  340. INSERT INTO CIA_Neighbour VALUES ('Burma','India',1463);
  341. INSERT INTO CIA_Neighbour VALUES ('China','India',3380);
  342. INSERT INTO CIA_Neighbour VALUES ('India','Nepal',1690);
  343. INSERT INTO CIA_Neighbour VALUES ('India','Pakistan',2912);
  344. INSERT INTO CIA_Neighbour VALUES ('Italy','Vatican City',3.2);
  345.  
  346.  
  347.  
  348. --
  349. -- CIA_Language insertion
  350. --
  351.  
  352.  
  353.  
  354. INSERT INTO CIA_Language VALUES ('Bolivia','Spanish',null);
  355. INSERT INTO CIA_Language VALUES ('Bolivia','Quechua',null);
  356. INSERT INTO CIA_Language VALUES ('Bolivia','Aymara',null);
  357. INSERT INTO CIA_Language VALUES ('India','Indo-Aryan',74);
  358. INSERT INTO CIA_Language VALUES ('India','Dravidian',24);
  359. INSERT INTO CIA_Language VALUES ('India','other',2);
  360. INSERT INTO CIA_Language VALUES ('Palau','Palauan',64.7);
  361. INSERT INTO CIA_Language VALUES ('Palau','Filipino',13.5);
  362. INSERT INTO CIA_Language VALUES ('Palau','English',9.4);
  363. INSERT INTO CIA_Language VALUES ('Palau','Chinese',5.7);
  364. INSERT INTO CIA_Language VALUES ('Palau','Carolinian',1.5);
  365. INSERT INTO CIA_Language VALUES ('Palau','Japanese',1.5);
  366. INSERT INTO CIA_Language VALUES ('Palau','other',2.3);
  367. INSERT INTO CIA_Language VALUES ('Vatican City','Italian',null);
  368. INSERT INTO CIA_Language VALUES ('Vatican City','Latin',null);
  369. INSERT INTO CIA_Language VALUES ('Vatican City','French',null);
  370.  
  371.  
  372.  
  373. --
  374. -- CIA_Religion insertion
  375. --
  376.  
  377.  
  378.  
  379. INSERT INTO CIA_Religion VALUES ('Bolivia','Roman Catholic',95);
  380. INSERT INTO CIA_Religion VALUES ('Bolivia','Protestant',5);
  381. INSERT INTO CIA_Religion VALUES ('India','Hindu',80.5);
  382. INSERT INTO CIA_Religion VALUES ('India','Muslim',13.4);
  383. INSERT INTO CIA_Religion VALUES ('India','Christian',2.3);
  384. INSERT INTO CIA_Religion VALUES ('India','Sikh',1.9);
  385. INSERT INTO CIA_Religion VALUES ('India','other',1.8);
  386. INSERT INTO CIA_Religion VALUES ('India','unspecified',0.1);
  387. INSERT INTO CIA_Religion VALUES ('Palau','Roman Catholic',41.6);
  388. INSERT INTO CIA_Religion VALUES ('Palau','Protestant',23.3);
  389. INSERT INTO CIA_Religion VALUES ('Palau','Modekngei',8.8);
  390. INSERT INTO CIA_Religion VALUES ('Palau','Seventh-Day Adventist',5.3);
  391. INSERT INTO CIA_Religion VALUES ('Palau','Jehovah"s Witness',0.9);
  392. INSERT INTO CIA_Religion VALUES ('Palau','Latter-Day Saints',0.6);
  393. INSERT INTO CIA_Religion VALUES ('Palau','other',3.1);
  394. INSERT INTO CIA_Religion VALUES ('Palau','unspecified',16.4);
  395. INSERT INTO CIA_Religion VALUES ('Vatican City','Roman Catholic',100);
  396.  
  397.  
  398.  
  399. --
  400. -- CIA_Ethnic insertion
  401. --
  402.  
  403.  
  404.  
  405. INSERT INTO CIA_Ethnic VALUES ('Bolivia','Quecha',30);
  406. INSERT INTO CIA_Ethnic VALUES ('Bolivia','mestizo',30);
  407. INSERT INTO CIA_Ethnic VALUES ('Bolivia','Aymara',25);
  408. INSERT INTO CIA_Ethnic VALUES ('Bolivia','white',15);
  409. INSERT INTO CIA_Ethnic VALUES ('India','Indo-Aryan',72);
  410. INSERT INTO CIA_Ethnic VALUES ('India','Dravidian',25);
  411. INSERT INTO CIA_Ethnic VALUES ('India','other',3);
  412. INSERT INTO CIA_Ethnic VALUES ('Palau','Palauan',69.9);
  413. INSERT INTO CIA_Ethnic VALUES ('Palau','Filipino',15.3);
  414. INSERT INTO CIA_Ethnic VALUES ('Palau','Chinese',4.9);
  415. INSERT INTO CIA_Ethnic VALUES ('Palau','other Asian',2.4);
  416. INSERT INTO CIA_Ethnic VALUES ('Palau','white',1.9);
  417. INSERT INTO CIA_Ethnic VALUES ('Palau','Carolinian',1.4);
  418. INSERT INTO CIA_Ethnic VALUES ('Palau','other',1.1);
  419. INSERT INTO CIA_Ethnic VALUES ('Vatican City','Italian',null);
  420. INSERT INTO CIA_Ethnic VALUES ('Vatican City','Swiss',null);
  421.  
  422.  
  423. INSERT INTO CIA_Ocean VALUES
  424. (
  425. 'Baltic Sea', -- Ocean
  426. 0.377000, -- Area in millions of square kilometers
  427. null, -- DeepestName
  428. 459 -- Deepest point in metres
  429. );
  430.  
  431. INSERT INTO CIA_Ocean VALUES
  432. (
  433. 'Aral Sea', -- Ocean
  434. 0.1716, -- Area in millions of square kilometers
  435. null, -- DeepestName
  436. null -- Deepest point in metres
  437. );
  438.  
  439. INSERT INTO CIA_Ocean VALUES
  440. (
  441. 'Caspian Sea', -- Ocean
  442. 0.371, -- Area in millions of square kilometers
  443. null, -- DeepestName
  444. 1025 -- Deepest point in metres
  445. );
  446.  
  447. INSERT INTO CIA_Ocean VALUES
  448. (
  449. 'Dead Sea', -- Ocean
  450. 0.00081, -- Area in millions of square kilometers
  451. null, -- DeepestName
  452. 330 -- Deepest point in metres
  453. );
  454.  
  455. INSERT INTO CIA_Ocean VALUES
  456. (
  457. 'Mediterranean Sea', -- Ocean
  458. 2.5, -- Area in millions of square kilometers
  459. 'Calypso Deep', -- DeepestName
  460. 5267 -- Deepest point in metres
  461. );
  462.  
  463. INSERT INTO CIA_Ocean VALUES
  464. (
  465. 'Black Sea', -- Ocean
  466. 0.4364, -- Area in millions of square kilometers
  467. null, -- DeepestName
  468. 2200 -- Deepest point in metres
  469. );
  470.  
  471. INSERT INTO CIA_Ocean VALUES
  472. (
  473. 'Red Sea', -- Ocean
  474. 0.174, -- Area in millions of square kilometers
  475. null, -- DeepestName
  476. 500 -- Deepest point in metres
  477. );
  478.  
  479. INSERT INTO CIA_Ocean VALUES
  480. (
  481. 'Persian Gulf', -- Ocean
  482. 0.233, -- Area in millions of square kilometers
  483. null, -- DeepestName
  484. 90 -- Deepest point in metres
  485. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!