Cats Who Code

#DATE_FORMAT - NOT NEEDED FOR COMPARISON HERE. #IT CONVERTS TO A DATETIIME VALUE INTO A STRING: #A GOOD USE FOR STRING COMPARISON. SELECT i.ANIMAL_ID, i.NAME FROM ANIMAL_INS AS iJOIN ANIMAL_OUTS AS o ON i.ANIMAL_ID = o.ANIMAL_ID WHERE i.DATETIME > o.DATETIME ORDER BY i.DATETIME;SELECT i.ANIMAL_ID, i.NAME FROM ANIMAL_INS as iJOIN ANIMAL_OUTS as o ON i.ANIMAL_ID = o.ANIMAL_ID WHERE DATE_FORMAT(i.D..

DATE_FORMAT(OUT_DATE,'%Y-%m-%d') - needed formatted outputs for the requirement SELECT ORDER_ID, PRODUCT_ID, DATE_FORMAT(OUT_DATE,'%Y-%m-%d'), CASE WHEN OUT_DATE IS NULL THEN '출고미정' WHEN DATE_FORMAT(OUT_DATE,'%Y-%m-%d') # enter else statement OUT_DATE IS NULL implicitly >> explicitily # not necessarily handle null SELECT ORDER_ID, PRODUCT_ID, DATE_FORMAT(OUT_DATE,'%Y-%m-%d'..

SELECT i.ANIMAL_ID, i.NAME FROM ANIMAL_INS i JOIN ANIMAL_OUTS oON i.ANIMAL_ID = o.ANIMAL_ID #WHERE o.datetime IS NOT NULL - NOT NDDED - BOTH DATETIMES IS NOT NULLABLE ORDER BY DATEDIFF(o.DATETIME,i.DATETIME) DESC LIMIT 2

#from just what i had in mind to query SELECT DISTINCT h.CAR_ID FROM CAR_RENTAL_COMPANY_CAR AS cJOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY AS hON c.CAR_ID = h.CAR_ID WHERE CAR_TYPE ='세단' AND START_DATE LIKE '2022-10-%'ORDER BY CAR_ID DESC#USING SUBQUERY - seems to be more adequate for what the question asks SELECT DISTINT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE MONTH(START_DATE) = 10 AND..