<보기 1>은 학생들에 대한 정보를 담고 있는 WORK_INFO 테이블이다. <보기 2>의 SQL 질의를 수행할 때 예상되는 출력 결과는?<보기 1>
| Name | D_name | Salary |
|---|
| 심종화 | engineering_building | 250 |
| 이준석 | information_building | 240 |
| 김성희 | engineering_building | 260 |
| 한상유 | engineering_building | 210 |
| 김태의 | science_building | 310 |
| 유상민 | computer_building | 290 |
| 김소희 | information_building | 220 |
| 김은빈 | science_building | 180 |
| 조성국 | computer_building | 300 |
<보기 2>
CREATE VIEW DEPT_INFO
(Dept_name, No_of_emps, Total_sal)
AS SELECT D_name, COUNT(*), SUM(Salary)
FROM WORK_INFO
GROUP BY D_name
1DEPT_INFO
| COUNT(*) | SUM(Salary) |
|---|
| 3 | 720 |
| 2 | 460 |
| 2 | 490 |
| 2 | 590 |
2DEPT_INFO
| D_name | No_of_emps | Total_sal |
|---|
| engineering_building | 3 | 720 |
| information_building | 2 | 460 |
| science_building | 2 | 490 |
| computer_building | 2 | 590 |
3DEPT_INFO
| Dept_name | COUNT(*) |
|---|
| engineering_building | 3 |
| information_building | 2 |
| science_building | 2 |
| computer_building | 2 |
4DEPT_INFO
| Dept_name | No_of_emps | Total_sal |
|---|
| engineering_building | 3 | 720 |
| information_building | 2 | 460 |
| science_building | 2 | 490 |
| computer_building | 2 | 590 |
해설
등록된 해설이 없습니다.
오류나 개정된 내용이 보이면 알려주세요