hyezdata 님의 블로그

가격대 별 상품 개수 구하기SELECT (FLOOR(price/10000))*10000 AS price_group, COUNT(product_id) AS productsFROM productGROUP BY 1ORDER BY 1 다른방법SELECT TRUNCATE(price, -4) AS price_group, COUNT(product_id) AS productsFROM productGROUP BY 1ORDER BY 1  3월에 태어난 여성 회원 목록 출력하기SELECT member_id, member_name, gender, DATE_FORMAT(date_of_birth, '%Y-%m-%d') AS date_of_birthFROM member_profileWHERE DATE_F..

오랜 기간 보호한 동물(2)SELECT i.animal_id, i.nameFROM animal_ins i INNER JOIN animal_outs o ON i.animal_id=o.animal_idORDER BY DATEDIFF(o.datetime, i.datetime) DESCLIMIT 2