2016.9.27小程序---数据库练习1
时间：2021-07-01 10:21:17
帮助过：3人阅读
-- createbbc, 1, 50
2 DROP TABLE bbc;
3
4
5 CREATE INDEX bbc_region ON bbc(region);
6
7 GO
8 -- tabbbc, 1, 50
9 INSERT INTO bbc VALUES (‘Afghanistan‘,‘South Asia‘,652225,26000000,NULL);
10 INSERT INTO bbc VALUES (‘Albania‘,‘Europe‘,28728,3200000,6656000000);
11 INSERT INTO bbc VALUES (‘Algeria‘,‘Middle East‘,2400000,32900000,75012000000);
12 INSERT INTO bbc VALUES (‘Andorra‘,‘Europe‘,468,64000,NULL);
13 INSERT INTO bbc VALUES (‘Angola‘,‘Africa‘,1250000,14500000,14935000000);
14 INSERT INTO bbc VALUES (‘Antigua and Barbuda‘,‘Americas‘,442,77000,770000000);
15 INSERT INTO bbc VALUES (‘Argentina‘,‘South America‘,2800000,39300000,146196000000);
16 INSERT INTO bbc VALUES (‘Armenia‘,‘Europe‘,29743,3000000,3360000000);
17 INSERT INTO bbc VALUES (‘Australia‘,‘Asia-Pacific‘,7700000,20300000,546070000000);
18 INSERT INTO bbc VALUES (‘Austria‘,‘Europe‘,83871,8100000,261630000000);
19 INSERT INTO bbc VALUES (‘Azerbaijan‘,‘Europe‘,86600,8500000,NULL);
20 INSERT INTO bbc VALUES (‘Bahamas‘,‘Americas‘,13939,321000,4789320000);
21 INSERT INTO bbc VALUES (‘Bahrain‘,‘Middle East‘,717,754000,9357140000);
22 INSERT INTO bbc VALUES (‘Bangladesh‘,‘South Asia‘,143998,152600000,67144000000);
23 INSERT INTO bbc VALUES (‘Barbados‘,‘Americas‘,430,272000,2518720000);
24 INSERT INTO bbc VALUES (‘Belarus‘,‘Europe‘,207595,9800000,20776000000);
25 INSERT INTO bbc VALUES (‘Belgium‘,‘Europe‘,30528,10300000,319609000000);
26 INSERT INTO bbc VALUES (‘Belize‘,‘Americas‘,22965,266000,NULL);
27 INSERT INTO bbc VALUES (‘Benin‘,‘Africa‘,112622,7100000,3763000000);
28 INSERT INTO bbc VALUES (‘Bhutan‘,‘South Asia‘,38364,2400000,1824000000);
29 INSERT INTO bbc VALUES (‘Bolivia‘,‘South America‘,1100000,9100000,NULL);
30 INSERT INTO bbc VALUES (‘Bosnia-Hercegovina‘,‘Europe‘,51129,4200000,8568000000);
31 INSERT INTO bbc VALUES (‘Botswana‘,‘Africa‘,581730,1800000,7812000000);
32 INSERT INTO bbc VALUES (‘Brazil‘,‘South America‘,8550000,182800000,564852000000);
33 INSERT INTO bbc VALUES (‘Brunei‘,‘Asia-Pacific‘,5765,374000,NULL);
34 INSERT INTO bbc VALUES (‘Bulgaria‘,‘Europe‘,110994,7800000,21372000000);
35 INSERT INTO bbc VALUES (‘Burkina Faso‘,‘Africa‘,274200,13800000,4968000000);
36 INSERT INTO bbc VALUES (‘Burma‘,‘Asia-Pacific‘,676552,50700000,NULL);
37 INSERT INTO bbc VALUES (‘Burundi‘,‘Africa‘,27816,7300000,NULL);
38 INSERT INTO bbc VALUES (‘Cambodia‘,‘Asia-Pacific‘,181035,14800000,4736000000);
39 INSERT INTO bbc VALUES (‘Cameroon‘,‘Africa‘,465458,16600000,13280000000);
40 INSERT INTO bbc VALUES (‘Canada‘,‘North America‘,9900000,32000000,908480000000);
41 INSERT INTO bbc VALUES (‘Cape Verde‘,‘Africa‘,4033,482000,853140000);
42 INSERT INTO bbc VALUES (‘Central African Republic‘,‘Africa‘,622984,3900000,NULL);
43 INSERT INTO bbc VALUES (‘Chad‘,‘Africa‘,1280000,9100000,2366000000);
44 INSERT INTO bbc VALUES (‘Chile‘,‘South America‘,756096,16200000,79542000000);
45 INSERT INTO bbc VALUES (‘China‘,‘Asia-Pacific‘,9600000,1300000000,1677000000000);
46 INSERT INTO bbc VALUES (‘Colombia‘,‘South America‘,1140000,45600000,NULL);
47 INSERT INTO bbc VALUES (‘Comoros‘,‘Africa‘,1862,812000,NULL);
48 INSERT INTO bbc VALUES (‘Costa Rica‘,‘Americas‘,51100,4300000,NULL);
49 INSERT INTO bbc VALUES (‘Croatia‘,‘Europe‘,56594,4400000,28996000000);
50 INSERT INTO bbc VALUES (‘Cuba‘,‘Americas‘,110860,11300000,NULL);
51 INSERT INTO bbc VALUES (‘Cyprus‘,‘Europe‘,9250,807000,14187060000);
52 INSERT INTO bbc VALUES (‘Czech Republic‘,‘Europe‘,78866,10200000,93330000000);
53 INSERT INTO bbc VALUES (‘Democratic Republic of Congo‘,‘Africa‘,2340000,56000000,6720000000);
54 INSERT INTO bbc VALUES (‘Denmark‘,‘Europe‘,43098,5400000,219510000000);
55 INSERT INTO bbc VALUES (‘Djibouti‘,‘Africa‘,23200,721000,NULL);
56 INSERT INTO bbc VALUES (‘Dominica‘,‘Americas‘,751,71000,259150000);
57 INSERT INTO bbc VALUES (‘Dominican Republic‘,‘Americas‘,48072,9000000,NULL);
58 INSERT INTO bbc VALUES (‘East Timor‘,‘Asia-Pacific‘,14609,857000,NULL);
59 -- tabbbc, 51, 50
60 INSERT INTO bbc VALUES (‘Ecuador‘,‘South America‘,272045,13400000,NULL);
61 INSERT INTO bbc VALUES (‘Egypt‘,‘Middle East‘,1000000,74900000,98119000000);
62 INSERT INTO bbc VALUES (‘El Salvador‘,‘Americas‘,21041,6700000,15745000000);
63 INSERT INTO bbc VALUES (‘Equatorial Guinea‘,‘Africa‘,28051,521000,484530000);
64 INSERT INTO bbc VALUES (‘Eritrea‘,‘Africa‘,117400,4561599,NULL);
65 INSERT INTO bbc VALUES (‘Estonia‘,‘Europe‘,45227,1300000,9113000000);
66 INSERT INTO bbc VALUES (‘Ethiopia‘,‘Africa‘,1130000,74200000,8162000000);
67 INSERT INTO bbc VALUES (‘Fiji‘,‘Asia-Pacific‘,18376,854000,NULL);
68 INSERT INTO bbc VALUES (‘Finland‘,‘Europe‘,338145,5200000,170508000000);
69 INSERT INTO bbc VALUES (‘Former Yugoslav Republic of Macedonia‘,‘Europe‘,25713,2000000,4700000000);
70 INSERT INTO bbc VALUES (‘France‘,‘Europe‘,543965,60700000,1826463000000);
71 INSERT INTO bbc VALUES (‘Gabon‘,‘Africa‘,267667,1400000,NULL);
72 INSERT INTO bbc VALUES (‘Georgia‘,‘Europe‘,69700,5000000,5200000000);
73 INSERT INTO bbc VALUES (‘Germany‘,‘Europe‘,357027,82500000,2484900000000);
74 INSERT INTO bbc VALUES (‘Ghana‘,‘Africa‘,238533,21800000,8284000000);
75 INSERT INTO bbc VALUES (‘Greece‘,‘Europe‘,131957,11000000,182710000000);
76 INSERT INTO bbc VALUES (‘Grenada‘,‘Americas‘,344,103000,NULL);
77 INSERT INTO bbc VALUES (‘Guatemala‘,‘Americas‘,108890,13000000,NULL);
78 INSERT INTO bbc VALUES (‘Guinea‘,‘Africa‘,245857,8800000,4048000000);
79 INSERT INTO bbc VALUES (‘Guinea-Bissau‘,‘Africa‘,36125,1600000,256000000);
80 INSERT INTO bbc VALUES (‘Guyana‘,‘South America‘,214969,768000,NULL);
81 INSERT INTO bbc VALUES (‘Haiti‘,‘Americas‘,27750,8500000,NULL);
82 INSERT INTO bbc VALUES (‘Honduras‘,‘Americas‘,112492,7200000,7416000000);
83 INSERT INTO bbc VALUES (‘Hungary‘,‘Europe‘,93030,9800000,81046000000);
84 INSERT INTO bbc VALUES (‘Iceland‘,‘Europe‘,103000,294000,11354280000);
85 INSERT INTO bbc VALUES (‘India‘,‘South Asia‘,3100000,1100000000,682000000000);
86 INSERT INTO bbc VALUES (‘Indonesia‘,‘Asia-Pacific‘,1900000,225300000,256842000000);
87 INSERT INTO bbc VALUES (‘Iran‘,‘Middle East‘,1650000,70700000,162610000000);
88 INSERT INTO bbc VALUES (‘Iraq‘,‘Middle East‘,438317,26500000,NULL);
89 INSERT INTO bbc VALUES (‘Ireland‘,‘Europe‘,70182,4000000,137120000000);
90 INSERT INTO bbc VALUES (‘Israel and Palestinian territories‘,‘Middle East‘,20770,3800000,4256000000);
91 INSERT INTO bbc VALUES (‘Italy‘,‘Europe‘,301338,57200000,1494064000000);
92 INSERT INTO bbc VALUES (‘Ivory Coast‘,‘Africa‘,322462,17100000,13167000000);
93 INSERT INTO bbc VALUES (‘Jamaica‘,‘Americas‘,10991,2700000,7830000000);
94 INSERT INTO bbc VALUES (‘Japan‘,‘Asia-Pacific‘,377864,127900000,4755322000000);
95 INSERT INTO bbc VALUES (‘Jordan‘,‘Middle East‘,89342,5700000,12198000000);
96 INSERT INTO bbc VALUES (‘Kazakhstan‘,‘Asia-Pacific‘,2700000,15400000,NULL);
97 INSERT INTO bbc VALUES (‘Kenya‘,‘Africa‘,582646,32800000,15088000000);
98 INSERT INTO bbc VALUES (‘Kiribati‘,‘Asia-Pacific‘,810,85000,82450000);
99 INSERT INTO bbc VALUES (‘Kuwait‘,‘Middle East‘,17818,2700000,48519000000);
100 INSERT INTO bbc VALUES (‘Kyrgyzstan‘,‘Asia-Pacific‘,199900,5300000,NULL);
101 INSERT INTO bbc VALUES (‘Laos‘,‘Asia-Pacific‘,236800,5900000,2301000000);
102 INSERT INTO bbc VALUES (‘Latvia‘,‘Europe‘,64589,2300000,NULL);
103 INSERT INTO bbc VALUES (‘Lebanon‘,‘Middle East‘,10452,3800000,18924000000);
104 INSERT INTO bbc VALUES (‘Lesotho‘,‘Africa‘,30355,1800000,1332000000);
105 INSERT INTO bbc VALUES (‘Liberia‘,‘Africa‘,99067,3600000,396000000);
106 INSERT INTO bbc VALUES (‘Libya‘,‘Africa‘,1770000,5800000,25810000000);
107 INSERT INTO bbc VALUES (‘Liechtenstein‘,‘Europe‘,160,34000,NULL);
108 INSERT INTO bbc VALUES (‘Lithuania‘,‘Europe<
