π¬ MySQL/λ¬Έμ νμ΄
[MySQL] SQL μ½λ©ν μ€νΈ Day11
xod22
2022. 2. 23. 19:24
728x90
https://programmers.co.kr/learn/courses/30/lessons/59045
μ½λ©ν μ€νΈ μ°μ΅ - 보νΈμμμ μ€μ±νν λλ¬Ό
ANIMAL_INS ν μ΄λΈμ λλ¬Ό 보νΈμμ λ€μ΄μ¨ λλ¬Όμ μ 보λ₯Ό λ΄μ ν μ΄λΈμ λλ€. ANIMAL_INS ν μ΄λΈ ꡬ쑰λ λ€μκ³Ό κ°μΌλ©°, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKEλ κ°κ° λλ¬Όμ μμ΄λ
programmers.co.kr
λ¬Έμ (보νΈμμμ μ€μ±ν ν λλ¬Ό) :
보νΈμμμ μ€μ±ν μμ μ κ±°μΉ λλ¬Ό μ 보λ₯Ό μμλ³΄λ € ν©λλ€. 보νΈμμ λ€μ΄μ¬ λΉμμλ μ€μ±νλμ§ μμμ§λ§, 보νΈμλ₯Ό λκ° λΉμμλ μ€μ±νλ λλ¬Όμ μμ΄λμ μλ¬Ό μ’ , μ΄λ¦μ μ‘°ννλ μμ΄λ μμΌλ‘ μ‘°ννλ SQL λ¬Έμ μμ±ν΄μ£ΌμΈμ.
νμ΄
λ°©λ²1)
SELECT INS.ANIMAL_ID, INS.ANIMAL_TYPE, INS.NAME
FROM ANIMAL_INS INS, ANIMAL_OUTS OUTS
WHERE INS.ANIMAL_ID=OUTS.ANIMAL_ID
AND INS.SEX_UPON_INTAKE != OUTS.SEX_UPON_OUTCOME
ORDER BY INS.ANIMAL_ID;
- SEX_UPON_INTAKEμ SEX_UPON_OUTCOMEμ΄ λ€λ₯΄λ€λ©΄ μ€μ±νλ₯Ό νλ€λ κ²!
μ€μ±ν->μμ° (λΆκ°)
μμ°->μ€μ±ν (κ°λ₯)
νκΈ°λλ¬Έμ μ΄ λ°©λ²μ μΈ μ μμ!
=> WHERE INS.SEX_UPON_INTAKE != OUTS.SEX_UPON_OUTCOME
λ°©λ²2)
--μ€μ±ν Neutered, Spayed μμ°μ Intact
SELECT INS.ANIMAL_ID, INS.ANIMAL_TYPE, INS.NAME
FROM ANIMAL_INS INS, ANIMAL_OUTS OUTS
WHERE INS.ANIMAL_ID=OUTS.ANIMAL_ID
AND INS.SEX_UPON_INTAKE LIKE "Intact%"
AND (OUTS.SEX_UPON_OUTCOME LIKE "Neutered%" OR OUTS.SEX_UPON_OUTCOME LIKE "Spayed%")
ORDER BY INS.ANIMAL_ID;
- SEX_UPON_INTAKEμμ Intack(μμ°)μ΄λ€κ° SEX_UPON_OUTCOMEμμ Neutered/Spayed(μ€μ±ν)μΈ κ²λ§ λ½μλ!
=> WHERE INS.SEX_UPON_INTAKE LIKE "Intact%" AND (OUTS.SEX_UPON_OUTCOME LIKE "Neutered%" OR OUTS.SEX_UPON_OUTCOME LIKE "Spayed%")
728x90