{"id":18546,"date":"2025-10-24T04:58:19","date_gmt":"2025-10-24T04:58:19","guid":{"rendered":"https:\/\/pokecon.jp\/job\/?p=18546"},"modified":"2025-10-24T04:58:19","modified_gmt":"2025-10-24T04:58:19","slug":"bigquery%e3%81%aesql%e3%81%84%e3%82%8d%e3%81%84%e3%82%8d-1-%e6%95%b0%e5%80%a4%e5%9e%8b-wantedly-engineer-blog","status":"publish","type":"post","link":"https:\/\/pokecon.jp\/job\/18546\/","title":{"rendered":"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog"},"content":{"rendered":"\n<br \/><img decoding=\"async\" src=\"https:\/\/www.wantedly.com\/post_articles\/1010260\/ogp_image\" \/><br \/>BigQuery\u306eSQL\u306b\u3064\u3044\u3066\u3001\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u8aad\u3093\u3060\u308a\u5b9f\u9a13\u3057\u305f\u308a\u3057\u306a\u304c\u3089\u6319\u52d5\u3092\u89e3\u304d\u660e\u304b\u3057\u3066\u3044\u3053\u3046\u3068\u601d\u3044\u307e\u3059\u3002\u7b2c1&#8230;<br \/>\n<br \/>\n<br \/><a href=\"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260\">\u5143\u306e\u8a18\u4e8b\u3092\u78ba\u8a8d\u3059\u308b <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"BigQuery\u306eSQL\u306b\u3064\u3044\u3066\u3001\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u8aad\u3093\u3060\u308a\u5b9f\u9a13\u3057\u305f\u308a\u3057\u306a\u304c\u3089\u6319\u52d5\u3092\u89e3\u304d\u660e\u304b\u3057\u3066\u3044\u3053\u3046\u3068\u601d\u3044\u307e\u3059\u3002\u7b2c1&#8230; \u5143\u306e\u8a18\u4e8b\u3092\u78ba\u8a8d\u3059\u308b","protected":false},"author":1,"featured_media":18547,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-18546","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-company-tec"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog - \u30dd\u30b1\u30b3\u30f3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog - \u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"og:description\" content=\"BigQuery\u306eSQL\u306b\u3064\u3044\u3066\u3001\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u8aad\u3093\u3060\u308a\u5b9f\u9a13\u3057\u305f\u308a\u3057\u306a\u304c\u3089\u6319\u52d5\u3092\u89e3\u304d\u660e\u304b\u3057\u3066\u3044\u3053\u3046\u3068\u601d\u3044\u307e\u3059\u3002\u7b2c1&#8230; \u5143\u306e\u8a18\u4e8b\u3092\u78ba\u8a8d\u3059\u308b\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260\" \/>\n<meta property=\"og:site_name\" content=\"\u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-24T04:58:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/1761281896_ogp_image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"info@pokecon.jp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"info@pokecon.jp\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wantedly.com\\\/companies\\\/wantedly\\\/post_articles\\\/1010260#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/18546\\\/\"},\"author\":{\"name\":\"info@pokecon.jp\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"headline\":\"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog\",\"datePublished\":\"2025-10-24T04:58:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/18546\\\/\"},\"wordCount\":9,\"image\":{\"@id\":\"https:\\\/\\\/www.wantedly.com\\\/companies\\\/wantedly\\\/post_articles\\\/1010260#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/1761281896_ogp_image.png\",\"articleSection\":[\"\u4f01\u696d\u30c6\u30c3\u30af\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/18546\\\/\",\"url\":\"https:\\\/\\\/www.wantedly.com\\\/companies\\\/wantedly\\\/post_articles\\\/1010260\",\"name\":\"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog - \u30dd\u30b1\u30b3\u30f3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wantedly.com\\\/companies\\\/wantedly\\\/post_articles\\\/1010260#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wantedly.com\\\/companies\\\/wantedly\\\/post_articles\\\/1010260#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/1761281896_ogp_image.png\",\"datePublished\":\"2025-10-24T04:58:19+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.wantedly.com\\\/companies\\\/wantedly\\\/post_articles\\\/1010260#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wantedly.com\\\/companies\\\/wantedly\\\/post_articles\\\/1010260\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/www.wantedly.com\\\/companies\\\/wantedly\\\/post_articles\\\/1010260#primaryimage\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/1761281896_ogp_image.png\",\"contentUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/1761281896_ogp_image.png\",\"width\":1200,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.wantedly.com\\\/companies\\\/wantedly\\\/post_articles\\\/1010260#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\",\"name\":\"\u30dd\u30b1\u30b3\u30f3\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\",\"name\":\"info@pokecon.jp\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"caption\":\"info@pokecon.jp\"},\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/author\\\/infopokecon-jp\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog - \u30dd\u30b1\u30b3\u30f3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260","og_locale":"ja_JP","og_type":"article","og_title":"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog - \u30dd\u30b1\u30b3\u30f3","og_description":"BigQuery\u306eSQL\u306b\u3064\u3044\u3066\u3001\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u8aad\u3093\u3060\u308a\u5b9f\u9a13\u3057\u305f\u308a\u3057\u306a\u304c\u3089\u6319\u52d5\u3092\u89e3\u304d\u660e\u304b\u3057\u3066\u3044\u3053\u3046\u3068\u601d\u3044\u307e\u3059\u3002\u7b2c1&#8230; \u5143\u306e\u8a18\u4e8b\u3092\u78ba\u8a8d\u3059\u308b","og_url":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260","og_site_name":"\u30dd\u30b1\u30b3\u30f3","article_published_time":"2025-10-24T04:58:19+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/1761281896_ogp_image.png","type":"image\/png"}],"author":"info@pokecon.jp","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"info@pokecon.jp"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260#article","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/18546\/"},"author":{"name":"info@pokecon.jp","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"headline":"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog","datePublished":"2025-10-24T04:58:19+00:00","mainEntityOfPage":{"@id":"https:\/\/pokecon.jp\/job\/18546\/"},"wordCount":9,"image":{"@id":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/1761281896_ogp_image.png","articleSection":["\u4f01\u696d\u30c6\u30c3\u30af"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/pokecon.jp\/job\/18546\/","url":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260","name":"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog - \u30dd\u30b1\u30b3\u30f3","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260#primaryimage"},"image":{"@id":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/1761281896_ogp_image.png","datePublished":"2025-10-24T04:58:19+00:00","author":{"@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"breadcrumb":{"@id":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260#primaryimage","url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/1761281896_ogp_image.png","contentUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/1761281896_ogp_image.png","width":1200,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.wantedly.com\/companies\/wantedly\/post_articles\/1010260#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/pokecon.jp\/job\/"},{"@type":"ListItem","position":2,"name":"BigQuery\u306eSQL\u3044\u308d\u3044\u308d (1) \u6570\u5024\u578b | Wantedly Engineer Blog"}]},{"@type":"WebSite","@id":"https:\/\/pokecon.jp\/job\/#website","url":"https:\/\/pokecon.jp\/job\/","name":"\u30dd\u30b1\u30b3\u30f3","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pokecon.jp\/job\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997","name":"info@pokecon.jp","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","caption":"info@pokecon.jp"},"url":"https:\/\/pokecon.jp\/job\/author\/infopokecon-jp\/"}]}},"_links":{"self":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/18546","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/comments?post=18546"}],"version-history":[{"count":1,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/18546\/revisions"}],"predecessor-version":[{"id":18548,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/18546\/revisions\/18548"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media\/18547"}],"wp:attachment":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media?parent=18546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/categories?post=18546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/tags?post=18546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}