力扣 595.大的国家

最新推荐文章于 2024-10-21 08:29:46 发布

奋斗哼哼

最新推荐文章于 2024-10-21 08:29:46 发布

阅读量46

点赞数

文章标签：开发语言 sql 数据库 leetcode mysql

本文链接：https://blog.csdn.net/weixin_51696882/article/details/130372484

版权

准备数据

Create table If Not Exists World (name varchar(255), continent varchar(255), area int, population int, gdp bigint);
Truncate table World;
insert into World (name, continent, area, population, gdp) values ('Afghanistan', 'Asia', '652230', '25500100', '20343000000');
insert into World (name, continent, area, population, gdp) values ('Albania', 'Europe', '28748', '2831741', '12960000000');
insert into World (name, continent, area, population, gdp) values ('Algeria', 'Africa', '2381741', '37100000', '188681000000');
insert into World (name, continent, area, population, gdp) values ('Andorra', 'Europe', '468', '78115', '3712000000');
insert into World (name, continent, area, population, gdp) values ('Angola', 'Africa', '1246700', '20609294', '100990000000');