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

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

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

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

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

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

© )JLBSV5BLBIBTIJ σʔλ෼ੳͰ࢖͏42-ͷಛ௃ σʔλ෼ੳͰ࢖͏42-ͷͭͷಛ௃ 42- VTFS@JE HFOEFS CJSUI " உੑ ࣮ߦ݁Ռ 4&-&$5'30.VTFST 8)&3&VTFS@JEb"` σʔλϕʔε ςʔϒϧ VTFS@JE HFOEFS CJSUI " உੑ " ঁੑ ɾɾɾ ɾɾɾ ɾɾɾ QSPEVDU@JE QSPEVDU@OBNF QSJDF # ͓͍͍͠ਫ # γϟʔϓϖϯ ɾɾɾ ɾɾɾ ɾɾɾ 42-͸ デ ʔλ ベ ʔε্ͷςʔ ブ ϧʹ֨ೲ͞Εͨ デ ʔλΛऔಘ͢Δͱ͖ʹ࢖͏ݴޠɻσʔλϕʔεͱ ͸σʔλΛ֨ೲ͢Δେ͖ͳശͰɺςʔϒϧͱ͸ߦͱྻͰߏ੒͞ΕΔσʔλͷ͔ͨ·Γɻ Ϣʔβʔ ྻ ߦ

© )JLBSV5BLBIBTIJ σʔλ෼ੳͰ࢖͏42-ͷಛ௃ σʔλ෼ੳͰ࢖͏42-ͷͭͷಛ௃ Ϗδωεύʔιϯ͕࢖͏42- ΤϯδχΞ͕࢖͏42- σʔλ෼ੳͰ͸جຊతʹ͸σʔλͷऔಘʢ4&-&$5ʣ Λ֮͑Ε͹Α͍ 42-ͷॲཧ଎౓ʹ͍ͭͯҙࣝ͢Δඞཁੑ͕௿͍ جຊతͳߏจΛ֮͑Ε͹ͣͬͱ࢖͍ଓ͚Δ͜ͱ͕Ͱ͖ Δ ΞϓϦέʔγϣϯ։ൃʹඞཁͳ42-ʢ4&-&$5ɹ */4&35%&-&5&61%"5&$3&"5&ʣΛ֮͑Δඞ ཁ͕͋Δ ϛϦඵ୯ҐͰॲཧ଎౓Λҙࣝ͢Δඞཁ͕͋ΔʢͦͷͨΊ ΠϯσοΫεͳͲͷσʔλϕʔεͷ஌ࣝ΋ඞཁʹͳΔʣ ৽͍͠42-ͷߏจΛ֮͑ͯΑΓޮ཰తͳ42-Λॻ͘ඞཁ ͕͋Δ Ϗδωεύʔιϯ͕࢖͏42-ͱΤϯδχΞ͕࢖͏42-͸ಛ௃͕ҟͳΔɻ42-͸ΤϯδχΞ͕ѻ͏೉ ͍͠ݴޠͱࢥΘΕ͕͕ͪͩɺϏδωεύʔιϯ͕σʔλ෼ੳͰ࢖͏42-͸೉͘͠ͳ͍ɻ

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

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

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

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

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

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

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

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

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

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

© )JLBSV5BLBIBTIJ ࣮ࡍͷ෼ੳྫʢᶃ݄ผͷച্ूܭʣ 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) ച্͸஫จ਺º୯ՁͰܭࢉ ݄ͷ৘ใ͸ड஫೔Λจࣈྻͱͯ͠ѻ͍จࣈ໨͔Βจࣈ໨· ͰΛ੾ΓऔΔ͜ͱͰ݄৘ใͱͯ͠ѻ͏ ݄ ड஫਺ ച্ ݄ผʹड஫਺ͱച্͕ग़ྗ͞ΕΔ Ξ΢τϓοτΠϝʔδ

© )JLBSV5BLBIBTIJ ࣮ࡍͷ෼ੳྫʢᶄ੡඼ผͷฏۉೲظʣ 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)۟Λ࢖ͬͯड஫͝ͱͷೲظΛܭࢉ͠ɺͦͷσʔλΛ΋ͱ ʹͯ͠ೲظͷฏۉ஋Λऔಘ ੡඼໊ ೲظ ϕχΞ൘" ϕχΞ൘" γϟολʔ" γϟολʔ" ੡඼໊ ฏۉೲظ ϕχΞ൘" γϟολʔ" ड ஫ ͝ ͱ ͷ ೲ ظ ੡ ඼ ผ ͷ ฏ ۉ ೲ ظ ड஫͝ͱͷೲظΛܭࢉ͠ɺͦͷ݁ՌΛ΋ͱʹͯ͠੡඼ผͷೲظ ͷฏۉ஋͕ग़ྗ͞ΕΔ

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

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

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

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

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

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

© )JLBSV5BLBIBTIJ ("σʔλΛ׆༻࣮ͨ͠ࡍͷσʔλΠϝʔδ 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ͱ͍͏ܗͰෳ਺ͷ৘ใΛอ࣋͢ Δ͜ͱ͕Ͱ͖Δɻ Ϩίʔυʹෳ਺ͷ৘ใ͕อଘ͞ΕΔ

© )JLBSV5BLBIBTIJ #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

© )JLBSV5BLBIBTIJ #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͕ूܭ͞ΕΔ

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

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

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

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

© )JLBSV5BLBIBTIJ 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

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

© )JLBSV5BLBIBTIJ 42-ݚमʢ42-&WFSZPOFʣϓϥϯ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ 42-ݚमϓϥϯ͸ඪ४ϓϥϯͱΧελϚΠζϓϥϯͷύλʔϯɻඪ४ϓϥϯ͸ࣗ਎͕ग़൛ͨ͠ຊ Λڭࡐʹͨ͠ݚमɻΧελϚΠζϓϥϯ͸اۀ༷ͷ؀ڥʹ߹ΘͤͨڭࡐΛݕ౼ɻ ඪ४ϓϥϯ ΧελϚΠζϓϥϯ ର৅ 42-ॳֶऀ 42-ॳֶऀ ڭࡐ ຊ ʢσʔλ෼ੳྗΛߴΊΔϏδωεύʔιϯͷͨΊͷ42-ೖ໳ʣ اۀ༷ͷ؀ڥʹ߹ΘͤͯΧελϚΠζ ܗࣜ ΦϯϥΠϯΦϑϥΠϯ ΦϯϥΠϯΦϑϥΠϯ ࣌ؒ ໿࣌ؒ ʢ˞χʔζʹ߹Θͤͯ૿ݮՄೳʣ ཁ૬ஊ ਓ਺ ੍ݶͳ͠ ੍ݶͳ͠ ࣄޙ ϲ݄ؒͷΞϑλʔϑΥϩʔ ʢ࠷ऴडߨޙϲ݄ؒ͸42-ʹؔ͢Δ࣭໰ʹճ౴ʣ ϲ݄ЋͷΞϑλʔϑΥϩʔ ֹۚ ສԁʙ ཁ૬ஊ ˞ֹۚʹؔͯ͠͸ʮਓࡐ։ൃࢧԉॿ੒ۚʯ΍ʮ%9ϦεΩϦϯάॿ੒ۚʯΛ׆༻ͯ͠཈͑Δ͜ͱ͕Ͱ͖Δ৔߹͕͋Γ·͢ɻ

© )JLBSV5BLBIBTIJ 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) ໿࣌ؒ ໿࣌ؒ ໿࣌ؒ આ໌ԋश جૅ͔Β࣮ફ·Ͱֶश

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

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

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

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

&/%