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.
286
SQL로 시작하는 데이터 분석
10 minutes + minutes
10 minutes? minutes
10 minutes minutes
10 mins mins
... ...
위와 같은 결과가 나온 이유를 자세히 살펴봅시다. 서브 쿼리에서
sighting
_
report
필드의
값 중 시간 부분만 가져와
duration
값으로 저장합니다. 그리고
regexp
_
matches
함수를 사
용해 다음 패턴과 매칭되는 문자열을 찾습니다.
‘\m[Mm][Ii][Nn][A-Za-z]*\y’
이 패턴은 단어의 시작 부분에서 매칭돼야 하며(
\m
), 문자가 대소문자 상관없이
‘
m
’
,
‘
i
’
,
‘
n
’
순으로 나열돼야 합니다(
[
Mm
][
Ii
][
Nn
]
). 그 뒤에는 대소문자 상관없이
0
개 이상의 문자
가 나오고 (
[
AZa
-
z
]*
) 단어가 끝납니다 (
\y
). 따라서
‘
minutes
’
의 다양한 변형 패턴을 찾게
됩니다. 이 패턴에서
‘+’
와
‘?’
문자는 매칭되지 않습니다. 다음으로, 여기에 매칭되는 모든
패턴을
‘
min
’
으로 대체해 표준화합시다.
SELECT
duration
,(regexp_matches(
duration
,’\m[Mm][Ii][Nn][A-Za-z]*\y’)
)[1]
as
matched_minutes
,regexp_replace(
duration
,’\m[Mm][Ii][Nn][A-Za-z]*\y’ ...
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.