MySQL
-
2 SELECT from WORLD Tutorial 답안MySQL 2022. 5. 8. 00:47
링크 https://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial 1. Observe the result of running this SQL command to show the name, continent and population of all countries. SELECT name, continent, population FROM world 2. Show the name for the countries that have a population of at least 200 million. 200 million is 200000000, there are eight zeros. SELECT name FROM world WHERE population >= 200000000 3...
-
[SQLZOO] SELECT basics 답MySQL 2022. 4. 19. 11:42
Q: Modify it to show the population of Germany A: SELECT population FROM world WHERE name = 'Germany' Q: Show the name and the population for 'Sweden', 'Norway' and 'Denmark'. A: SELECT name, population FROM world WHERE name IN ('Sweden', 'Norway', 'Denmark'); Q: Which countries are not too small and not too big? BETWEEN allows range checking (range specified is inclusive of boundary values). Th..