Set 1 문제

Set 1 문제

 

 

Big Countries

 

SELECT name
     , population
     , area
FROM World
WHERE area >= 3000000
OR population >= 25000000;

 

 

Not Boring Movies

 

SELECT *
FROM Cinema
WHERE id % 2 = 1
AND description != 'boring'
ORDER BY rating DESC;

 

 

Duplicate Emails

 

SELECT email
FROM Person
GROUP BY email
HAVING COUNT(id) >= 2;

 

 

Combine Two Tables

 

SELECT P.firstName
     , P.lastName
     , A.city
     , A.state
FROM Person AS P
     LEFT JOIN Address AS A ON P.personId = A.personId;