August 2022
Beginner to intermediate
436 pages
9h 43m
Korean
Content preview from SQL로 시작하는 데이터 분석
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
161
3
장
시계열 분석
as
sales_1993
,
max
(
case
when
date_part(‘year’,sales_month) = 1994
then
sales
end
)
as
sales_1994
FROM
retail_sales
WHERE
kind_of_business = ‘Book stores’
and
sales_month
between
‘1992-01-01’
and
‘1994-12-01’
GROUP
BY
1,2
;
month_number month_name sales_1992 sales_1993 sales_1994
------------ ---------- ---------- ---------- ----------
1 January 790 998 1053
2 February 539 568 635
3 March 535 602 634
4 April 523 583 610
5 May 552 612 684
6 June 589 618 724
7 July 592 607 678
8 August 894 983 1154
9 September 861 903 1022
10 October 645 669 732
11 November 642 692 772
12 December 1165 1273 1409
이렇게 데이터를 정렬하고 보면 트렌드를 파악하기가 용이합니다.