꿈라CBT다음 SQL 구문의 실행 결과를 작성하시오.
보기
SELECT count(*)
FROM employee AS e JOIN project AS p ON e.project_id = p.project_id
WHERE p.name IN (
SELECT name FROM project p WHERE p.project_id IN (
SELECT project_id FROM employee GROUP BY project_id HAVING count(*) < 2
)
);[ employee ]
| no | first_name | last_name | project_id |
|---|---|---|---|
| 1 | John | Doe | 10 |
| 2 | Jim | Carry | 20 |
| 3 | Rachel | Redmond | 10 |
[ project ]
| project_id | name |
|---|---|
| 10 | Alpha |
| 20 | Beta |
| 10 | Gamma |
이 문제는 풀이 화면에서 직접 실행해 풀 수 있어요.