SELECT name, population FROM world
WHERE name IN ('Sweden', 'Norway', 'Denmark')
SELECT name, area FROM world
WHERE area BETWEEN 200000 AND 250000
SELECT SUM(population) FROM world
SELECT DISTINCT region FROM bbc ORDER BY population DESC
SELECT * FROM goal
WHERE player LIKE '%Bender'
SELECT name FROM world
WHERE population >
(SELECT population FROM world WHERE name='Romania')
SELECT *
FROM game JOIN goal ON id=matchid
SELECT a.company, a.num, a.stop, b.stop
FROM route a JOIN route b ON
(a.company=b.company AND a.num=b.num)
WHERE a.stop=53
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。