(1) ๊ณ ๋ํ
(1) [SQLP์ค๊ธฐ๋ฌธ์ ]6์ฅ ๊ณ ๊ธSQLํ๋(3)๋ฐ์ดํฐ๋ฒ ์ด์ค CALL ์ต์ํ 40๋ฒ
(2) [SQLP์ค๊ธฐ๋ฌธ์ ]6์ฅ ๊ณ ๊ธSQLํ๋(6) ๊ณ ๊ธ SQL ํ์ฉ 55๋ฒ
(3) [SQLP์ค๊ธฐ๋ฌธ์ ]6์ฅ ๊ณ ๊ธSQLํ๋(6) ๊ณ ๊ธ SQL ํ์ฉ 56๋ฒ
(4) [SQLP์ค๊ธฐ๋ฌธ์ ]6์ฅ ๊ณ ๊ธSQLํ๋(6) ๊ณ ๊ธ SQL ํ์ฉ 57๋ฒ
(5) 58๋ฒ์ ์ ํด๋ ๋ ๋ฏ
(1)
[SQLP์ค๊ธฐ๋ฌธ์ ]6์ฅ ๊ณ ๊ธSQLํ๋(6) ๊ณ ๊ธ SQL ํ์ฉ 57๋ฒ
SELECT ๊ณ ๊ฐ๋ฒํธ , MIN(A.๊ณ ๊ฐ๋ช
) ๊ณ ๊ฐ๋ช
, MIN(DECODE(B.์ฐ๋ฝ์ฒ๊ตฌ๋ถ์ฝ๋ , 'HOM', B.์ฐ๋ฝ์ฒ๋ฒํธ )) AS ์ง
, MIN(DECODE(B.์ฐ๋ฝ์ฒ๊ตฌ๋ถ์ฝ๋ , 'OFC', B.์ฐ๋ฝ์ฒ๋ฒํธ )) AS ์ฌ๋ฌด์ค
, MIN(DECODE(B.์ฐ๋ฝ์ฒ๊ตฌ๋ถ์ฝ๋ , 'MBL', B.์ฐ๋ฝ์ฒ๋ฒํธ )) AS ํด๋ํฐ
FROM ๊ณ ๊ฐ A , ๊ณ ๊ฐ์ฐ๋ฝ์ฒ B
WHERE A.๊ณ ๊ฐ๊ตฌ๋ถ์ฝ๋ = 'VIP'
AND A.๊ณ ๊ฐ๋ฒํธ = B.๊ณ ๊ฐ๋ฒํธ(+)
GROUP BY ๊ณ ๊ฐ๋ฒํธ;