{"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>\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>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>\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>\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>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>\uc774\uc81c, \uc608\ub97c \uc0b4\ud3b4\ubcf4\uc2dc\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\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>\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>\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>\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>\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>\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>\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>\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>\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>\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>\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>\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>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> 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>\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>\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><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><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><\/p>\n\n\n\n<p><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><br><\/p>\n\n\n\n<p><\/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":{"_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.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_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}]}}