42-Λ࢖ͬͨσʔλ෼ੳࣄྫ঺հ
ʙͭͷࣄྫ͔ΒֶͿ42-ͷ׆༻ํ๏ʙ SQL Everyone 42-ษڧձ
  

© 
)JLBSV
5BLBIBTIJ  ΞδΣϯμ "HFOEB ࣗݾ঺հ
σʔλ෼ੳͰ࢖͏42-ͷجૅ
42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ
σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ
2"

Ξϯέʔτ     SQL Everyone  ෼ ෼ ෼ ෼ ෼ 

© 
)JLBSV
5BLBIBTIJ  ΞδΣϯμ "HFOEB ࣗݾ঺հ
σʔλ෼ੳͰ࢖͏42-ͷجૅ
42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ
σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ
2"

Ξϯέʔτ     SQL Everyone  

© 
)JLBSV
5BLBIBTIJ  ߴڮ
ޫ )JLBSV
5BLBIBTIJ ϓϩϑΟʔϧʢຊۀɾෳۀʣ ߨࢣ঺հ Ϡϑʔגࣜձࣾʢʙʣ גࣜձࣾΠʔϒοΫΠχγΞςΟϒδϟύϯʢʙʣ ֎ࢿίϯαϧʢʙʣ ɾϑϩϯτΤϯυαʔόαΠυόοΫΤϯυͳͲϑϧελοΫͰ8FCαʔϏεΛاըઃܭ։ൃӡ༻
ɾΤϯδχΞϚωʔδϟʔΤϯδχΞ࠾༻ ɾϠϑʔ͔Βग़޲ͯ͠σʔλαΠΤϯεάϧʔϓΛθϩ͔Β্ཱͪ͛ʢ෦௕ʣ
ɾ#*πʔϧ42-1ZUIPOͳͲ࢖ͬͨσʔλͷՄࢹԽ΍෼ੳ"#ςετޮՌݕূ,1*σʔλར׆༻ଅਐ
ɾࣾ಺ϝϯόʔͷσʔλ෼ੳεΩϧΞοϓҭ੒ࣾ಺σʔλར׆༻ϦςϥγʔΞοϓʢ42-ษڧձͳͲʣ ɾ42-΍#*πʔϧΛ׆༻ͨ͠σʔλ෼ੳࢧԉ
ɾσδλϧϚʔέςΟϯάྖҬʹ͓͚ΔઓཱུҊɺ,1*ઃܭɺࢪࡦͷϓϥϯχϯάɺࢪࡦͷ࣮ߦ 8FCΤϯδχΞ σʔλΞφϦετϚωʔδϟʔ σδλϧϚʔέςΟϯάίϯαϧλϯτ ɾσʔλ෼ੳࢧԉσδλϧϚʔέςΟϯάࢧԉ
ɾσʔλ෼ੳίʔνϯά42-τϨʔχϯά σʔλ෼ੳࢧԉ ෳۀʢʙʣ 

© 
)JLBSV
5BLBIBTIJ  ϓϩϑΟʔϧʢݸਓ׆ಈʣ ߨࢣ঺հ ೥͔Βෳۀ։࢝ɻ೥ʹϓϩ εϙʔπνʔϜͰͷෳۀͰ೔ܦ৽ฉͷҰ ໘ʹܝࡌɻ ஶॻʰσʔλ෼ੳྗΛߴΊΔϏδωε ύʔιϯͷͨΊͷ42-ೖ໳ʱ͕೥ ʹൃചɻ ݸਓͱͯ͠42-ษڧձΛଟ਺ओ࠵ɻͦ ͷଞOPUF΍9ͳͲͰ೔ʑ42-ʹؔ͢Δ ৘ใΛൃ৴ɻ ೔ܦ৽ฉҰ໘ܝࡌ 42-ೖ໳ॻग़൛ 42-ษڧձओ࠵ MJHIU 

© 
)JLBSV
5BLBIBTIJ  ΞδΣϯμ "HFOEB ࣗݾ঺հ
σʔλ෼ੳͰ࢖͏42-ͷجૅ
42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ
σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ
2"

Ξϯέʔτ     SQL Everyone  

© 
)JLBSV
5BLBIBTIJ  σʔλ෼ੳͰ࢖͏42-ͷಛ௃ σʔλ෼ੳͰ࢖͏42-ͷͭͷಛ௃ 42- VTFS@JE HFOEFS CJSUI " உੑ  ࣮ߦ݁Ռ 4&-&$5

'30.
VTFST
8)&3&
VTFS@JE

b"` σʔλϕʔε ςʔϒϧ VTFS@JE HFOEFS CJSUI " உੑ  " ঁੑ  ɾɾɾ ɾɾɾ ɾɾɾ QSPEVDU@JE QSPEVDU@OBNF QSJDF # ͓͍͍͠ਫ  # γϟʔϓϖϯ  ɾɾɾ ɾɾɾ ɾɾɾ 42-͸ デ ʔλ ベ ʔε্ͷςʔ ブ ϧʹ֨ೲ͞Εͨ デ ʔλΛऔಘ͢Δͱ͖ʹ࢖͏ݴޠɻσʔλϕʔεͱ ͸σʔλΛ֨ೲ͢Δେ͖ͳശͰɺςʔϒϧͱ͸ߦͱྻͰߏ੒͞ΕΔσʔλͷ͔ͨ·Γɻ Ϣʔβʔ ྻ ߦ 

© 
)JLBSV
5BLBIBTIJ  σʔλ෼ੳͰ࢖͏42-ͷಛ௃ σʔλ෼ੳͰ࢖͏42-ͷͭͷಛ௃ Ϗδωεύʔιϯ͕࢖͏42- ΤϯδχΞ͕࢖͏42- σʔλ෼ੳͰ͸جຊతʹ͸σʔλͷऔಘʢ4&-&$5ʣ Λ֮͑Ε͹Α͍
42-ͷॲཧ଎౓ʹ͍ͭͯҙࣝ͢Δඞཁੑ͕௿͍

جຊతͳߏจΛ֮͑Ε͹ͣͬͱ࢖͍ଓ͚Δ͜ͱ͕Ͱ͖ Δ ΞϓϦέʔγϣϯ։ൃʹඞཁͳ42-ʢ4&-&$5

ɹ */4&35

%&-&5&

61%"5&

$3&"5&ʣΛ֮͑Δඞ ཁ͕͋Δ
ϛϦඵ୯ҐͰॲཧ଎౓Λҙࣝ͢Δඞཁ͕͋ΔʢͦͷͨΊ ΠϯσοΫεͳͲͷσʔλϕʔεͷ஌ࣝ΋ඞཁʹͳΔʣ
৽͍͠42-ͷߏจΛ֮͑ͯΑΓޮ཰తͳ42-Λॻ͘ඞཁ ͕͋Δ Ϗδωεύʔιϯ͕࢖͏42-ͱΤϯδχΞ͕࢖͏42-͸ಛ௃͕ҟͳΔɻ42-͸ΤϯδχΞ͕ѻ͏೉ ͍͠ݴޠͱࢥΘΕ͕͕ͪͩɺϏδωεύʔιϯ͕σʔλ෼ੳͰ࢖͏42-͸೉͘͠ͳ͍ɻ 

© 
)JLBSV
5BLBIBTIJ  ΞδΣϯμ "HFOEB ࣗݾ঺հ
σʔλ෼ੳͰ࢖͏42-ͷجૅ
42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ
σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ
2"

Ξϯέʔτ     SQL Everyone  

© 
)JLBSV
5BLBIBTIJ  42-Λ׆༻ͨͭ͠ͷσʔλ෼ੳࣄྫ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ 42-Λ׆༻ͨͭ͠ͷࣄྫΛ঺հɻ42-Λ׆༻͢Δ͜ͱͰσʔλ෼ੳ؀ڥ͕ͳ͍৔߹Ͱ΋1P$ͱ͠ ͯσʔλͷ׆༻͕Ͱ͖Δɻ σʔλ෼ੳ؀ڥ͕ͳ͍ σʔλ෼ੳ؀ڥ͕͋Δ ஍ํͷ##੡଄ϝʔΧʔͷࣄྫɻࣾ಺ʹσʔ λ෼ੳ؀ڥ͕ͳ͘1P$ͱͯ͠42-JUFΛ׆༻͠ ͨσʔλ෼ੳΛ࣮ࢪɻ ("ͷσʔλΛ#JH2VFSZͰՄࢹԽ͢Δࣄྫɻ 6"͔Β("ʹҠߦ͔ͯ͠ΒৄࡉͳΞΫηε෼ ੳ΍ՄࢹԽʹ#JH2VFSZΛ׆༻ɻ   %#
#SPXTFS
GPS
42-JUF 

© 
)JLBSV
5BLBIBTIJ  42-Λ׆༻ͨͭ͠ͷσʔλ෼ੳࣄྫ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ 42-Λ׆༻ͨͭ͠ͷࣄྫΛ঺հɻ42-Λ׆༻͢Δ͜ͱͰσʔλ෼ੳ؀ڥ͕ͳ͍৔߹Ͱ΋1P$ͱ͠ ͯσʔλͷ׆༻͕Ͱ͖Δɻ σʔλ෼ੳ؀ڥ͕ͳ͍ σʔλ෼ੳ؀ڥ͕͋Δ ஍ํͷ##੡଄ϝʔΧʔͷࣄྫɻࣾ಺ʹσʔ λ෼ੳ؀ڥ͕ͳ͘1P$ͱͯ͠42-JUFΛ׆༻͠ ͨσʔλ෼ੳΛ࣮ࢪɻ ("ͷσʔλΛ#JH2VFSZͰՄࢹԽ͢Δࣄྫɻ 6"͔Β("ʹҠߦ͔ͯ͠ΒৄࡉͳΞΫηε෼ ੳ΍ՄࢹԽʹ#JH2VFSZΛ׆༻ɻ   %#
#SPXTFS
GPS
42-JUF 

© 
)JLBSV
5BLBIBTIJ  ஍ํͷ##੡଄ϝʔΧʔͷࣄྫ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ஍ํͷ##੡଄ϝʔΧʔͰ1P$ͱ࣮ͯ͠ࢪͨ͠σʔλ׆༻ɻ͓٬༷͔Βड஫͕དྷͨͱ͖ʹೲظ͕Ͳ ͷ͘Β͍ʹͳΔ͔ΛσʔλΛݩʹ༧ଌͰ͖ΔΑ͏ʹ͢Δɻ എܠ ՝୊ ໨త ஍ํͷதখاۀͰͷσʔλ׆༻ࢧԉࣄྫɻՈ۩ͳͲͷ෦඼Λ࡞Δ##੡଄ϝʔΧʔɻ޻৔Ͱ ֤෦඼ͷੜ࢈ʹ՝୊͕͋Δɻ ͓٬༷͔Β੡඼։ൃͷड஫Λͨ͠ࡍʹೲظΛਖ਼֬ʹճ౴Ͱ͖͍ͯͳ͍ɻͦͷͨΊ੡඼ੜ࢈ϥΠ ϯͷܭըཱ͕ͯͮΒ͍ɻʢೲظ͔Βٯࢉͯ͠ੜ࢈ϥΠϯΛ؅ཧ͍ͨ͠ɻʣ ͓٬༷͔Βड஫͕དྷͨͱ͖ʹͲͷ͘Β͍ͷೲظʹͳΔͷ͔ΛσʔλΛݩʹ༧ଌͰ͖ΔΑ͏ʹ͠ ͍ͨɻҰ଍ඈͼʹػձֶश΍"*Λ׆༻ͨ͠धཁ༧ଌ΍γεςϜߏஙʹਐΉͷ͸Ͱ͖ͳ͍ͷͰɺ ·ͣ͸ࠓ͋ΔσʔλͰԿ͕׆༻Ͱ͖Δͷ͔ɺͲ͏׆༻Ͱ͖Δͷ͔Λ೺Ѳ͢Δ 

© 
)JLBSV
5BLBIBTIJ  σʔλΛ׆༻ͨ͠धཁ༧ଌͷεςοϓ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ࠷ॳ͔Βػցֶश΍"*Λ׆༻ͨ͠ߴ౓ͳधཁ༧ଌΛ͢ΔͷͰ͸ͳ͘ɺ·ͣ͸طଘͷσʔλΛਓ͕ղ ऍͯ͠धཁ༧ଌ͕Ͱ͖ΔΑ͏ʹ͢ΔɻͦͷͨΊʹطଘͷσʔλͰ1P$Λ࣮ࢪɻ 45&1 45&1 )PX 8IP ܦݧɾצ աڈͷσʔλ΍
౷ܭσʔλΛ༻͍ͨσʔλ෼ੳ 45&1 ػցֶश΍"*Λ׆༻ͨ͠ ࣗಈधཁ༧ଌ ਓ ਓ "* ܦݧ΍צʹґଘ͢Δҙࢥܾ ఆͩͱਖ਼֬ੑ΍εϐʔυʹ ՝୊͕͋Δ 1PJOU ·ͣ͸ਓ͕σʔλΛݟͯղऍͰ͖ΔܗͰσʔλ ׆༻Λͨ͠ํ͕ਐΊ΍͍͢ 45&1Λͱ͹͍͖ͯ͠ͳΓ 45&1͔ΒਐΊΔͱࣦഊ͠ ΍͍͢ ҙ ࢥ ܾ ఆ ํ ๏ 

© 
)JLBSV
5BLBIBTIJ  طଘͷσʔλΛ׆༻ͨ͠෼ੳ؀ڥ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ࣾ಺ʹ͸σʔλ෼ੳ؀ڥ͕ଘࡏ͠ͳ͍͕ɺجװγεςϜʹσʔλ͕͋Δঢ়گɻجװγεςϜ͔Β DTWͰݩσʔλΛ΋Β͍42-Λ࢖ͬͯ1P$Ͱσʔλ෼ੳΛ࣮ࢪɻ ͓٬༷؀ڥ ࣗࣾ؀ڥ DTWϑΝΠϧ DTWϑΝΠϧ 42-JUF DTWϑΝΠϧΛςʔϒϧͱͯ͠Πϯϙʔτ %8)ͳͲ͕ଘࡏ͠ͳ͍؀ڥ
جװγεςϜʹ੡඼৘ใ΍ड஫৘ใͳͲ͕อଘ͞Ε͍ͯΔ
جװγεςϜ͔Βσʔλ͸DTWग़ྗ͕Մೳ ͓٬༷͔ΒDTWͰ֤छ৘ใΛ΋Β͏
΋ΒͬͨDTWσʔλΛϩʔΧϧ؀ڥͷ42-JUFʹςʔϒϧͱ ͯ͠σʔλΛΠϯϙʔτ
42-Λ࢖ͬͯσʔλ෼ੳΛ࣮ࢪ جװγεςϜ
ʢ42-
4FSWFSʣ 

© 
)JLBSV
5BLBIBTIJ  ͳͥ42-Λ࢖ͬͨσʔλ෼ੳΛͨ͠ͷ͔ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ σʔλ͕׆༻Ͱ͖Δ͔Λ֬ೝ͢Δ1P$ͷͨΊɺͦͷͨΊʹ෼ੳ؀ڥΛಋೖ͢Δͷ͸අ༻ରޮՌ͕ѱ ͍ɻ&YDFMͰ͸େྔͷσʔλूܭ΍ෳ਺ͷσʔλΛ݁߹͢Δͷʹ޲͍ͯͳ͍ͨΊ42-Λ׆༻ɻ ෼ ੳ ͷ ෯ ͕ ڱ ͍ ෼ ੳ ͷ ෯ ͕ ޿ ͍ ಋೖίετ͕௿͍ ಋೖίετ͕ߴ͍ 42- େྔͷσʔλΛߴ଎ʹѻ͏ ͜ͱ͕Ͱ͖Δɻ42-JUFͰ͋ Ε͹1$ʹΞϓϦέʔγϣϯ ΛΠϯετʔϧ͢Δ͚ͩͰ ؀ڥߏங͕Ͱ͖Δ %8)ͳͲͷσʔλ෼ੳ؀ڥΛ ಋೖ͢Δ͜ͱͰ༷ʑͳ෼ੳ͕Մ ೳɻͨͩ͠ಋೖ͢Δͷʹίετ ΍͕͔͔࣌ؒͬͯ͠·͏ ୭Ͱ΋ѻ͍΍͘͢σʔλ෼ੳ Ͱ΋׆༻Ͱ͖Δ͕ɺѻ͑Δσ ʔλͷྔʹݶք͕͋Γෳࡶͳ ෼ੳ͕͠ʹ͍͘ &YDFM ෼ੳ؀ڥಋೖ 

© 
)JLBSV
5BLBIBTIJ  σʔλ෼ੳͰ׆༻͢Δςʔϒϧ৘ใ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ෼ੳʹ׆༻͢Δσʔλ͸େ͖ͭ͘ɻʮग़ՙσʔλʯʹ͓٬༷͔Βड஫ͨ͠੡඼ผͷσʔλ͕ೖͬ ͓ͯΓɺͦΕΛݩʹड஫͔Βग़ՙ·Ͱͷ೔਺Λ෼ੳ͢Δɻ ग़ՙσʔλ  ఻ථ൪߸  ड஫೔  ग़ՙ೔  ண೔  ੜ࢈։࢝༧ఆ  ੡඼ίʔυ  ஫จ਺  ੜ࢈਺  ୯Ձ ੡඼σʔλ  ੡඼ίʔυ  ੡඼໊  ΧςΰϦ ޻ఔ؅ཧσʔλ  ఻ථ൪߸  ޻ఔίʔυ  ੜ࢈։࢝೔  ੜ࢈׬ྃ೔ ޻ఔ໊σʔλ  ޻ఔίʔυ  ޻ఔ໊ 

© 
)JLBSV
5BLBIBTIJ  ۩ମతͳσʔλྫ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ σʔλ͸೥͔Β೥·Ͱͷ໿೥ؒ෼ͷσʔλΛ׆༻ɻςʔϒϧͷϨίʔυ਺ʢߦ਺ʣ ͸࠷େͰສϨίʔυɻ ఻ථ൪ ड஫೔ ग़ՙ೔ ண೔ ੜ࢈։࢝༧ఆ೔ ੡඼ίʔυ ஫จ਺ ੜ࢈਺ ୯Ձ                                                       ੡඼ίʔυ ੡඼໊ ΧςΰϦ  ϕχΞ൘
" ϕχΞ൘  ϕχΞ൘
# ϕχΞ൘  ϕχΞ൘
$ ϕχΞ൘  γϟολʔ
" γϟολʔ  γϟολʔ
# γϟολʔ  γϟολʔ
$ γϟολʔ ఻ථ൪ ޻ఔίʔυ ੜ࢈։࢝೔ ੜ࢈׬ྃ೔                         ޻ఔίʔυ ޻ఔ໊  ઀ண"  ઀ண#  ઀ண$  Χοτ"  Χοτ#  Χοτ$ ໿ສϨίʔυ ޻ఔ؅ཧσʔλ ޻ఔ໊σʔλ ੡඼σʔλ ظؒɿ೥ʙ೥ ग़ՙσʔλ ໿ສϨίʔυ ໿Ϩίʔυ ໿ສϨίʔυ 

© 
)JLBSV
5BLBIBTIJ  42-Λ࢖ͬͨσʔλ෼ੳ֓ཁ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ࠓճ͸1P$ͱͯ͠42-JUFΛ࢖ͬͯσʔλ෼ੳΛ࣮ࢪɻ42-Λ࢖͏͜ͱͰ༷ʑͳ৚݅Ͱඞཁͳ৘ใ Λૉૣ͘औಘ͢Δ͜ͱ͕Ͱ͖ΔͨΊɺ1P$ͱͯ͠͸ඇৗʹศརɻ ໨త ͓٬༷͔Βड஫͕དྷͨͱ͖ʹͲͷ͘Β͍ͷೲظʹ ͳΔͷ͔ΛσʔλΛݩʹ༧ଌͰ͖ΔΑ͏ʹͨ͠ ͍ɻ ෼ੳ֓ཁ ख๏ 42-ʢ42-JUFʣΛ࢖ͬͨσʔλ෼ੳ Ξ΢τϓοτ ݄ผͷച্ɺड஫݅਺
੡඼ผฏۉೲظ
࣌ظผฏۉೲظ %#
#SPXTFS
GPS
42-JUF 42-Λ࢖ͬͨ෼ੳ؀ڥ ܰͯ͘଎͍σʔλϕʔε
αʔόʔ͕ͳͯ͘΋%#Λߏங Ͱ͖Δ ΞϓϦέʔγϣϯͱ͠ ͯ૊ΈࠐΊΔ 42-JUFΛ࣮ߦ͢ΔͨΊͷ42- ΫϥΠΞϯτ
1$ʹΠϯετʔϧ͢Δ͚ͩͰ 42-JUFΛ࣮ߦ͢Δ؀ڥ͕ߏங Ͱ͖Δ طଘσʔλ͔Βͷೲ ظͷ܏޲Λ೺Ѳ 

© 
)JLBSV
5BLBIBTIJ  ࣮ࡍͷ෼ੳྫʢᶃ݄ผͷച্ूܭʣ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ड஫σʔλΛݩʹͯ͠஫จ೔෇͔Β݄৘ใʹม׵͢Δ͜ͱͰάϧʔϐϯά݄ͯ͠୯ҐͰͷड஫਺Λ औಘ͢Δ͜ͱ͕Ͱ͖Δɻ 42- ࣮ߦ݁Ռ select substr(ड஫೔, 1, 7) as ݄, count(distinct ఻ථ൪߸) as ड஫਺, sum(஫จ਺ * ୯Ձ) as ച্ from order_data group by substr(ड஫೔, 1, 7) order by substr(ड஫೔, 1, 7) ച্͸஫จ਺º୯ՁͰܭࢉ
݄ͷ৘ใ͸ड஫೔Λจࣈྻͱͯ͠ѻ͍จࣈ໨͔Βจࣈ໨· ͰΛ੾ΓऔΔ͜ͱͰ݄৘ใͱͯ͠ѻ͏ ݄ ड஫਺ ച্                   ݄ผʹड஫਺ͱച্͕ग़ྗ͞ΕΔ Ξ΢τϓοτΠϝʔδ 

© 
)JLBSV
5BLBIBTIJ  ࣮ࡍͷ෼ੳྫʢᶄ੡඼ผͷฏۉೲظʣ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ड஫σʔλΛݩʹͯ͠ग़ՙ೔ͱड஫೔ͷࠩ෼ΛͱΔ͜ͱͰೲظ͕ܭࢉͰ͖Δɻ֤ड஫୯Ґͷೲظ͕ ෼͔Ε͹ͦΕΒͷฏۉ΍࠷େ஋ɺ࠷খ஋ͳͲͷ਺஋Λ֬ೝ͢Δ͜ͱ͕Ͱ͖Δɻ 42- ࣮ߦ݁Ռ Ξ΢τϓοτΠϝʔδ with order_data as ( select ੡඼໊, cast(julianday(ग़ՙ೔_2) as int) - cast(julianday(ड஫೔_2) as int) as ೲظ from order_processing ord left join product_processing prod on ord.੡඼ίʔυ = prod.੡඼ίʔυ left join ޻ఔ৘ใ proinfo on ord.఻ථ൪߸ = proinfo.఻ථ൪߸ where ord.఻ථ൪߸ is not null ) select ੡඼໊, avg(ೲظ) from order_data group by ੡඼໊ ೲظ͸ग़ՙ೔ͱड஫೔ͷࠩ෼Ͱܭࢉ͢Δ
ྫɿ݄೔ʹड஫ɺ݄೔ʹग़ՙͷ৔߹ͷೲظ͸೔
8*5)۟Λ࢖ͬͯड஫͝ͱͷೲظΛܭࢉ͠ɺͦͷσʔλΛ΋ͱ ʹͯ͠ೲظͷฏۉ஋Λऔಘ ੡඼໊ ೲظ ϕχΞ൘
"  ϕχΞ൘
"  γϟολʔ
"  γϟολʔ
"  ੡඼໊ ฏۉೲظ ϕχΞ൘
"  γϟολʔ
"  ड ஫ ͝ ͱ ͷ ೲ ظ ੡ ඼ ผ ͷ ฏ ۉ ೲ ظ ड஫͝ͱͷೲظΛܭࢉ͠ɺͦͷ݁ՌΛ΋ͱʹͯ͠੡඼ผͷೲظ ͷฏۉ஋͕ग़ྗ͞ΕΔ 

© 
)JLBSV
5BLBIBTIJ  ෼ੳޙͷωΫετΞΫγϣϯ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ࠓճͷσʔλ෼ੳʹΑͬͯɺطଘͷσʔλΛ׆༻ͯ͠ࠓ·Ͱ҉໧஌ͱ͞Ε͍ͯͨσʔλ͕ՄࢹԽͰ ͖ͨɻࠓޙ͸ۀ຿վળ΋ؚΊͯఆৗతʹσʔλ͕ݟΕΔΑ͏ͳ#*؀ڥͷಋೖ΋ؚΊͯݕ౼ɻ ࠓ·Ͱݟ͑ͳ͔ͬͨσʔλ͕ՄࢹԽ͞Εͯݟ͑ΔΑ͏ʹͳͬͨ
੡඼ผͷೲظ΍࣌ظผͷೲظΛݟΔ͜ͱͰɺաڈͷ࣮੷͔Βࠓޙͷೲظ༧ଌʹ ׆༻Ͱ͖ͦ͏ͳ͜ͱ͕Θ͔ͬͨ ࠓճͷ෼ੳͰ
ಘΒΕͨ͜ͱ σʔλΛ׆༻ͯ͠ద੾ͳೲظΛ͓٬༷ʹ఻͑ΒΕΔΑ͏ʹۀ຿ϑϩʔΛվળ
ܧଓతʹσʔλΛՄࢹԽ͢ΔͨΊʹ#*πʔϧͷಋೖͳͲΛݕ౼ ωΫετ
ΞΫγϣϯ 

© 
)JLBSV
5BLBIBTIJ  ຊࣄྫ͔Βͷ஌ݟʢ42-Λ࢖ͬͨ෼ੳͷϝϦοτʣ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ 42-Λ࢖͏͜ͱͰσʔλ෼ੳ؀ڥ͕ͳ͔ͬͨͱͯ͠΋γϯϓϧ͔ͭεϐʔσΟʔʹσʔλ෼ੳ͕Մ ೳɻίετΛ͔͚ͣʹσʔλͷ׆༻͕Ͱ͖Δ͔Ͳ͏͔Λݕূ͢Δ͜ͱ͕Ͱ͖Δɻ γϯϓϧ TJNQMF جຊूܭʢ߹ܭɾฏۉɾ೔ผूܭɾސ ٬ผूܭɾ੡඼ผूܭʣͳͲγϯϓϧ ͳσʔλूܭͰ͋Ε͹جຊతͳ42-ͷ ׆༻ʹ޲͍ͯΔɻ εϐʔσΟʔ TQFFEZ େྔͷσʔλΛඞཁͳλΠϛ ϯάͰૉૣ͘औಘ͢ΔͨΊ ʹɺίετΛ͔͚ͣʹ୹ظؒ Ͱࢼߦࡨޡ͕Ͱ͖Δɻ 42- 42-Λ࢖͑͹جຊूܭ͸ૉૣ͘؆୯ʹऔಘ͢Δ͜ͱ͕Ͱ͖Δ
&YDFMͰ͸ѻ͍ͮΒ͍େྔͷσʔλ΋42-ͳΒૉૣ͘ѻ͏͜ͱ͕Ͱ͖Δ 

© 
)JLBSV
5BLBIBTIJ  42-Λ׆༻ͨͭ͠ͷσʔλ෼ੳࣄྫ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ 42-Λ׆༻ͨͭ͠ͷࣄྫΛ঺հɻ42-Λ׆༻͢Δ͜ͱͰσʔλ෼ੳ؀ڥ͕ͳ͍৔߹Ͱ΋1P$ͱ͠ ͯσʔλͷ׆༻͕Ͱ͖Δɻ σʔλ෼ੳ؀ڥ͕ͳ͍ σʔλ෼ੳ؀ڥ͕͋Δ ஍ํͷ##੡଄ϝʔΧʔͷࣄྫɻࣾ಺ʹσʔ λ෼ੳ؀ڥ͕ͳ͘1P$ͱͯ͠42-JUFΛ׆༻͠ ͨσʔλ෼ੳΛ࣮ࢪɻ ("ͷσʔλΛ#JH2VFSZͰՄࢹԽ͢Δࣄྫɻ 6"͔Β("ʹҠߦ͔ͯ͠ΒৄࡉͳΞΫηε෼ ੳ΍ՄࢹԽʹ#JH2VFSZΛ׆༻ɻ   %#
#SPXTFS
GPS
42-JUF 

© 
)JLBSV
5BLBIBTIJ  ("ͷΞΫηεσʔλΛ෼ੳ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ("ͷσʔλΛ༷ʑͳ੾ΓޱͰ෼ੳͨ͠Γ#*ͰՄࢹԽ͢Δέʔεɻʢ˞Ұൠతͳࣄྫʣ("ʹͳ͔ͬͯ Βσʔλͷѻ͍͕ҎલͱมΘΓɺ42-Λ࢖ͬͨूܭ͕ඞཁʹͳΔέʔε΋૿͑ͨɻ എܠ ՝୊ ໨త (PPHMF
"OBMZUJDT͕6"ʢϢχόʔαϧΞφϦςΟΫεʣ͔Β("ʹҠߦ͠ɺࠓ·Ͱͷσʔ λߏ଄͕มΘΓ("ͷ࢖͍ํ΋มԽͨ͠ɻ ("ʹҠߦΛ͔ͯ͠ΒΞΫηεσʔλΛ#*ͰՄࢹԽΛ͍ͨ͠ɻʢ˞("ͷσʔλΛ#*ͰՄࢹ Խ͢Δ#*༻ͷίωΫλ͕༻ҙ͞Ε͍ͯͳ͍ɺ·ͨ͸༻ҙ͞Ε͍ͯͯ΋ෆ҆ఆͳ৔߹͕͋Δʣ ("ͱ#JH2VFSZΛ࿈ܞͤͯ͞#JH2VFSZܦ༝Ͱ42-Λ࢖ͬͯΞΫηεσʔλΛ෼ੳɾՄࢹ Խ͢Δɻ 

© 
)JLBSV
5BLBIBTIJ  ʢࢀߟʣ("ͱ6"ͷҧ͍ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ೥݄͔Βैདྷͷ("ʢ6"ɿϢχόʔαϧΞφϦςΟΫεʣ͔Β৽͍͠("ʢ("ʣͷར༻͕ ඞਢʹͳͬͨɻ6"ͱ("Ͱ͸σʔλͷߏ଄ͳͲ͕มΘ͍ͬͯΔɻ ࢀߟɿIUUQTQBOUPHSBQIDPKQCMPHTFPIPXUPSFBEHBIUNM ߲໨ 6" (" ଌఆํ๏ ηογϣϯΛத৺ͱ ͨ͠ܭଌ ΠϕϯτΛத৺ͱ͠ ͨܭଌ ෼ੳ֓ཁͷҧ͍ ΫϩεϓϥοτϑΥʔϜରԠ ΢Σϒ ΞϓϦ 'JSFCBTF 6" (" ΢Σϒ ΞϓϦ ैདྷͷηογϣϯΛத৺ʹͨ͠ܭଌํ๏͔ΒΠϕϯτΛத৺ʹ͠ ͨܭଌํ๏ʹมԽ ΢ΣϒͱΞϓϦͰผʑʹܭଌ͍ͯͨ͠΋ͷΛ("͔Β΢Σϒͱ ΞϓϦΛԣஅͯ͠ूܭ͢Δ͜ͱ͕Մೳ 

© 
)JLBSV
5BLBIBTIJ  ("Λ࢖ͬͨσʔλ෼ੳΠϝʔδ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ("ʹͳ͔ͬͯΒΞΫηεσʔλΛແྉͰ#JH2VFSZʹ࿈ܞ͕Ͱ͖ΔΑ͏ʹͳͬͨɻ #JH2VFSZ͔ Β42-Λ࢖ͬͯΞΫηεσʔλΛऔಘͰ͖ΔΑ͏ʹͳΓɺ#*πʔϧͱͷ࿈ܞ΋Մೳɻ (" #*πʔϧ %8) #JH2VFSZΛ࢖͏͜ͱͰ#* πʔϧͱͷ઀ଓ͕ՄೳʹͳΓ 42-Λ࢖ͬͯऔಘͨ͠σʔλ Λ#*ͰՄࢹԽͰ͖Δɻ ʢ˞1PXFS
#*ʹ͸("ͷઐ༻ίωΫ λ͕ͳ͍ͨΊՄࢹԽ͢ΔͨΊʹ͸ #JH2VFSZͷར༻͕ඞਢʹͳΔʣ ΞΫηεσʔλ %BUB
8BSFIPVTF 42-Λ࢖ͬͯ(" ͷΞΫηεσʔλ ΛऔಘͰ͖Δ 42- ࣮ߦ݁Ռ 42- ࣮ߦ݁Ռ 

© 
)JLBSV
5BLBIBTIJ  ("σʔλΛ׆༻࣮ͨ͠ࡍͷσʔλΠϝʔδ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ("ͷσʔλΛ#JH2VFSZʹ࿈ܞ͢Δͱ೔࣍ͰΞΫηεσʔλ͕஝ੵ͞ΕΔɻ#JH2VFSZ͸௨ৗͷ 3%#.ͱҧ͍ςʔϒϧʹ഑ྻΛ࣋ͯΔߏ଄ʹͳ͍ͬͯΔͷ͕ಛ௃ɻ ςʔϒϧεΩʔϚྫ ࣮ࡍͷσʔλྫ FWFOU@EBUF FWFOU@UJNFTUBNQ FWFOU@OBNF FWFOU@QBSBNTLFZ FWFOU@QBSBNTWBM VF   TFTTJPO@TUBSU HB@TFTTJPO@OVNCFS OVMM MJOL@VSM IUUQTGPSNTHMF $',V+$D(+&X7" HB@TFTTJPO@JE OVMM QBHF@UJUMF σʔλ෼ੳΛߴΊΔ42- ݚमʰ42-
&WFSZPOFʱ MJOL@EPNBJO GPSNTHMF   DMJDL HB@TFTTJPO@OVNCFS OVMM ͭͷΧϥϜʹLFZͱWBMVFͱ͍͏ܗͰෳ਺ͷ৘ใΛอ࣋͢ Δ͜ͱ͕Ͱ͖Δɻ Ϩίʔυʹෳ਺ͷ৘ใ͕อଘ͞ΕΔ 

© 
)JLBSV
5BLBIBTIJ  #JH2VFSZΛ࢖ͬͨ෼ੳྫʢ೔ผͷ17ɾ66ʣ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ #JH2VFSZͷπʔϧ্Ͱ42-Λ࣮ߦ͢Δ͜ͱͰɺ("ͷΞΫηεσʔλΛ͞·͟·ͳ੾ΓޱͰूܭ͢ Δ͜ͱ͕Ͱ͖Δɻ("্Ͱ͸ݟ͑ͳ͍σʔλ΋42-Λ࢖͏͜ͱͰՄࢹԽͰ͖Δɻ 42- ࣮ߦ݁Ռ Ξ΢τϓοτΠϝʔδ ("͔Β࿈ܞ͞Ε͍ͯΔΞΫηεσʔλΛςʔϒϧͱͯ͠ࢦఆ
17Λऔಘ͢Δ৔߹͸FWFOU@OBNFbQBHF@WJFX`Λࢦఆ
FWFOU@EBUFͰ(3061
#:͢Δ͜ͱͰ೔ผͷ17΍66Λूܭ
Ϣʔβʔ਺ͷूܭ͸VTFS@QTFVEP@JEΛ࢖͏ #JH2VFSZͷίϯιʔϧ্Ͱ೔ผͷ 17ͱ66͕ूܭ͞ΕΔ select event_date as date, count(*) as pv, count(distinct user_pseudo_id) as uu from `sql-everyone.analytics_XXXXXXXXX.events_*` where event_name = 'page_view' group by event_date order by date EBUF QW VV                   

© 
)JLBSV
5BLBIBTIJ  #JH2VFSZΛ࢖ͬͨ෼ੳྫʢϦϯΫΫϦοΫʣ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ ("ͱ#JH2VFSZͰ͸ϦϯΫͷΫϦοΫΠϕϯτ΋σϑΥϧτͰऔಘՄೳɻߏ଄Խ͞Εͨෳࡶͳ σʔλ΋42-Λ࢖͏͜ͱͰ#JH2VFSZ͔Β("ͷΞΫηεσʔλΛऔಘͰ͖Δɻ 42- ࣮ߦ݁Ռ Ξ΢τϓοτΠϝʔδ VOOFTUΛ࢖ͬͯߏ଄Խ͞ΕͨσʔλΛల։
MJOL@VSMΛࢦఆͯ͠ಛఆͷϦϯΫ΁ͷΫϦοΫ਺Λूܭ select event_date as date, count(*) as click_count, count(distinct user_pseudo_id) as click_uu from `sql-everyone.analytics_247690258.events_*` where event_name = 'click' -- ໰͍߹ΘͤϦϯΫϦοΫ and ( select value.string_value from unnest(event_params) where key = 'link_url' ) = 'https://forms.gle/CFKuJCcG81J5EwVA6' group by event_date order by date EBUF DMJDL@DPVOU DMJDL@VV                   #JH2VFSZͷίϯιʔϧ্Ͱ೔ผͷΫ ϦοΫ਺ͱΫϦοΫ66͕ूܭ͞ΕΔ 

© 
)JLBSV
5BLBIBTIJ  ຊࣄྫ͔Βͷ஌ݟʢ42-Λ࢖ͬͨ෼ੳͷϝϦοτʣ 42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ #JH2VFSZͱ42-Λ࢖͏͜ͱͰ("͚ͩͰ͸ूܭͣ͠Β͍σʔλ΋ࣗ༝౓ߴ͘ݟΔ͜ͱ͕Ͱ͖Δɻ ·ͨ#*πʔϧͱͷ࿈ܞ΋#JH2VFSZΛ࢖͏͜ͱͰࣗ༝౓ߴ͘Ͱ͖Δɻ #*πʔϧͱ࿈ܞՄೳ 1PXFS
#*ͳͲ("ͱͷ઀ଓίωΫλ͕༻ҙ͞Ε͍ͯͳ ͍#*ͰՄࢹԽΛ͢Δ৔߹͸#JH2VFSZͷར༻͕ඞਢʹͳ Δ৔߹͕͋Δ
#JH2VFSZͱ42-Λ࢖͏͜ͱͰಛఆͷ#*ʹґଘͤͣɺෳ ਺ͷσʔλιʔεͱ݁߹ͯ͠৘ใΛՄࢹԽͰ͖Δ ࣗ༝౓ߴ͘σʔλͷऔಘ͕Մೳ طଘͷ("ͩͱݟΕΔσʔλ͕ݶఆత͕ͩɺ#JH2VFSZ ͱ42-Λ࢖͏͜ͱͰΑΓࡉ͔͘ΞΫηεσʔλΛ෼ੳ͢ Δ͜ͱ͕Ͱ͖Δ
σʔλͷϑΟϧλϦϯά΍ෳࡶͳΫΤϦͷ࣮ߦ΋༰қͳ ͷͰ۩ମతͳϏδωεΠϯαΠτΛಘΔ͜ͱ͕Ͱ͖Δ 42- ࣮ߦ݁Ռ 42- ࣮ߦ݁Ռ (" 

© 
)JLBSV
5BLBIBTIJ  ΞδΣϯμ "HFOEB ࣗݾ঺հ
σʔλ෼ੳͰ࢖͏42-ͷجૅ
42-Λ׆༻ͨ͠σʔλ෼ੳࣄྫʢͭʣ
σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ
2"

Ξϯέʔτ     SQL Everyone  

© 
)JLBSV
5BLBIBTIJ  σʔλ෼ੳྗΛߴΊΔݚमʰ42-
&WFSZPOFʱ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ IUUQTEBUBBOBMZUJDTUPPMDPNTRM@FWFSZPOF 

© 
)JLBSV
5BLBIBTIJ  σʔλ෼ੳʹ͓͚Δ42-ͷඞཁੑ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ σʔλ෼ੳ؀ڥʹ͓͍ͯطଘͷσʔλϕʔεʢ%8)ʣ͔ΒσʔλΛऔಘ͢Δ৔߹΍ɺ#*Λ࢖ͬͯ σʔλΛՄࢹԽ͢Δ৔߹ͳͲɺσʔλ෼ੳʹ͓͍ͯ42-ͷ׆༻͸ඞਢʹͳΔɻ 5BCMFBV 1PXFS
#* -PPLFS
4UVEJP %0.0 2MJDL
4FOTF (PPHMF
#JH2VFSZ "NB[PO
3FETIJGU 3FEBTI 4OPX fl BLF "[VSF
4ZOBQTF
"OBMZUJDT %#
#SPXTFS
GPS
42-JUF %#FBWFS %#
1JMPU 4FRVFM
1SP .Z42-
8PSLCFODI .Z42- 1PTUHSF42- 0SBDMF 42-JUF %VDL%# #* 42-
$MJFOU %8) %BUBCBTF 42- 42- 42- 

© 
)JLBSV
5BLBIBTIJ  42-ݚमʢ42-
&WFSZPOFʣͷ಺༰ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ σʔλ෼ੳʹඞཁͳ42-Λجૅ͔ΒֶͿɻσʔλ෼ੳʹඞཁͳ42-͸ΤϯδχΞ͕ΞϓϦέʔ γϣϯ։ൃͰ࢖͏42-ΑΓ΋ֶश೉қ౓͕௿͘جૅֶशͰ࣮ફ·Ͱ࢖͑ΔεΩϧ͕ಘΒΕΔɻ 4&-&$5 -*.*5 03%&3
#: (3061
#: %*45*/$5 8)&3& )"7*/( +0*/ 6/*0/ $"4& 8*5) σʔλ෼ੳʹඞཁͳ42-ͷجૅΛֶश
θϩϕʔεͰͷֶशͳͷͰࣄલ஌ࣝෆཁͰඇΤϯδχΞͰ΋ֶशՄೳ $06/5 

© 
)JLBSV
5BLBIBTIJ  42-ݚमʢ42-
&WFSZPOFʣͷର৅اۀʢର৅ऀʣ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ σʔλ෼ੳ૊৫͕͋Δاۀ͸΋ͪΖΜɺ͜Ε͔Βσʔλ෼ੳ૊৫Λ࡞Ζ͏ͱࢥ͍ͬͯΔاۀͳͲશ ͯͷϏδωεύʔιϯ͕ର৅ɻ ͳͲͳͲ ର৅اۀ ର৅ऀ σʔλ෼ੳ૊৫͸͋Δ͕ɺ42-Λ࢖͑Δਓࡐͷҭ੒͕Ͱ͖͍ͯͳ͍اۀ
͜Ε͔Βσʔλ෼ੳ૊৫Λ࡞Ζ͏ͱ͓ͯ͠Γɺσʔλ෼ੳਓࡐͷҭ੒͕ඞཁͳاۀ
΋ͬͱޮ཰తʹσʔλ׆༻Λݕ౼͍ͨ͠اۀɻσʔλ෼ੳΛ಺੡Խ͍ͨ͠اۀ 42-ॳֶऀʢ৽ೖࣾһɺϚʔέλʔɺӦۀɺσʔλΞφϦετɺίʔϙϨʔτʣ ˞ΤϯδχΞ͕ΞϓϦέʔγϣϯ։ൃͰ࢖͏42-Ͱ͸ͳ͘ɺ͋͘·Ͱσʔλ෼ੳͰ࢖͏42-ͷֶशΛର৅ͱ͍ͯ͠·͢ɻ 

© 
)JLBSV
5BLBIBTIJ  42-ݚमʢ42-
&WFSZPOFʣϓϥϯ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ 42-ݚमϓϥϯ͸ඪ४ϓϥϯͱΧελϚΠζϓϥϯͷύλʔϯɻඪ४ϓϥϯ͸ࣗ਎͕ग़൛ͨ͠ຊ Λڭࡐʹͨ͠ݚमɻΧελϚΠζϓϥϯ͸اۀ༷ͷ؀ڥʹ߹ΘͤͨڭࡐΛݕ౼ɻ ඪ४ϓϥϯ ΧελϚΠζϓϥϯ ର৅ 42-ॳֶऀ 42-ॳֶऀ ڭࡐ ຊ
ʢσʔλ෼ੳྗΛߴΊΔϏδωεύʔιϯͷͨΊͷ42-ೖ໳ʣ اۀ༷ͷ؀ڥʹ߹ΘͤͯΧελϚΠζ ܗࣜ ΦϯϥΠϯ

ΦϑϥΠϯ ΦϯϥΠϯ

ΦϑϥΠϯ ࣌ؒ ໿࣌ؒ
ʢ˞χʔζʹ߹Θͤͯ૿ݮՄೳʣ ཁ૬ஊ ਓ਺ ੍ݶͳ͠ ੍ݶͳ͠ ࣄޙ ϲ݄ؒͷΞϑλʔϑΥϩʔ
ʢ࠷ऴडߨޙϲ݄ؒ͸42-ʹؔ͢Δ࣭໰ʹճ౴ʣ ϲ݄ЋͷΞϑλʔϑΥϩʔ ֹۚ ສԁʙ ཁ૬ஊ ˞ֹۚʹؔͯ͠͸ʮਓࡐ։ൃࢧԉॿ੒ۚʯ΍ʮ%9ϦεΩϦϯάॿ੒ۚʯΛ׆༻ͯ͠཈͑Δ͜ͱ͕Ͱ͖Δ৔߹͕͋Γ·͢ɻ 

© 
)JLBSV
5BLBIBTIJ  42-ݚमʢ42-
&WFSZPOFʣͷֶशྫ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ 42-ͷجૅཧղ͔Βελʔτ͢ΔɻϋϯζΦϯܗࣜͰͷݚमͷͨΊ1$Ͱ42-Λ࣮ߦ͢ΔͨΊͷ؀ ڥߏஙΛߦ͏ɻͦͷޙɺઆ໌ͱԋशͰ42-Λ࣮ߦ͠ͳ͕ΒֶशΛਐΊ͍ͯ͘ɻ ˞ελϯμʔυϓϥϯͷྫɻ࣌ؒ΍ݚम಺༰ʹ͍ͭͯ΋ΧελϚΠζՄೳͰ͢ɻ 45&1 45&1 45&1 σʔλ෼ੳ͕ॏཁͳཧ༝
σʔλ෼ੳʹ͓͚Δ42-ͱ͸
42-ͷجຊతͳ֓೦ 42-֓ཁઆ໌ 42-؀ڥߏங 42-JUFΛ࢖ͬͨσʔλ෼ੳ؀ڥ
42-࣮ߦͷͨΊͷ؀ڥߏங
42-࣮ߦπʔϧͷ࢖͍ํ 42-ߏจͷཧղ 4&-&$5
-*.*5
03%&3
#:
ू໿ؔ਺
(3061
#:
%*45*/$5 8)&3&
)"7*/(
+0*/
6/*0/
$"4&
αϒΫΤϦ
8*5) ໿࣌ؒ ໿࣌ؒ ໿࣌ؒ આ໌ԋश جૅ͔Β࣮ફ·Ͱֶश 

© 
)JLBSV
5BLBIBTIJ  42-ݚमʢ42-
&WFSZPOFʣͷͭͷಛ௃ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ σʔλ෼ੳʹಛԽͨ͠42-ݚमΛϋϯζΦϯܗࣜͰ࣮ࢪɻ୯७ʹઆ໌Λฉ͚ͩ͘Ͱ͸ͳࣗ͘͝਎ͷ 1$Ͱ42-Λ࣮ߦͯ͠ΠϯϓοτͱΞ΢τϓοτΛ࣮ײ͠ͳ͕ΒֶशΛਐΊΔɻ ͨͩઆ໌Λฉ͚ͩ͘Ͱ͸ͳ͘1$Ͱ42-Λ࣮ߦͰ͖Δ؀ڥΛ༻ҙ࣮ͯ͠ࡍʹ 42-Λ࣮ߦ͠ͳ͕ΒਐΊΔɻʢ؀ڥߏங΋αϙʔτʣ ࣭ٙԠ౴ʹ౴͑ͳ͕Βෆ໌఺͕͋Ε͹ͦͷ৔ͰαϙʔτɻҰํతʹͳΒͣʹΠϯ λϥΫςΟϒʹֶशɻݚमޙͷΞϑλʔϑΥϩʔ΋࣮ࢪɻ σʔλ෼ੳʹಛԽͨ͠42-ݚमʹ͢Δ͜ͱͰ୹ظؒͰֶश͕Մೳɻߨࢣͷ࣮ ମݧΛ΋ͱʹ࣮ࡍͷσʔλ෼ੳͰ࢖͏42-ͷ5JQTͳͲ΋ࠞͥͳ͕Βֶशɻ    

© 
)JLBSV
5BLBIBTIJ  42-ݚमʢ42-
&WFSZPOFʣͷΰʔϧ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ 42-ݚमͷΰʔϧ͸࣮຿ͷσʔλ෼ੳͰ42-Λ࢖͑ΔΑ͏ʹͳΔ͜ͱɻͦͷͨΊʹϋϯζΦϯܗࣜ Ͱ࣮ࢪͯ͠ɺ࣮ࡍͷσʔλ෼ੳۀ຿Λҙࣝ͠ͳ͕ΒਐΊΔɻ·ͨܧଓతͳֶशࢧԉ΋Մೳɻ ܧଓతͳֶशʹΑ࣮ͬͯ຿ͷσʔλ෼ੳͰ42-͕࢖͑ΔΑ͏ʹͳΔ
ʢݚमऴྃޙͷ಺੡Խʹ޲͚ͨࢧԉ΋࣮ࢪՄೳʣ ຊݚमΛ௨ͯ͠ɺσʔλ෼ੳͰ࢖͏42-Λ࣮ࡍʹମײͯ͠΋Β ͍ɺ42-͸ܾͯ͠೉͘͠ͳ͍͜ͱΛཧղͯ͠΋Β͏
࣮຿ͷதͰܧଓతʹ42-Λ׆༻͢Δ͖͔͚ͬͱ͢Δ 

ʰશͯͷਓʹσʔλ෼ੳྗΛʱ SQL Everyone 

ແྉ૬ஊͷ͓໰͍߹Θͤ IUUQTGPSNTHMFXRG[G-NV/BLB[ MJHIU IUIJLBSVUBLBIBTIJ!HNBJMDPN 

&/%