{"id":2914,"date":"2020-06-30T18:21:20","date_gmt":"2020-06-30T09:21:20","guid":{"rendered":"http:\/\/autooffice.co.kr\/?p=2914"},"modified":"2025-09-15T18:54:44","modified_gmt":"2025-09-15T09:54:44","slug":"%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/","title":{"rendered":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc168\ub098\uc694? <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uad00\ub9ac\uc640 \ubd84\uc11d\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc9d1\ub2c8\ub2e4. <\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">QUERY\ub294 \uc5f4\ub2e8\uc704\ub85c \uc815\ub82c, \ud569\uacc4, \ud544\ud130\ub9c1\ub4f1\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud568\uc218\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \uc27d\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc, \uc5ec\ub7ec \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4, \uc785\ucd9c\uace0\ub300\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc7ac\uace0\ub97c \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud655\uc778\ud558\ub824\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc785\uace0\uc640 \ucd9c\uace0\ub97c \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub85c \uae30\ub85d\ud558\uba74, \ud53c\ubc97\ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758 \uc791\uc5c5\uc774 \ud544\uc694\ud55c\ub370 \uad00\ub9ac \uce21\uba74\uc5d0\uc11c \ubd88\ud3b8\ud568\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">QUERY\ub97c \uc774\uc6a9\ud558\uba74 \ub2e4\uc591\ud55c \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \uc2dc\ud2b8\uc5d0 \uc785\ub825\ud574\ub3c4 \ud55c\ubc88\uc5d0 \uad00\ub9ac\ud560 \uc218 \uc788\ub2e4\ub294 \uc7a5\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c, \uc608\ub97c \uc0b4\ud3b4\ubcf4\uc2dc\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\uc74c\uacfc \uac19\uc774 \ub9e4\uc785 \uc2dc\ud2b8\uc640 \ub9e4\ucd9c \uc2dc\ud2b8\ub97c \ub098\ub204\uc5b4\uc11c \uad00\ub9ac\ud558\ub294 \ud3b8\uc774 \uc9c1\uc6d0 \uc785\uc7a5\uc5d0\uc11c\ub294 \ud6e8\uc52c \ud3b8\ub9ac\ud569\ub2c8\ub2e4. \uc2dc\uc911\uc5d0 \ub098\uc640\uc788\ub294 \ubb3c\ub958\uad00\ub9ac\uc2dc\uc2a4\ud15c\ub4e4\ub3c4 \ub9e4\uc785\uacfc \ub9e4\ucd9c\uc744 \ubcc4\ub3c4\ub85c \uad00\ub9ac\ud558\uace0 \uc788\uc73c\ub2c8 \uc775\uc219\ud55c \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"2409\" height=\"1380\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-1.png\" alt=\"\ub9e4\uc785 \uc2dc\ud2b8\" class=\"wp-image-2887\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-1.png 2409w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-1-300x172.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-1-1024x587.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-1-768x440.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-1-1536x880.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-1-2048x1173.png 2048w\" sizes=\"auto, (max-width: 2409px) 100vw, 2409px\" \/><figcaption class=\"wp-element-caption\">\ub9e4\uc785 \uc2dc\ud2b8<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"437\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-5-1024x437.png\" alt=\"\ub9e4\ucd9c \uc2dc\ud2b8\" class=\"wp-image-2891\" style=\"width:862px;height:367px\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-5-1024x437.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-5-300x128.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-5-768x328.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-5-1536x655.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-5-2048x874.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\ub9e4\ucd9c \uc2dc\ud2b8<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ud53c\ubc97\ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uba74 \uac01\uac01\uc758 \uc218\ub7c9\uc758 \ud569\uacc4\ub294 \uae08\ubc29 \uad6c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub9e4\uc785 &#8211; \ub9e4\ucd9c \uc218\ub7c9 = \uc7ac\uace0 \uc218\ub7c9\uc744 \ud30c\uc545\ud558\ub824\uba74 \uc774\uc81c\ubd80\ud130 \uc2dc\uac04\uc774 \uc880 \ub4e4\uaca0\uc9c0\uc694? \ud53c\ubc97\ud14c\uc774\ube14\uc740 \ubc94\uc704\ub97c 1\uac1c\ub9cc \uc120\ud0dd\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \ud55c \uc2dc\ud2b8\uc5d0 \ub9e4\uc785\uacfc \ub9e4\ucd9c\uc744 \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uc9c0 \uc54a\uc73c\uba74, \uc7ac\uace0 \uc218\ub7c9\uc744 \ud30c\uc545\ud558\uae30\uac00 \ud798\uc774 \ub4ed\ub2c8\ub2e4. \uc608\uc804\uc5d0 \uc800\ub3c4 \ub9e4\uc785\uc740 \uc591\uc218(+)\ub85c \ub9e4\ucd9c\uc740 \uc74c\uc218(-)\ub85c \uae30\ub85d\ud574\uc11c \ud55c\ubc88\uc5d0 \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud574\uacb0\ud558\uae30\ub3c4 \ud588\uc2b5\ub2c8\ub2e4\ub9cc, QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \uad00\ub9ac\uac00 \ud3b8\ud574\uc9d1\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"829\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-6-1024x829.png\" alt=\"\ud53c\ubc97\ud14c\uc774\ube14\" class=\"wp-image-2895\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-6-1024x829.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-6-300x243.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-6-768x622.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-6-1536x1244.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-6.png 1733w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\ub9e4\uc785, \ub9e4\ucd9c \ud53c\ubc97\ud14c\uc774\ube14<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c QUERY\ub97c \uc0ac\uc6a9\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. (\ucffc\ub9ac\uc5d0 \ub300\ud55c \uad6c\uae00 \ub9c1\ud06c\ub294 <a aria-label=\"undefined (\uc0c8\ud0ed\uc73c\ub85c \uc5f4\uae30)\" href=\"https:\/\/support.google.com\/docs\/answer\/3093343?hl=ko\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"color:#ff3366\" class=\"has-inline-color\"><strong>\uc5ec\uae30<\/strong><\/span><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ucffc\ub9ac \ud568\uc218\ub294 3\uac00\uc9c0 \uc694\uc18c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<pre class=\"wp-block-verse\">=QUERY(\ub370\uc774\ud130\ubc94\uc704,\ucffc\ub9ac\ubb38,\ud5e4\ub354\ud589 \uac2f\uc218)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130 \ubc94\uc704\ub294 \ud53c\ubc97\ud14c\uc774\ube14 \ubc94\uc704\ucc98\ub7fc \uc0dd\uac01\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. \ubc94\uc704\uc5d0\uc11c \uc720\uc758\ud560 \uc810\uc740 \ucffc\ub9ac\ubb38\uc5d0\uc11c\ub294 \uc5f4 (column) \ub2e8\uc704\ub85c \uac00\uacf5\uc744 \ud558\uae30 \ub54c\ubb38\uc5d0, \ub370\uc774\ud130\uc758 \ub77c\ubca8\uc774 \uc5f4 \ub2e8\uc704\ub85c \ub4e4\uc5b4\uac00 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ub294 \ud589 \ub2e8\uc704\ub85c \ud558\ub098\uc529 \ucd94\uac00\ub418\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\uc774\uc81c \ucffc\ub9ac\ubb38\uc744 \uc4f0\uae30 \uc804\uc5d0 \uc5f4\uacfc \ub77c\ubca8\uc744 \uae30\uc5b5\ud574\ub461\ub2c8\ub2e4. \ubaa9\ud45c\ub294 \uc77c\uc790\ubcc4\ub85c \ud488\uba85\uc758 \uc7ac\uace0\ub97c \ud655\uc778\ud558\ub294 \uac83\uc774\ub2c8, \ud574\ub2f9 \uc5f4\ub9cc \uae30\uc5b5\ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>B = \uc77c\uc790<\/li>\n\n\n\n<li>F = \ud488\uba85<\/li>\n\n\n\n<li>I = \uc218\ub7c9<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"274\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-9-1024x274.png\" alt=\"\uccab\ubc88\uc9f8 \ud589\uc744 \uae30\uc5b5\" class=\"wp-image-2899\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-9-1024x274.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-9-300x80.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-9-768x205.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-9-1536x411.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-9.png 1757w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"238\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-8-1024x238.png\" alt=\"\uccab\ubc88\uc9f8 \ud589\uc744 \uae30\uc5b5\" class=\"wp-image-2898\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-8-1024x238.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-8-300x70.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-8-768x178.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-8-1536x357.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-8-2048x476.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c \uc774\ub807\uac8c \uc368\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>&#8216;\ub9e4\uc785\uae30\ub85d&#8217;!A:I \ubc94\uc704\uc5d0\uc11c B, F, I \uc5f4 \uc804\uccb4\ub97c \uc120\ud0dd\ud558\ub77c\ub294 \ucffc\ub9ac\uc785\ub2c8\ub2e4. \ubc94\uc704 \ub4a4\uc5d0 \uc27c\ud45c(,)\ub97c \ub123\uace0, \ucffc\ub9ac\ubb38\uc744 \ud070 \ub530\uc634\ud45c(&#8221; &#8220;)\ub85c \ubb36\uc5b4\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-verse\">=QUERY('\ub9e4\uc785\uae30\ub85d'!A:I,\"SELECT B,F,I\")<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\uac00 \ub098\uc624\uac8c \ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"878\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-13.png\" alt=\"\ucffc\ub9ac \uacb0\uacfc\" class=\"wp-image-2905\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-13.png 816w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-13-279x300.png 279w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-13-768x826.png 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c \ub3d9\uc77c\ud55c \ubc29\ubc95\uc73c\ub85c \ub9e4\ucd9c\uc218\ub7c9\ub3c4 \ubd88\ub7ec\uc635\ub2c8\ub2e4. \ub3d9\uc791\uc774 \uc798 \ub418\ub294\uc9c0 \uc624\ub978\ucabd\uc5d0 \ub123\uc5b4\uc11c \ud655\uc778\ud574\ubcf4\uba74 \uc88b\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<pre class=\"wp-block-verse\">=QUERY('\ub9e4\ucd9c\uae30\ub85d'!A:I,\"SELECT B,F,I\")<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"461\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-14-1024x461.png\" alt=\"\ucffc\ub9ac\uacb0\uacfc 2\" class=\"wp-image-2906\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-14-1024x461.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-14-300x135.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-14-768x346.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-14-1536x692.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-14.png 1654w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c \ub450 \ucffc\ub9ac\ub97c \ud569\uccd0\uc11c \ud45c\ud604\ud558\uba74, \ud574\ub2f9 \ub370\uc774\ud130\ub85c \ud53c\ubc97\ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc11c \ubd84\uc11d\ud560 \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\ub2e4\uc74c\uacfc \uac19\uc774 \uc911\uad04\ud638 {} \uc640 \uc138\ubbf8\ucf5c\ub860 (;) \uc73c\ub85c \ub450 \ucffc\ub9ac\ub97c \uc774\uc5b4\uc11c \ud45c\uc2dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/strong> <\/h3>\n\n\n\n<pre class=\"wp-block-verse\">={QUERY('\ub9e4\uc785\uae30\ub85d'!A:I,\"SELECT B,F,I\");QUERY('\ub9e4\ucd9c\uae30\ub85d'!A:I,\"SELECT B,F,I\")}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uacb0\uacfc\ub294 \uba3c\uc800 \uc4f4 \ub9e4\uc785\uae30\ub85d \ucffc\ub9ac\ub97c \ubd88\ub7ec\uc624\uace0, \uadf8 \uc544\ub798\uc5d0 \ub9e4\ucd9c\uae30\ub85d \ucffc\ub9ac\ub97c \ubd88\ub7ec\uc624\uac8c \ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ub294 \uc608\uc058\uac8c \ud569\uccd0\uc84c\uc9c0\ub9cc, \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ub9cc\ub4e4\uba74 \uc218\ub7c9\uc774 \ubaa8\ub450 \uc591\uc218\uc774\uae30 \ub54c\ubb38\uc5d0 \uc7ac\uace0\ub294 \ub298\uc5b4\ub098\uae30\ub9cc \ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub824\uba74 \ub9e4\ucd9c\uae30\ub85d\uc5d0\uc11c \ubd88\ub7ec\uc624\ub294 \ucd9c\uace0 \uc218\ub7c9\uc744 \ub9c8\uc774\ub108\uc2a4 (-) \ub85c \ucc98\ub9ac\ud569\ub2c8\ub2e4. \ub9e4\ucd9c \uae30\ub85d \ubd80\ubd84 \ucffc\ub9ac\uc5d0\uc11c I \ub97c I*-1\ub85c \ubc14\uafb8\ub294 \uac83\uc73c\ub85c \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-verse\">={QUERY('\ub9e4\uc785\uae30\ub85d'!A:I,\"SELECT B,F,I\");QUERY('\ub9e4\ucd9c\uae30\ub85d'!A:I,\"SELECT B,F,I*-1\")}<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"426\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-12-1024x426.png\" alt=\"\ucffc\ub9ac \uacb0\uacfc \ud1b5\ud569\" class=\"wp-image-2904\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-12-1024x426.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-12-300x125.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-12-768x320.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-12-1536x639.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-12-2048x852.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c \ub9e4\uc785\uae30\ub85d &amp; \ub9e4\ucd9c\uae30\ub85d \ucffc\ub9ac \uacb0\uacfc\uc778 Q3:S\ub85c \ud53c\ubc97\ud14c\uc774\ube14\uc744 \ub9cc\ub4ed\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"863\" height=\"883\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-16.png\" alt=\"\ucffc\ub9ac \uacb0\uacfc \ud53c\ubc97\" class=\"wp-image-2908\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-16.png 863w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-16-293x300.png 293w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-16-768x786.png 768w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">20-01-04 \uc758 \uc218\ub7c9 \ud569\uacc4\ub294 13\uc778\ub370, \ub9e4\uc785 +18, \ub9e4\ucd9c -5 \uac00 \ub354\ud574\uc9c4 \uacb0\uacfc\uc785\ub2c8\ub2e4. \ud558\ub2e8\uc758 \ucd1d\uacc4\ub97c \ubcf4\uba74 \ud604 \uc2dc\uc810\uc5d0\uc11c\uc758 \uc7ac\uace0\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. (\ub354\ubbf8 \ub370\uc774\ud130\ub85c 20\ub144\ub9d0\uae4c\uc9c0 \ub4e4\uc5b4 \uc788\uc5b4\uc11c \ub098\uc624\ub294 \uacb0\uacfc\uc785\ub2c8\ub2e4. \uc2dc\uc810 \uc7ac\uace0\ub97c \ubcf4\uace0 \uc2f6\ub2e4\uba74, \ud53c\ubc97\ud14c\uc774\ube14 \ud544\ud130\ub97c \uc801\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"38\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-17-1024x38.png\" alt=\"\ud569\uc0b0 \uadfc\uac70\" class=\"wp-image-2909\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-17-1024x38.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-17-300x11.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-17-768x29.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-17-1536x57.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-17.png 1604w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"> QUERY \ud568\uc218\ub85c \ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud55c \ubaa8\uc591\ub3c4 \ub9cc\ub4e4 \uc218 \uc788\uc9c0\ub9cc, QUERY \ub97c \ud53c\ubc97\ud14c\uc774\ube14\uc744 \uc704\ud55c \uae30\ucd08 \ub370\uc774\ud130 \ud544\ud130\ub9c1\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \ud3b8\uc774 \uc0ac\uc6a9\uc131 \uba74\uc5d0\uc11c \uc88b\uc740 \uac83 \uac19\uc2b5\ub2c8\ub2e4.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \ud568\uc218\uc758 \uac00\uc7a5 \uae30\ucd08\ub97c \uc0b4\ud3b4\ubcf4\uc558\ub294\ub370, \ucffc\ub9ac\ubb38\uc744 \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud558\ub294\uc9c0\uc5d0 \ub530\ub77c \ub2e4\uc591\ud55c \ubcc0\ud615\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">\uc624\ub298 \uc0b4\ud3b4\ubcf8 \ucffc\ub9ac \uc0d8\ud50c\uc744 \uc0b4\ud3b4\ubcf4\uc138\uc694. PC\ub97c \uad8c\uc7a5\ub4dc\ub9bd\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"gb-button-wrapper gb-button-wrapper-002c2c74\">\n\n<a class=\"gb-button gb-button-1a3349b5 button\" href=\"https:\/\/vo.la\/L6rn\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"button-text\">\uc0d8\ud50c \ubcf4\uae30<\/span><\/a>\n\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"512\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png\" alt=\"\" class=\"wp-image-17075\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSc-FiMM9foF0jEAWqL7IePJTEdQ0X9asQTENOIv_3mltyq2zg\/viewform?pli=1\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc168\ub098\uc694? QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uad00\ub9ac\uc640 \ubd84\uc11d\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc9d1\ub2c8\ub2e4. QUERY\ub294 \uc5f4\ub2e8\uc704\ub85c \uc815\ub82c, \ud569\uacc4, \ud544\ud130\ub9c1\ub4f1\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud568\uc218\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \uc27d\uc2b5\ub2c8\ub2e4. \ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc, \uc5ec\ub7ec \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc785\ucd9c\uace0\ub300\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc7ac\uace0\ub97c \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud655\uc778\ud558\ub824\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc785\uace0\uc640 \ucd9c\uace0\ub97c \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub85c \uae30\ub85d\ud558\uba74, \ud53c\ubc97\ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2904,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[5],"tags":[15,18,13,14,17,16],"class_list":["post-2914","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","tag-query","tag-18","tag-13","tag-14","tag-17","tag-16"],"translation":{"provider":"WPGlobus","version":"3.0.5","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc168\ub098\uc694? QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uad00\ub9ac\uc640 \ubd84\uc11d\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc9d1\ub2c8\ub2e4. QUERY\ub294 \uc5f4\ub2e8\uc704\ub85c \uc815\ub82c, \ud569\uacc4, \ud544\ud130\ub9c1\ub4f1\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud568\uc218\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \uc27d\uc2b5\ub2c8\ub2e4. \ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc, \uc5ec\ub7ec \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc785\ucd9c\uace0\ub300\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc7ac\uace0\ub97c \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud655\uc778\ud558\ub824\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc785\uace0\uc640 \ucd9c\uace0\ub97c \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub85c \uae30\ub85d\ud558\uba74, \ud53c\ubc97\ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"autooffice\"\/>\n\t<meta name=\"keywords\" content=\"query,\ubd84\uc11d,\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8,\ucffc\ub9ac,\ud1b5\uacc4,\ud53c\ubc97\ud14c\uc774\ube14\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY - Tech Blog of autooffice\" \/>\n\t\t<meta property=\"og:description\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc168\ub098\uc694? QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uad00\ub9ac\uc640 \ubd84\uc11d\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc9d1\ub2c8\ub2e4. QUERY\ub294 \uc5f4\ub2e8\uc704\ub85c \uc815\ub82c, \ud569\uacc4, \ud544\ud130\ub9c1\ub4f1\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud568\uc218\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \uc27d\uc2b5\ub2c8\ub2e4. \ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc, \uc5ec\ub7ec \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc785\ucd9c\uace0\ub300\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc7ac\uace0\ub97c \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud655\uc778\ud558\ub824\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc785\uace0\uc640 \ucd9c\uace0\ub97c \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub85c \uae30\ub85d\ud558\uba74, \ud53c\ubc97\ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t\t<meta property=\"og:image:height\" content=\"210\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-06-30T09:21:20+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-09-15T09:54:44+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY - Tech Blog of autooffice\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc168\ub098\uc694? QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uad00\ub9ac\uc640 \ubd84\uc11d\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc9d1\ub2c8\ub2e4. QUERY\ub294 \uc5f4\ub2e8\uc704\ub85c \uc815\ub82c, \ud569\uacc4, \ud544\ud130\ub9c1\ub4f1\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud568\uc218\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \uc27d\uc2b5\ub2c8\ub2e4. \ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc, \uc5ec\ub7ec \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc785\ucd9c\uace0\ub300\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc7ac\uace0\ub97c \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud655\uc778\ud558\ub824\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc785\uace0\uc640 \ucd9c\uace0\ub97c \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub85c \uae30\ub85d\ud558\uba74, \ud53c\ubc97\ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#blogposting\",\"name\":\"\\uad6c\\uae00 \\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\\uc758 \\uac15\\ub825\\ud55c \\uae30\\ub2a5 QUERY - Tech Blog of autooffice\",\"headline\":\"\\uad6c\\uae00 \\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\\uc758 \\uac15\\ub825\\ud55c \\uae30\\ub2a5 QUERY\",\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/image-12.png\",\"width\":2490,\"height\":1036},\"datePublished\":\"2020-06-30T18:21:20+09:00\",\"dateModified\":\"2025-09-15T18:54:44+09:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#webpage\"},\"articleSection\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8, QUERY, \\ubd84\\uc11d, \\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8, \\ucffc\\ub9ac, \\ud1b5\\uacc4, \\ud53c\\ubc97\\ud14c\\uc774\\ube14\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/#listItem\",\"name\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/#listItem\",\"position\":2,\"name\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#listItem\",\"name\":\"\\uad6c\\uae00 \\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\\uc758 \\uac15\\ub825\\ud55c \\uae30\\ub2a5 QUERY\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#listItem\",\"position\":3,\"name\":\"\\uad6c\\uae00 \\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\\uc758 \\uac15\\ub825\\ud55c \\uae30\\ub2a5 QUERY\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/#listItem\",\"name\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"telephone\":\"+821024904264\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-new2023.png\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#organizationLogo\",\"width\":1461,\"height\":250},\"image\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/\",\"name\":\"autooffice\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#webpage\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/\",\"name\":\"\\uad6c\\uae00 \\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\\uc758 \\uac15\\ub825\\ud55c \\uae30\\ub2a5 QUERY - Tech Blog of autooffice\",\"description\":\"\\uad6c\\uae00 \\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\\uc758 QUERY \\uae30\\ub2a5\\uc744 \\uc0ac\\uc6a9\\ud574\\ubcf4\\uc168\\ub098\\uc694? QUERY\\ub97c \\uc0ac\\uc6a9\\ud558\\uba74 \\ub370\\uc774\\ud130\\uc758 \\uad00\\ub9ac\\uc640 \\ubd84\\uc11d\\uc774 \\ud6e8\\uc52c \\uc26c\\uc6cc\\uc9d1\\ub2c8\\ub2e4. QUERY\\ub294 \\uc5f4\\ub2e8\\uc704\\ub85c \\uc815\\ub82c, \\ud569\\uacc4, \\ud544\\ud130\\ub9c1\\ub4f1\\uc744 \\uc9c4\\ud589\\ud560 \\uc218 \\uc788\\uac8c \\ud574\\uc8fc\\ub294 \\ud568\\uc218\\ub77c\\uace0 \\uc0dd\\uac01\\ud558\\uba74 \\uc27d\\uc2b5\\ub2c8\\ub2e4. \\ud53c\\ubc97\\ud14c\\uc774\\ube14\\uacfc \\uc720\\uc0ac\\ud558\\uc9c0\\ub9cc, \\uc5ec\\ub7ec \\uc2dc\\ud2b8\\uc758 \\ub370\\uc774\\ud130\\ub97c \\ud65c\\uc6a9\\ud574\\uc57c\\ud558\\ub294 \\uacbd\\uc6b0\\uc5d0 \\uc720\\uc6a9\\ud569\\ub2c8\\ub2e4. \\uc608\\ub97c \\ub4e4\\uc5b4, \\uc785\\ucd9c\\uace0\\ub300\\uc7a5\\uc744 \\ub9cc\\ub4e4\\uace0 \\uc7ac\\uace0\\ub97c \\ud53c\\ubc97\\ud14c\\uc774\\ube14\\ub85c \\ud655\\uc778\\ud558\\ub824\\uba74 \\uc77c\\ubc18\\uc801\\uc73c\\ub85c \\ud558\\ub098\\uc758 \\uc2dc\\ud2b8\\uc5d0 \\uc785\\uace0\\uc640 \\ucd9c\\uace0\\ub97c \\ub3d9\\uc2dc\\uc5d0 \\uae30\\ub85d\\ud558\\uac8c \\ub429\\ub2c8\\ub2e4. \\ub530\\ub85c \\uae30\\ub85d\\ud558\\uba74, \\ud53c\\ubc97\\ud14c\\uc774\\ube14\\uc5d0\\uc11c \\ub370\\uc774\\ud130\\ub97c \\uc120\\ud0dd\\ud558\\uace0 \\ubd84\\uc11d\\ud558\\uae30 \\uc704\\ud574 \\ubcc4\\ub3c4\\uc758\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/image-12.png\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#mainImage\",\"width\":2490,\"height\":1036},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2020\\\/06\\\/30\\\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\\\/#mainImage\"},\"datePublished\":\"2020-06-30T18:21:20+09:00\",\"dateModified\":\"2025-09-15T18:54:44+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"alternateName\":\"autooffice\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY - Tech Blog of autooffice","description":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc168\ub098\uc694? QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uad00\ub9ac\uc640 \ubd84\uc11d\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc9d1\ub2c8\ub2e4. QUERY\ub294 \uc5f4\ub2e8\uc704\ub85c \uc815\ub82c, \ud569\uacc4, \ud544\ud130\ub9c1\ub4f1\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud568\uc218\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \uc27d\uc2b5\ub2c8\ub2e4. \ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc, \uc5ec\ub7ec \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc785\ucd9c\uace0\ub300\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc7ac\uace0\ub97c \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud655\uc778\ud558\ub824\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc785\uace0\uc640 \ucd9c\uace0\ub97c \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub85c \uae30\ub85d\ud558\uba74, \ud53c\ubc97\ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758","canonical_url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/","robots":"max-image-preview:large","keywords":"query,\ubd84\uc11d,\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8,\ucffc\ub9ac,\ud1b5\uacc4,\ud53c\ubc97\ud14c\uc774\ube14","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#blogposting","name":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY - Tech Blog of autooffice","headline":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY","author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-12.png","width":2490,"height":1036},"datePublished":"2020-06-30T18:21:20+09:00","dateModified":"2025-09-15T18:54:44+09:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#webpage"},"isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#webpage"},"articleSection":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8, QUERY, \ubd84\uc11d, \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8, \ucffc\ub9ac, \ud1b5\uacc4, \ud53c\ubc97\ud14c\uc774\ube14"},{"@type":"BreadcrumbList","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/#listItem","position":1,"name":"Home","item":"https:\/\/www.autooffice.co.kr\/en\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/#listItem","name":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/#listItem","position":2,"name":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8","item":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#listItem","name":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#listItem","position":3,"name":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY","previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/#listItem","name":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8"}}]},{"@type":"Organization","@id":"https:\/\/www.autooffice.co.kr\/en\/#organization","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","url":"https:\/\/www.autooffice.co.kr\/en\/","telephone":"+821024904264","logo":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/logo-new2023.png","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#organizationLogo","width":1461,"height":250},"image":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/","name":"autooffice"},{"@type":"WebPage","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#webpage","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/","name":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY - Tech Blog of autooffice","description":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc168\ub098\uc694? QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uad00\ub9ac\uc640 \ubd84\uc11d\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc9d1\ub2c8\ub2e4. QUERY\ub294 \uc5f4\ub2e8\uc704\ub85c \uc815\ub82c, \ud569\uacc4, \ud544\ud130\ub9c1\ub4f1\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud568\uc218\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \uc27d\uc2b5\ub2c8\ub2e4. \ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc, \uc5ec\ub7ec \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc785\ucd9c\uace0\ub300\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc7ac\uace0\ub97c \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud655\uc778\ud558\ub824\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc785\uace0\uc640 \ucd9c\uace0\ub97c \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub85c \uae30\ub85d\ud558\uba74, \ud53c\ubc97\ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#website"},"breadcrumb":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#breadcrumblist"},"author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"creator":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/06\/image-12.png","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#mainImage","width":2490,"height":1036},"primaryImageOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/#mainImage"},"datePublished":"2020-06-30T18:21:20+09:00","dateModified":"2025-09-15T18:54:44+09:00"},{"@type":"WebSite","@id":"https:\/\/www.autooffice.co.kr\/en\/#website","url":"https:\/\/www.autooffice.co.kr\/en\/","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","alternateName":"autooffice","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"}}]},"og:locale":"en_US","og:site_name":"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","og:type":"article","og:title":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY - Tech Blog of autooffice","og:description":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc168\ub098\uc694? QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uad00\ub9ac\uc640 \ubd84\uc11d\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc9d1\ub2c8\ub2e4. QUERY\ub294 \uc5f4\ub2e8\uc704\ub85c \uc815\ub82c, \ud569\uacc4, \ud544\ud130\ub9c1\ub4f1\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud568\uc218\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \uc27d\uc2b5\ub2c8\ub2e4. \ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc, \uc5ec\ub7ec \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc785\ucd9c\uace0\ub300\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc7ac\uace0\ub97c \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud655\uc778\ud558\ub824\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc785\uace0\uc640 \ucd9c\uace0\ub97c \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub85c \uae30\ub85d\ud558\uba74, \ud53c\ubc97\ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758","og:url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/","og:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:secure_url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:width":400,"og:image:height":210,"article:published_time":"2020-06-30T09:21:20+00:00","article:modified_time":"2025-09-15T09:54:44+00:00","twitter:card":"summary_large_image","twitter:title":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY - Tech Blog of autooffice","twitter:description":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 QUERY \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc168\ub098\uc694? QUERY\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uad00\ub9ac\uc640 \ubd84\uc11d\uc774 \ud6e8\uc52c \uc26c\uc6cc\uc9d1\ub2c8\ub2e4. QUERY\ub294 \uc5f4\ub2e8\uc704\ub85c \uc815\ub82c, \ud569\uacc4, \ud544\ud130\ub9c1\ub4f1\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud568\uc218\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \uc27d\uc2b5\ub2c8\ub2e4. \ud53c\ubc97\ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc, \uc5ec\ub7ec \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc785\ucd9c\uace0\ub300\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc7ac\uace0\ub97c \ud53c\ubc97\ud14c\uc774\ube14\ub85c \ud655\uc778\ud558\ub824\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \ud558\ub098\uc758 \uc2dc\ud2b8\uc5d0 \uc785\uace0\uc640 \ucd9c\uace0\ub97c \ub3d9\uc2dc\uc5d0 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub85c \uae30\ub85d\ud558\uba74, \ud53c\ubc97\ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758","twitter:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png"},"aioseo_meta_data":{"post_id":"2914","title":null,"description":null,"keywords":null,"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2023-07-15 14:24:19","updated":"2026-08-21 07:56:34","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/\" title=\"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\">\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.autooffice.co.kr\/en\/"},{"label":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/"},{"label":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uac15\ub825\ud55c \uae30\ub2a5 QUERY","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/06\/30\/%ea%b5%ac%ea%b8%80-%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8%ec%9d%98-%ea%b0%95%eb%a0%a5%ed%95%9c-%ea%b8%b0%eb%8a%a5-query\/"}],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/2914","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=2914"}],"version-history":[{"count":2,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/2914\/revisions"}],"predecessor-version":[{"id":17240,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/2914\/revisions\/17240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/2904"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=2914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=2914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=2914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}