본문 바로가기
MySQL

sqlzoo.net 답 (SELECT basics)

MySQL 쿼리 연습을 할 수 있는 사이트

https://sqlzoo.net/

 

SQLZOO

New Tutorial: COVID-19 international data. This server is hosted by Edinburgh Napier University https://napier.ac.uk Reference: how to... 1 SELECT How to read the data from a database. 2 CREATE and DROP How to create tables, indexes, views and other things

sqlzoo.net

SELECT basics

--no1

select population from world
where name = 'germany'

 

--no2

select name, population from world
where name in ('sweden', 'norway', 'denmark');


--no3

select name, area from world
where area between 200000 and 250000