全球末日启动机

1、查询geom列中‘张毅’坐标的文本显示方式；

2、查询geom列中‘张毅’坐标的json显示方式；

3、查询在‘xian’表中查询‘县县’的轮廓的坐标，以geojson显示；

4、查询在‘xian’表中查询‘县县’的面积，单位是平方米；

5、计算‘张毅’与你家的直线距离；

6、结合‘xian’表和‘giser2021’表，查询‘你’来自哪里

1、select st_astext(geom) from giser2021 where name = '张毅'

2、select st_asgeojson(geom) from giser2021 where name = '张毅'

3、select st_asgeojson(geom) from xian where name = '县县'

https://zxjson.com/

4、select st_area(geography(geom)) as 平方米 from xian where name = '县县'

5、select st_distance(geography((select giser2021 geom from giser2021 where name = '张毅')),geography((select geom from giser2021 where name = '徐胖子')))

6、select xian.name from xian where st_within((select giser2021.geom from giser2021 where name = '张毅'),xian.geom)

1、select st_astext(geom) from giser2021 where name = '张毅'

2、select st_asgeojson(geom) from giser2021 where name = '张毅'

3、select st_asgeojson(geom) from xian where name = '县县'

https://zxjson.com/

4、select st_area(geography(geom)) as 平方米 from xian where name = '县县'

5、select st_distance(geography((select giser2021 geom from giser2021 where name = '张毅')),geography((select geom from giser2021 where name = '徐胖子')))

6、select xian.name from xian where st_within((select giser2021.geom from giser2021 where name = '张毅'),xian.geom)

1、选择班内所有人的全部信息

2、选择班内所有人的姓名和性别信息；

3、选择班内同学的性别的种类；

4、选择班内姓名为“徐胖子”的学号、姓名、性别和家庭住址

5、查询班内女生的数量；

6、选择班内学号大于‘211400003820’的同学，并按照升序排序

7、选择学号介于211400003820和211400003840的男生；

8、查询班内姓王的同学

9、将‘张毅’的学号更改为‘211400003900’

10、删除姓名为‘张毅’的学生

1、select * from giser2021;

2、select sex,name from giser2021;

3、select distinct sex from giser20;

4、select number,name,sex,address from giser2021 where name = '徐胖子'

5、select count(*) from giser2021 where sex='女';

6、select * from giser2021 where number>'211400003820' order by number asc;

7、select * from giser2021 where sex = '男' AND number BETWEEN '211400003820' AND '211400003840';

8、select * from giser2021 where name LIKE '王%';

9、update giser2021 set number='211400003900' where name='张毅';

10、delete from giser2021 where name='张毅';