SQL 알고리즘 코드카타(카테고리 별 도서 판매량 집계하기) 26.04.14(화)

1. 문제 링크:https://school.programmers.co.kr/learn/courses/30/lessons/144855
2. 정답 코드: 

select 
    b.category,
    sum(bs.sales) as total_sales
from book as b
join book_sales as bs
    on b.book_id = bs.book_id
where bs.sales_date like '2022-01%'
group by b.category
order by b.category asc;

3. 오류 상황:

SELECT
    b.category,
    count(bs.sales) as total_sales
from book as b
inner join book_sales as bs
    on b.book_id=bs.book_id
where sales_date like '2022-01'
group by b.category
order by b.category asc

=> like 문 오류

4. 시도 방법:

=> 작성된 글 외 포함된 값을 보려면 % 포함해야함

5. 최종 문제 해결 방법:

=> '2022-01%' 로 수정