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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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
이렇게 데이터를 정렬하고 보면 트렌드를 파악하기가 용이합니다.
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,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.