3.9 序列中所有集合成员的交集
有各个国家的语言人口占比表,其部分数据如下:
CountryCode | Language | Percentage |
---|---|---|
England | English | 90% |
America | English | 70% |
Canada | English | 60% |
Russia | English | 10% |
France | English | 5% |
England | French | 3% |
America | French | 3% |
Canada | French | 30% |
Russia | French | 3% |
France | French | 95% |
England | Spanish | 1% |
America | Spanish | 20% |
Canada | Spanish | 1% |
Russia | Spanish | 0.01% |
France | Spanish | 0.05% |
请列出英语人口、法语人口、西班牙语人口分别超过 0.3%、0.2%、0.1% 的国家代码。
脚本:
A | |
---|---|
1 | =connect(“mysql”) |
2 | [English,French,Spanish] |
3 | [0.3,0.2,0.1] |
4 | =A2.(A1.query@i(“select countrycode from world.countrylanguage where language=? and percentage>?”,~,A3(#))) |
5 | >A1.close() |
6 | =A4.isect() |
A4 按次序依次查询英语人口超 0.3%、法语人口超 0.2%、西班牙语超 0.1% 的国家代码,并转成序列。query() 函数的 @i 选项表示当选出结果只有一列时,直接返回成序列
A5 A4 中所有序列交集