[2021/08/10] SQL 주식 데이터 쿼리3

# 혼자서 해보기

SELECT * FROM db_sqlstk.stock;

# 132P~ 혼자서 해보기
SELECT *
FROM STOCK
WHERE STK_NM = '삼성전자';

# 133
SELECT SEC_NM, STK_CD, STK_NM
FROM STOCK
WHERE SEC_NM = '자동차'
ORDER BY STK_NM DESC;

# 146
SELECT T1.STK_CD, T1.STK_NM, T1.EX_CD, T1.SEC_NM
FROM STOCK T1
WHERE T1.STK_NM LIKE '동양%'
AND T1.SEC_NM NOT LIKE '%금속%'
ORDER BY T1.EX_CD DESC, T1.STK_NM ASC;

# 147 ~혼자서 해보기
SELECT T1.STK_NM 종목명
		, T1.STK_CD 종목코드
        , T1.EX_CD 거래소코드
        , T1.SEC_NM 섹터명
FROM STOCK T1
WHERE T1.STK_NM IN ('NAVER', '넷마블', '넥슨지티', '카카오')
ORDER BY T1.EX_CD ASC, T1.STK_NM ASC;