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..