{"id":16906,"date":"2025-06-13T11:34:13","date_gmt":"2025-06-13T02:34:13","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=16906"},"modified":"2025-08-18T18:35:35","modified_gmt":"2025-08-18T09:35:35","slug":"how-to-use-user-parameter","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/06\/13\/how-to-use-user-parameter\/","title":{"rendered":"\ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ud65c\uc6a9\ud558\uae30 &#8211; \uc0ac\uc6a9\uc790 \uc815\uc758 \ub9e4\uac1c\ubcc0\uc218"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"589\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/WP-Thumb-1024x589.jpg\" alt=\"\" class=\"wp-image-16934\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/WP-Thumb-1024x589.jpg 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/WP-Thumb-300x172.jpg 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/WP-Thumb-768x441.jpg 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/WP-Thumb-1536x883.jpg 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/WP-Thumb-2048x1177.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"wp-block-aioseo-table-of-contents\"><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1\">1. \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00\ud558\uae30<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-1\">2-1. \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-2\">2-2. \uce21\uc815 \uae30\uc900 \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-3\">2-3. \uce21\uc815\ud56d\ubaa9(\ub9e4\ucd9c\/\uae08\uc561) \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-4\">2-4. \ubc18\ud488 \ud3ec\ud568 \uc5ec\ubd80 \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00<\/a><\/li><\/ul><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-3\">3. \ucffc\ub9ac \uc785\ub825\ud558\uae30<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-4\">4. \ub4dc\ub86d\ub2e4\uc6b4 \uc124\uc815<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-5\">5. \ucc28\ud2b8 \uc124\uc815<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice\n\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/a><\/li><\/ul><\/li><\/ul><\/div>\n\n\n<p><br><\/p>\n\n\n\n<p>\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc6b0\ub9ac\ub294 \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\ub97c \ud65c\uc6a9\ud558\uc5ec \uae30\uac04\ubcc4 \ub9e4\ucd9c \ube44\uad50, \uae30\uac04\uc5d0 \ub530\ub978 \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c\uc744 \ube44\uad50\ud558\ub294 \uae30\ub2a5\uacfc, \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\ub97c \ud65c\uc6a9\ud558\uc5ec \ub3d9\uc801\uc73c\ub85c \ub0a0\uc9dc\ub97c \ud45c\uc2dc\ud574\uc8fc\ub294 \ucc28\ud2b8\uc758 \ud5e4\ub354\ub97c \uc81c\uc791\ud558\ub294 \ubc29\ubc95\uae4c\uc9c0 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. (\u2b07\ufe0f \uc544\ub798 \uc774\ubbf8\uc9c0 \ucc38\uc870)<\/p>\n\n\n\n<p>\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc640 \ube45\ucffc\ub9ac\ub97c \uc5f0\ub3d9\ud560 \ub54c \uc774\ub807\uac8c \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\ub97c \ubcf4\ub2e4 \ub3d9\uc801\uc73c\ub85c \ubd88\ub7ec\uc62c \uc218 \uc788\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc5c8\uc9c0\uc694?<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"479\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-2-1024x479.png\" alt=\"\" class=\"wp-image-16907\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-2-1024x479.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-2-300x140.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-2-768x359.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-2-1536x719.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-2.png 1590w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc774\ubc88 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc744 \ud55c \uce35 \ub354 \uae4a\uc774 \ud65c\uc6a9\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\ub294 \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\uc790\uac00 \uc815\uc758\ud558\ub294 \uae30\ub2a5\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c <strong>\ub9e4\uac1c\ubcc0\uc218\ub294 \ub4dc\ub86d\ub2e4\uc6b4\uc744 \ud1b5\ud574\uc11c \uc870\uc791\ud560 \uc218 \uc788\uc73c\uba70, \ub4dc\ub86d\ub2e4\uc6b4\uc5d0\uc11c \uc120\ud0dd\ud55c \uac12\uc5d0 \ub530\ub77c \ucffc\ub9ac\uc5d0 \uc815\ud574\uc9c4 \uac12\uc744 \uc804\ub2ec\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/strong><\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4, \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \u2018\ud488\ubaa9\u2019 \uc774\ub77c\ub294 \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0dd\uc131\ud588\ub2e4\uace0 \uac00\uc815\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"286\" height=\"83\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-3.png\" alt=\"\" class=\"wp-image-16908\"\/><\/figure>\n<\/div>\n\n\n<p><br>\uc774 \u2018\ud488\ubaa9\u2019 \ub9e4\uac1c\ubcc0\uc218\uc5d0 \u2018\uc0ac\uacfc\u2019, \u2018\ubc30\u2019, \u2018\ubc14\ub098\ub098\u2019 \ub97c \uc815\uc758\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774\uc81c \ub4dc\ub86d\ub2e4\uc6b4\uc744 \ud074\ub9ad\ud558\uba74 \uc544\ub798\uc640 \uac19\uc774 \uc815\uc758\ub41c \ud56d\ubaa9\ub4e4\uc774 \ub098\uc624\uace0, \uc5ec\uae30\uc11c \uc120\ud0dd\ud55c \uac12\uc774 \ub9de\ucda4 \ucffc\ub9ac\uc5d0 \uc804\ub2ec\uc774 \ub418\ub294 \uac83\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"287\" height=\"192\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-4.png\" alt=\"\" class=\"wp-image-16909\"\/><\/figure>\n<\/div>\n\n\n<p><br>\uc774 \ub9e4\uac1c\ubcc0\uc218\ub97c \ube45\ucffc\ub9ac\uc5d0 \uc804\ub2ec\ud558\ub294 \ubc29\ubc95\uc740 \ub9de\ucda4 \ucffc\ub9ac\uc5d0\uc11c \ub9e4\uac1c\ubcc0\uc218 \uc774\ub984\uc744 \uae30\uc785\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4. \uc544\ub798 \uc608\uc2dc \ucffc\ub9ac\ub97c \ubcf4\uba74 WHERE \uc870\uac74\uc808\uc5d0\uc11c \u2018\ud488\ubaa9\u2019 \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM `\ub370\uc774\ud130 \ud14c\uc774\ube14`\nWHERE productName = @\ud488\ubaa9<\/code><\/pre>\n\n\n\n<p><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\u2018\ud488\ubaa9\u2019 \uc55e\uc5d0 \ubd99\uc5b4\uc788\ub294 \u2018@\u2019 \ud45c\uc2dc\ub294 \uc774 \ubb38\uc790\uac00 \ub9e4\uac1c\ubcc0\uc218\ub77c\ub294 \uac83\uc744 \uc2dd\ubcc4\uc2dc\ucf1c\uc8fc\ub294 \ud45c\uc2dc\uc785\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p>WHERE \uc870\uac74\uc808\uc5d0\uc11c \ud14c\uc774\ube14\uc5d0 \uc788\ub294 \ud488\ubaa9\uba85\uacfc \u2018@\ud488\ubaa9\u2019 \uc758 \uac12\uc774 \uc77c\uce58\ud558\ub294 \uac83\ub9cc SELECT\ud558\ub294 \uac83\uc774\uc9c0\uc694. \uc608\uc2dc\uc5d0\uc11c\ub294 \u2018\uc0ac\uacfc\u2019\ub97c \uc120\ud0dd\ud558\uc600\uc73c\ubbc0\ub85c \uc0ac\uacfc \ud488\ubaa9\uc5d0 \ub300\ud55c \ub370\uc774\ud130\ub9cc \ubd88\ub7ec\uc624\uac8c \ub429\ub2c8\ub2e4. \uc774\ud574\ub97c \ub3d5\uae30 \uc704\ud574 \ub2e8\uc21c\ud558\uac8c \ud544\ud130\ub9c1 \ud558\ub294 \uc218\uc900\uc758 \ucffc\ub9ac\ubb38\uc774\uc5c8\uc9c0\ub9cc \uc774 \uae30\ub2a5\uc740 \ud6e8\uc52c \ub354 \ub9ce\uc740 \uac83\uc744 \uac00\ub2a5\ud558\uac8c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc81c \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\uc5d0 \ub354\ud574\uc11c \uc0ac\uc6a9\uc790\uac00 \uc9c1\uc811 \uc815\uc758\ud55c \ub9e4\uac1c\ubcc0\uc218\ub97c \ud65c\uc6a9\ud558\uc5ec \uc544\ub798\uc758 \ucc28\ud2b8\ub97c \uc644\uc131\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<p>1\ufe0f\u20e3: \ucc28\ud2b8\uc758 \uce21\uc815 \uae30\uc900\uc744 \u2018\uac70\ub798\ucc98\ubcc4\u2019, \u2018\ud488\ubaa9\ubcc4\u2019, \u2018\ucc44\ub110\ubcc4\u2019, \u2018\ud310\ub9e4\ubab0\ubcc4\u2019\ub85c \ubcc0\uacbd\ud558\ub294 \uae30\ub2a5<\/p>\n\n\n\n<p>\u21d2 \ub4dc\ub86d \ub2e4\uc6b4\uc5d0\uc11c \uc120\ud0dd\ud558\ub294 \uae30\uc900\uc5d0 \ub530\ub978 \u2018\ub9e4\ucd9c\u2019 \ub610\ub294 \u2018\uc218\ub7c9\u2019\uc744 \uc9d1\uacc4\ud558\uace0, \uae30\uac04\ubcc4\ub85c \ube44\uad50 \uac12\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<br><\/p>\n\n\n\n<p>2\ufe0f\u20e3: \ucc28\ud2b8\uc758 \uce21\uc815 \ud56d\ubaa9\uc744 \u2018\ub9e4\ucd9c\u2019, \u2018\uc218\ub7c9\u2019 \uc73c\ub85c \ubcc0\uacbd\ud558\ub294 \uae30\ub2a5<\/p>\n\n\n\n<p>\u21d2 \ub4dc\ub86d \ub2e4\uc6b4\uc5d0\uc11c \uc120\ud0dd\ud55c \ud56d\ubaa9\uc5d0 \ub530\ub77c \u2018\ub9e4\ucd9c\u2019 \ub610\ub294 \u2018\uc218\ub7c9\u2019\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<br><\/p>\n\n\n\n<p>3\ufe0f\u20e3: \ubc18\ud488 \uac74\uc744 \uc9d1\uacc4\uc5d0 \ud3ec\ud568\ud560 \uac83\uc778\uc9c0 \uc124\uc815\ud558\uae30<\/p>\n\n\n\n<p>\u21d2 \ub4dc\ub86d \ub2e4\uc6b4\uc5d0\uc11c \ubc18\ud488 \uac74\uc5d0 \ub300\ud558\uc5ec \u2018\ub9e4\ucd9c\u2019 \ub610\ub294 \u2018\uc218\ub7c9\u2019\uc5d0 \ud3ec\ud568\uc2dc\ud0ac \uac83\uc778\uc9c0\ub97c \uc124\uc815\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\uc608\uc2dc\uc5d0\uc11c \ubc18\ud488 \uac74\uc740 \uc544\ub798\uc640 \uac19\uc774 \uc6d0\ubcf8 \ub370\uc774\ud130\uc5d0\uc11c \ud310\ub9e4 \uc218\ub7c9\uc774 -(\uc74c\uc218) \uc778 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"159\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-5-1024x159.png\" alt=\"\" class=\"wp-image-16910\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-5-1024x159.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-5-300x46.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-5-768x119.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-5.png 1395w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"552\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-6-1024x552.png\" alt=\"\" class=\"wp-image-16911\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-6-1024x552.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-6-300x162.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-6-768x414.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-6-1536x828.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-6.png 1577w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\uc624\ub298 \uc0ac\uc6a9\ud560 \uc608\uc2dc\ub294 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc774\uc5b4\uc9c0\ub294 \ub0b4\uc6a9\uc73c\ub85c, \uc774\uc804 \ud3ec\uc2a4\ud2b8\ub97c \uba3c\uc800 \uc0b4\ud3b4\ubcf4\ub294 \uac83\uc774 \ub0b4\uc6a9\uc744 \uc774\ud574\ud558\ub294\ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \uc544\ub798 \ub9c1\ud06c\ub97c \ud655\uc778\ud574\uc8fc\uc138\uc694.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2025\/04\/10\/how-to-use-custom-queries-using-parameters\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ud65c\uc6a9\ud558\uae30 \u2013 \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2025\/05\/08\/how-to-use-custom-queries-using-parameters2\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ud65c\uc6a9\ud558\uae30 \u2013 \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 2<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"aioseo-1\">1. \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00\ud558\uae30<\/h1>\n\n\n\n<p><br>\uba3c\uc800 \ub9e4\uac1c\ubcc0\uc218\ub97c \ucd94\uac00\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc218\uc815 \ud654\uba74 \uc0c1\ub2e8\uc5d0\uc11c \u2018<strong>\ub9ac\uc18c\uc2a4<\/strong>\u2019 \u2192 \u2018<strong>\ucd94\uac00\ub41c \ub370\uc774\ud130 \uc18c\uc2a4 \uad00\ub9ac<\/strong>\u2019\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"777\" height=\"242\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-7.png\" alt=\"\" class=\"wp-image-16912\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-7.png 777w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-7-300x93.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-7-768x239.png 768w\" sizes=\"auto, (max-width: 777px) 100vw, 777px\" \/><\/figure>\n\n\n\n<p><br>\ud558\ub2e8\uc758 \u2018<strong>\ub370\uc774\ud130 \uc18c\uc2a4 \ucd94\uac00<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"239\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-8-1024x239.png\" alt=\"\" class=\"wp-image-16913\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-8-1024x239.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-8-300x70.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-8-768x179.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-8.png 1340w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><strong>\ube45\ucffc\ub9ac(BigQuery) \uc120\ud0dd<\/strong> \u2192 <strong>\u2018\ub9de\ucda4 \uac80\uc0c9\uc5b4\u2019<\/strong> \u2192 <strong>\ud504\ub85c\uc81d\ud2b8 \uc120\ud0dd<\/strong> \u2192 <strong>\ucffc\ub9ac \uc785\ub825\ucc3d<\/strong>\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"626\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-10-1024x626.png\" alt=\"\" class=\"wp-image-16914\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-10-1024x626.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-10-300x183.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-10-768x469.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-10.png 1195w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\ud558\ub2e8\uc5d0 \ub9e4\uac1c\ubcc0\uc218 \uc124\uc815 \uba54\ub274\uac00 \ub098\uc624\uc9c0\uc694? \uc624\ub298 \uc0ac\uc6a9\ud560 \ub9e4\uac1c\ubcc0\uc218\ub294 1\ufe0f\u20e3\uae30\uac04 \ub9e4\uac1c\ubcc0\uc218, 2\ufe0f\u20e3\uce21\uc815 \uae30\uc900, 3\ufe0f\u20e3\uce21\uc815 \ud56d\ubaa9, 4\ufe0f\u20e3\ubc18\ud488\uc5ec\ubd80\ub97c \ud3ec\ud568\ud560 \uac83\uc778\uc9c0 \uacb0\uc815\ud558\ub294 \ucd1d 4\uac1c\uc758 \ub9e4\uac1c\ubcc0\uc218\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \ud558\ub098\uc529 \ucd94\uac00\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \ube45\ucffc\ub9ac \ud14c\uc774\ube14\uc5d0 \uc788\ub294 \uc5b4\ub5a4 \uceec\ub7fc\uc744 select\ud560 \uac83\uc778\uc9c0 \ub9e4\uac1c\ubcc0\uc218\ub97c \ud1b5\ud574 \uc870\uc791\ud560 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \uc77c\ubd80 \ub9e4\uac1c\ubcc0\uc218\ub294 \ud14c\uc774\ube14\uc758 \uc2e4\uc81c \uceec\ub7fc\uba85\uc744 \ucc38\uc870\ud569\ub2c8\ub2e4. \uc608\uc2dc\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc2a4\ud0a4\ub9c8 \uad6c\uc870\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"364\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-11-1024x364.png\" alt=\"\" class=\"wp-image-16916\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-11-1024x364.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-11-300x107.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-11-768x273.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-11-1536x547.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-11.png 1610w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2-1\">2-1. \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00<\/h2>\n\n\n\n<p><br>\u2018\uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \uc0ac\uc6a9 \uc124\uc815\u2019\uc744 \uccb4\ud06c\ud558\uc5ec \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \uc0ac\uc6a9\uc744 \uc124\uc815\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \uc124\uc815\ud55c \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\ub294 SQL\uc2dd\ubcc4\uc790\uc5d0 \ud45c\uae30\ub418\uc5b4\uc788\ub4ef\uc774 <code><strong><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@DS_START_DATE<\/mark><\/strong><\/code>, <code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\"><strong>@DS_END_DATE<\/strong><\/mark><\/code> \ub85c \uc815\uc758\ub418\uc5b4 \uc788\uc5b4\uc11c \ucffc\ub9ac\uc5d0 \uc9c1\uc811 \uc785\ub825\ud558\uc5ec \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"734\" height=\"343\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-12-1.png\" alt=\"\" class=\"wp-image-16917\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-12-1.png 734w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-12-1-300x140.png 300w\" sizes=\"auto, (max-width: 734px) 100vw, 734px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2-2\"><br>2-2. \uce21\uc815 \uae30\uc900 \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00<\/h2>\n\n\n\n<p><br>\ud558\ub2e8\uc758 \u2018<strong>\ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"350\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-13.png\" alt=\"\" class=\"wp-image-16918\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-13.png 727w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-13-300x144.png 300w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/figure>\n\n\n\n<p><br>\u2018\ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00\u2019\ub97c \ud074\ub9ad\ud558\uba74 \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00 \ud654\uba74\uc774 \ub098\uc624\ub294\ub370, \uc5ec\uae30\uc11c \u2018<strong>\ub9e4\uac1c\ubcc0\uc218 \uc774\ub984<\/strong>\u2019\uc740 \uc218\uc815 \ud654\uba74\uc5d0\uc11c \ub370\uc774\ud130 \ubaa9\ub85d\uc5d0 \ud45c\uc2dc\ub418\ub294 \ud544\ub4dc\uc758 \uc774\ub984\uc744 \ub73b\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c \ub9e4\uac1c\ubcc0\uc218\ub97c \uc2dd\ubcc4\ud560 \uc218 \uc788\ub294 \uc774\ub984\uc73c\ub85c \uc9c0\uc815\ud558\uc600\uc2b5\ub2c8\ub2e4. \u2018<strong>\ub9e4\uac1c\ubcc0\uc218 ID<\/strong>\u2019\ub294 \ub9de\ucda4 \ucffc\ub9ac\uc5d0\uc11c \uc2e4\uc81c\ub85c \ucc38\uc870\ud558\ub294 \ub9e4\uac1c\ubcc0\uc218\uba85 \uc785\ub2c8\ub2e4. \ub9e4\uac1c\ubcc0\uc218 ID \uc5ed\uc2dc \uc2dd\ubcc4\ud560 \uc218 \uc788\ub294 \uc774\ub984\uc73c\ub85c \uc9c0\uc815\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\u2018<strong>\ud5c8\uc6a9\ub41c \uac12<\/strong>\u2019 \uc5d0\ub294 \u2018<strong>\ubaa8\ub4e0 \uac12<\/strong>\u2019\uacfc \u2018<strong>\uac12 \ubaa9\ub85d<\/strong>\u2019\uc774 \uc788\uc2b5\ub2c8\ub2e4. \u2018<strong>\ubaa8\ub4e0 \uac12<\/strong>\u2019\uc73c\ub85c \uc124\uc815\ud558\uba74 \ub9e4\uac1c\ubcc0\uc218\uc5d0\ub294 \uc0ac\uc6a9\uc790\uac00 \uc5b4\ub5a4 \uac12\uc774\ub4e0 \uc785\ub825\ud558\uace0 \uadf8 \uac12\uc744 \ub9de\ucda4 \ucffc\ub9ac\uc5d0 \uc804\ub2ec\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \uce21\uc815 \uae30\uc900\uc758 \ubc94\uc704\uac00 \uc815\ud574\uc838\uc788\uc73c\ubbc0\ub85c \u2018<strong>\uac12 \ubaa9\ub85d<\/strong>\u2019\uc744 \uc120\ud0dd\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"682\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-14.png\" alt=\"\" class=\"wp-image-16919\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-14.png 610w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-14-268x300.png 268w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<p><br>\u2018<strong>\uac12 \ubaa9\ub85d<\/strong>\u2019\uc5d0\uc11c \u2018<strong>\uac12<\/strong>\u2019\uc740 \ub9e4\uac1c\ubcc0\uc218\uc5d0 \uc800\uc7a5\ub418\ub294 \uc2e4\uc81c \uac12\uc744 \ub73b\ud558\uace0, \u2018<strong>\ub77c\ubca8<\/strong>\u2019\uc740 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 UI\uc5d0\uc11c \ud45c\uc2dc\ub418\ub294 \uc774\ub984\uc744 \ub73b\ud569\ub2c8\ub2e4. \ub4dc\ub86d\ub2e4\uc6b4\uc5d0 \ub9e4\uac1c\ubcc0\uc218\ub97c \ub123\uc744 \ub54c \ubaa9\ub85d\uc5d0 \ubcf4\uc5ec\uc9c0\ub294 \uac83\ub4e4\uc774 \ubc14\ub85c \u2018<strong>\ub77c\ubca8<\/strong>\u2019 \uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub4dc\ub86d\ub2e4\uc6b4\uc5d0\uc11c \u2018<strong>\uac70\ub798\ucc98\ubcc4<\/strong>\u2019\uc744 \uc120\ud0dd\ud558\uba74 <code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\"><strong>@SELECT_DIMENSION<\/strong><\/mark><\/code> \ubcc0\uc218\ub294 \uadf8 \uac12\uc778 \u2018shopName\u2019\uc744 \uc804\ub2ec\ubc1b\ub294 \uac83\uc774\uc9c0\uc694. \uc5ec\uae30\uc11c\ub294 \ube45\ucffc\ub9ac\uc758 \uceec\ub7fc\uba85\uacfc \uc77c\uce58\ud558\uac8c \uac12\uc744 \uc124\uc815\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ub807\uac8c \ub9e4\uac1c\ubcc0\uc218\ub97c \ucd94\uac00\ud55c \ub4a4, \ub4dc\ub86d\ub2e4\uc6b4\uc5d0\uc11c \uc120\ud0dd\ud558\uba74 \ub9de\ucda4 \ucffc\ub9ac\uc5d0 \uc120\ud0dd\ud55c \ub9e4\uac1c\ubcc0\uc218\uc758 \u2018<strong>\uac12<\/strong>\u2019\uc744 \uc804\ub2ec\ud560 \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4. \uce21\uc815 \uae30\uc900\uc744 <code><strong><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@SELECT_DIMENSION<\/mark><\/strong><\/code> \uc73c\ub85c \uc815\uc758\ud558\uc600\ub2e4\ub294 \uac83\uc744 \uae30\uc5b5\ud574\uc8fc\uc138\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"460\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-15-1024x460.png\" alt=\"\" class=\"wp-image-16920\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-15-1024x460.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-15-300x135.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-15-768x345.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-15.png 1128w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p> <br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \ub9e4\uac1c\ubcc0\uc218\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \uad6c\uae00\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ub2e4\uc74c\uc758 \uacf5\uc2dd \ubb38\uc11c\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><a href=\"https:\/\/cloud.google.com\/looker\/docs\/studio\/parameters?visit_id=638739152025497319-1907841542&amp;rd=1&amp;hl=ko\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"492\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/cloud-lockup-logo-500px.png\" alt=\"\" class=\"wp-image-16933\" style=\"width:283px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/cloud-lockup-logo-500px.png 500w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/cloud-lockup-logo-500px-300x295.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/cloud.google.com\/looker\/docs\/studio\/parameters?visit_id=638739152025497319-1907841542&amp;rd=1&amp;hl=ko\" target=\"_blank\" rel=\"noopener\" title=\"\">\ub9e4\uac1c\ubcc0\uc218 | Looker | Google Cloud<\/a><\/figcaption><\/figure>\n<\/div><\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><br><br><br><br><br><\/p>\n\n\n\n<p><br><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2-3\">2-3. \uce21\uc815\ud56d\ubaa9(\ub9e4\ucd9c\/\uae08\uc561) \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00<\/h2>\n\n\n\n<p><br>\uce21\uc815\ud56d\ubaa9 \ub9e4\uac1c\ubcc0\uc218\uc758 \uc124\uc815\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \ub3d9\uc791\ud558\ub294 \ubc29\uc2dd\uc740 \u2018\uce21\uc815\uae30\uc900\u2019\uacfc \ub3d9\uc77c\ud569\ub2c8\ub2e4. \ube45\ucffc\ub9ac\uc758 \uc6d0\ubcf8 \ud14c\uc774\ube14\uc758 \uceec\ub7fc\uc744 \ucc38\uc870\ud560 \uc218 \uc788\ub3c4\ub85d \uc6d0\ubcf8 \uceec\ub7fc\uba85\uc744 \uac01\uac01 \u2018revenue\u2019, \u2018quantity\u2019\ub85c \uc785\ub825\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"577\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-16.png\" alt=\"\" class=\"wp-image-16921\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-16.png 612w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-16-300x283.png 300w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/figure>\n\n\n\n<p><br>\uce21\uc815 \ud56d\ubaa9 \ub9e4\uac1c\ubcc0\uc218\ub294 <code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\"><strong>@SELECT_METRIC<\/strong><\/mark><\/code> \ub85c \uc815\uc758\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2-4\">2-4. \ubc18\ud488 \ud3ec\ud568 \uc5ec\ubd80 \ub9e4\uac1c\ubcc0\uc218 \ucd94\uac00<\/h2>\n\n\n\n<p><br>\ubc18\ud488\uc744 \ub9e4\ucd9c\uacfc \uc218\ub7c9\uc5d0 \ud3ec\ud568\ud560 \uac83\uc778\uc9c0\uc758 \uc5ec\ubd80\ub97c \uacb0\uc815\ud558\ub294 \ub9e4\uac1c\ubcc0\uc218\uc785\ub2c8\ub2e4. \uc774 \ub9e4\uac1c\ubcc0\uc218\ub294 \ub370\uc774\ud130 \uc138\ud2b8\uc758 \uceec\ub7fc\uc744 \ucc38\uc870\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \u2018\uac12\u2019\uc5d0\ub294 \ucffc\ub9ac \ub0b4\uc5d0\uc11c \uc2dd\ubcc4\ud560 \uc218 \uc788\ub3c4\ub85d \uc784\uc758\ub85c \uc815\uc758\ud558\uc600\uc73c\uba70 \uc774 \ub9e4\uac1c\ubcc0\uc218\uc758 ID\ub294 <code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\"><strong>@RETURN_CONDITIONS<\/strong><\/mark><\/code> \ub85c \uc815\uc758\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"550\" height=\"524\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-17.png\" alt=\"\" class=\"wp-image-16922\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-17.png 550w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-17-300x286.png 300w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/figure>\n\n\n\n<p><br>\uc774\ub807\uac8c \uc0ac\uc6a9\ud560 \ubaa8\ub4e0 \ub9e4\uac1c\ubcc0\uc218\ub97c \ucd94\uac00\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774\uc81c SQL\uc2dd\ubcc4\uc790\ub97c \ud1b5\ud574 \ub9e4\uac1c\ubcc0\uc218\ub97c \ucffc\ub9ac\uc5d0 \uc9c1\uc811 \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"463\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-18.png\" alt=\"\" class=\"wp-image-16923\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-18.png 751w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-18-300x185.png 300w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><\/figure>\n\n\n\n<p><br>\uc774\ub807\uac8c \ucd94\uac00\ud55c \ub9e4\uac1c\ubcc0\uc218\ub97c \uc5b4\ub5bb\uac8c \ucffc\ub9ac\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294\uc9c0 \ub2e4\uc74c \ub2e8\uacc4\ub85c \ub118\uc5b4\uac00\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"aioseo-3\">3. \ucffc\ub9ac \uc785\ub825\ud558\uae30<\/h1>\n\n\n\n<p><br>\ucffc\ub9ac\ub294 \uc9c0\ub09c\ubc88 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ud55c \uac83\uacfc \ube44\uc2b7\ud569\ub2c8\ub2e4. \ucffc\ub9ac\uc758 \ubaa9\uc801\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong><span style=\"text-decoration: underline;\">\uc120\ud0dd \uae30\uac04\uc758 \uce21\uc815 \uae30\uc900\uc5d0 \ub530\ub978 \ub9e4\ucd9c \ub610\ub294 \uc218\ub7c9 \ub370\uc774\ud130 \ubd88\ub7ec\uc624\uae30<\/span><\/strong><\/li>\n\n\n\n<li><strong><span style=\"text-decoration: underline;\">\uc120\ud0dd \uae30\uac04\uc758 \uce21\uc815 \uae30\uc900\uc5d0 \ub530\ub978 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \ub610\ub294 \uc218\ub7c9 \ubd88\ub7ec\uc624\uae30<\/span><\/strong><\/li>\n\n\n\n<li><strong><span style=\"text-decoration: underline;\">\ubc18\ud488 \ud3ec\ud568 \uc5ec\ubd80\uc5d0 \ub530\ub77c \ub9e4\ucd9c\/\uc218\ub7c9\uc744 \ud569\uc0b0\ud558\ub3c4\ub85d \uc870\uac74 \uc124\uc815\ud558\uae30<\/span><\/strong><\/li>\n\n\n\n<li><strong><span style=\"text-decoration: underline;\">\ube44\uad50 \ubd84\uc11d\ud560 \uc218 \uc788\ub3c4\ub85d \ubd88\ub7ec\uc628 \ub370\uc774\ud130\ub4e4\uc744 \ud558\ub098\uc758 \ud14c\uc774\ube14\ub85c \ud1b5\ud569\ud558\uae30<\/span><\/strong><br><br><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>WITH salesData AS (\n  SELECT salesDate, \n\t  CASE --\ub9e4\uac1c\ubcc0\uc218\uc758 \uac12\uc744 \ucc38\uc870\n\t    WHEN @SELECT_DIMENSION = 'shopName' THEN shopName \n\t    WHEN @SELECT_DIMENSION = 'item' THEN item\n\t    WHEN @SELECT_DIMENSION = 'channel' THEN channel \n\t    WHEN @SELECT_DIMENSION = 'store' THEN store \n\t  END AS selectDimension,\n\t  CASE \n\t\t  WHEN @SELECT_METRIC = 'revenue' THEN SUM(revenue)\n\t    WHEN @SELECT_METRIC = 'quantity' THEN SUM(quantity)\n\t  END AS selectMetric,\n  FROM autoofficeshare.commerce_sample.LS_salesData\n  WHERE salesDate BETWEEN PARSE_DATE('%Y%m%d', @DS_START_DATE) \n  AND PARSE_DATE('%Y%m%d', @DS_END_DATE) \n  AND (\n    @RETURN_CONDITIONS = 'include'\n    OR (\n      @RETURN_CONDITIONS = 'exclude'\n      AND (\n        (@SELECT_METRIC = 'revenue' AND revenue \uff1e= 0)\n        OR\n        (@SELECT_METRIC = 'quantity' AND quantity \uff1e= 0)\n      )\n    )\n  )\n  GROUP BY salesDate, selectDimension\n),\n\nlastYearData AS (\n  SELECT DATE_ADD(salesDate, INTERVAL 1 YEAR) AS salesDate, \n    CASE \n\t    WHEN @SELECT_DIMENSION = 'shopName' THEN shopName \n\t    WHEN @SELECT_DIMENSION = 'item' THEN item\n\t    WHEN @SELECT_DIMENSION = 'channel' THEN channel \n\t    WHEN @SELECT_DIMENSION = 'store' THEN store \n\t  END AS selectDimension,\n\t  CASE \n\t    WHEN @SELECT_METRIC = 'revenue' THEN SUM(revenue)\n\t    WHEN @SELECT_METRIC = 'quantity' THEN SUM(quantity)\n\t  END AS selectMetric,\n  FROM autoofficeshare.commerce_sample.LS_salesData\n  WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 YEAR) \n  AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 YEAR)\n  AND (\n    @RETURN_CONDITIONS = 'include'\n    OR (\n      @RETURN_CONDITIONS = 'exclude'\n      AND (\n        (@SELECT_METRIC = 'revenue' AND revenue \uff1e= 0)\n        OR\n        (@SELECT_METRIC = 'quantity' AND quantity \uff1e= 0)\n      )\n    )\n  )\n  GROUP BY salesDate, selectDimension\n),\n\noneMonthAgoData AS (\n  SELECT DATE_ADD(salesDate, INTERVAL 1 MONTH) AS salesDate, \n    CASE \n\t    WHEN @SELECT_DIMENSION = 'shopName' THEN shopName \n\t    WHEN @SELECT_DIMENSION = 'item' THEN item\n\t    WHEN @SELECT_DIMENSION = 'channel' THEN channel \n\t    WHEN @SELECT_DIMENSION = 'store' THEN store \n\t  END AS selectDimension,\n\t  CASE \n\t    WHEN @SELECT_METRIC = 'revenue' THEN SUM(revenue)\n\t    WHEN @SELECT_METRIC = 'quantity' THEN SUM(quantity)\n\t  END AS selectMetric,\n  FROM autoofficeshare.commerce_sample.LS_salesData\n  WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 MONTH) \n  AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 MONTH)\n  AND (\n    @RETURN_CONDITIONS = 'include'\n    OR (\n      @RETURN_CONDITIONS = 'exclude'\n      AND (\n        (@SELECT_METRIC = 'revenue' AND revenue \uff1e= 0)\n        OR\n        (@SELECT_METRIC = 'quantity' AND quantity \uff1e= 0)\n      )\n    )\n  )\n  GROUP BY salesDate, selectDimension\n),\n\ntwoMonthAgoData AS (\n  SELECT DATE_ADD(salesDate, INTERVAL 2 MONTH) AS salesDate, \n    CASE \n\t    WHEN @SELECT_DIMENSION = 'shopName' THEN shopName \n\t    WHEN @SELECT_DIMENSION = 'item' THEN item\n\t    WHEN @SELECT_DIMENSION = 'channel' THEN channel \n\t    WHEN @SELECT_DIMENSION = 'store' THEN store \n\t  END AS selectDimension,\n\t  CASE \n\t    WHEN @SELECT_METRIC = 'revenue' THEN SUM(revenue)\n\t    WHEN @SELECT_METRIC = 'quantity' THEN SUM(quantity)\n\t  END AS selectMetric,\n  FROM autoofficeshare.commerce_sample.LS_salesData\n  WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 2 MONTH) \n  AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 2 MONTH)\n  AND (\n    @RETURN_CONDITIONS = 'include'\n    OR (\n      @RETURN_CONDITIONS = 'exclude'\n      AND (\n        (@SELECT_METRIC = 'revenue' AND revenue \uff1e= 0)\n        OR\n        (@SELECT_METRIC = 'quantity' AND quantity \uff1e= 0)\n      )\n    )\n  )\n  GROUP BY salesDate, selectDimension\n\n),\n\nthreeMonthAgoData AS (\n  SELECT DATE_ADD(salesDate, INTERVAL 3 MONTH) AS salesDate, \n    CASE \n\t    WHEN @SELECT_DIMENSION = 'shopName' THEN shopName \n\t    WHEN @SELECT_DIMENSION = 'item' THEN item\n\t    WHEN @SELECT_DIMENSION = 'channel' THEN channel \n\t    WHEN @SELECT_DIMENSION = 'store' THEN store \n\t  END AS selectDimension,\n\t  CASE \n\t    WHEN @SELECT_METRIC = 'revenue' THEN SUM(revenue)\n\t\t  WHEN @SELECT_METRIC = 'quantity' THEN SUM(quantity)\n\t  END AS selectMetric,\n  FROM autoofficeshare.commerce_sample.LS_salesData\n  WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 3 MONTH) \n  AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 3 MONTH)\n  AND (\n    @RETURN_CONDITIONS = 'include'\n    OR (\n      @RETURN_CONDITIONS = 'exclude'\n      AND (\n        (@SELECT_METRIC = 'revenue' AND revenue \uff1e= 0)\n        OR\n        (@SELECT_METRIC = 'quantity' AND quantity \uff1e= 0)\n      )\n    )\n  )\n  GROUP BY salesDate, selectDimension\n),\n\njoinedData AS (\nSELECT\n  COALESCE(o.salesDate, l.salesDate, m1.salesDate, m2.salesDate, m3.salesDate) AS salesDate,\n  COALESCE(o.selectDimension, l.selectDimension, m1.selectDimension, m2.selectDimension, m3.selectDimension) AS selectDimension,\n  COALESCE(o.selectMetric, 0) AS currentYearValue,\n  COALESCE(l.selectMetric, 0) AS lastYearValue,\n  COALESCE(m1.selectMetric, 0) AS oneMonthAgoValue,\n  COALESCE(m2.selectMetric, 0) AS twoMonthAgoValue,\n  COALESCE(m3.selectMetric, 0) AS threeMonthAgoValue\nFROM\n  salesData o\nFULL OUTER JOIN\n  lastYearData l\nON\n  o.selectDimension = l.selectDimension AND o.salesDate = l.salesDate\nFULL OUTER JOIN\n  oneMonthAgoData m1\nON\n  COALESCE(o.selectDimension, l.selectDimension) = m1.selectDimension AND \n  COALESCE(o.salesDate, l.salesDate) = m1.salesDate\nFULL OUTER JOIN\n  twoMonthAgoData m2\nON\n  COALESCE(o.selectDimension, l.selectDimension, m1.selectDimension) = m2.selectDimension AND\n  COALESCE(o.salesDate, l.salesDate, m1.salesDate) = m2.salesDate\nFULL OUTER JOIN\n  threeMonthAgoData m3\nON\n  COALESCE(o.selectDimension, l.selectDimension, m1.selectDimension, m2.selectDimension) = m3.selectDimension AND\n  COALESCE(o.salesDate, l.salesDate, m1.salesDate, m2.salesDate) = m3.salesDate\n)\n\nSELECT * FROM joinedData\n\n<\/code><\/pre>\n\n\n\n<p><br>\ucffc\ub9ac\uac00 \uae38\uc5b4\ubcf4\uc774\uc9c0\ub9cc \uac01\uac01\uc758 CTE\uac00 \ub3d9\uc791\ud558\ub294 \ub85c\uc9c1\uc740 \ubaa8\ub450 \ube44\uc2b7\ud569\ub2c8\ub2e4. \uc774 \uc911 2\uac00\uc9c0 CTE\ub9cc \uc120\ud0dd\ud558\uc5ec \ubd84\uc11d\ud574\ubcf4\uba74 \ucda9\ubd84\ud788 \uc774\ud574\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798 CTE\ub294 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \ub610\ub294 \uc218\ub7c9\uc744 \ubd88\ub7ec\uc624\ub294 \ucffc\ub9ac\uc785\ub2c8\ub2e4. \uc55e\uc11c \uc815\uc758\ud588\ub358 \uac01\uac01\uc758 \ub9e4\uac1c\ubcc0\uc218\uac00 SQL\uc2dd\ubcc4\uc790\ub97c \ud1b5\ud574 \uc0ac\uc6a9\ub418\uace0 \uc788\ub294\uac83\uc774 \ubcf4\uc774\uc9c0\uc694?<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>threeMonthAgoData AS (\n  SELECT DATE_ADD(salesDate, INTERVAL 3 MONTH) AS salesDate, \n    CASE \n\t    WHEN @SELECT_DIMENSION = 'shopName' THEN shopName \n\t    WHEN @SELECT_DIMENSION = 'item' THEN item\n\t    WHEN @SELECT_DIMENSION = 'channel' THEN channel \n\t    WHEN @SELECT_DIMENSION = 'store' THEN store \n\t  END AS selectDimension,\n\t  CASE \n\t    WHEN @SELECT_METRIC = 'revenue' THEN SUM(revenue)\n\t    WHEN @SELECT_METRIC = 'quantity' THEN SUM(quantity)\n\t  END AS selectMetric,\n  FROM autoofficeshare.commerce_sample.LS_salesData\n  WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 3 MONTH) \n  AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 3 MONTH)\n  AND (\n    @RETURN_CONDITIONS = 'include'\n    OR (\n      @RETURN_CONDITIONS = 'exclude'\n      AND (\n        (@SELECT_METRIC = 'revenue' AND revenue \uff1e= 0)\n        OR\n        (@SELECT_METRIC = 'quantity' AND quantity \uff1e= 0)\n      )\n    )\n  )\n  GROUP BY salesDate, selectDimension\n )<\/code><\/pre>\n\n\n\n<p><br>\uac01 \ubd80\ubd84\uc744 \ud558\ub098\uc529 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uce21\uc815\uae30\uc900(<code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@SELECT_DIMENSION<\/mark><\/code>)<\/strong><\/li>\n<\/ul>\n\n\n\n<p><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@SELECT_DIMENSION<\/mark><\/code><\/strong><\/code> \ub9e4\uac1c\ubcc0\uc218\ub97c CASE\ubb38\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774 \ub9e4\uac1c\ubcc0\uc218\uc5d0 shopName, item, channel, store \uac12\ub4e4\uc744 \uc815\uc758\ud558\uc600\ub294\ub370 \uac01\uac01\uc758 \uac12\uc5d0 \ub77c\ubca8\uba85\uc744 \uc9c0\uc815\ud588\ub358\uac83\uc774 \uae30\uc5b5\ub098\uc9c0\uc694? \ub4dc\ub86d\ub2e4\uc6b4\uc5d0\uc11c \ub77c\ubca8\ub4e4\uc744 \uc120\ud0dd\ud558\uba74 \uadf8\uc5d0 \ub9de\ub294 \uac12\ub4e4\uc774 CASE\ubb38\uc5d0\uc11c \ub3d9\uc791\ud560 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4 \ub4dc\ub86d\ub2e4\uc6b4\uc5d0\uc11c \u2018\uac70\ub798\ucc98\ubcc4\u2019\uc744 \uc120\ud0dd\ud558\uba74 \uc774 \ub9e4\uac1c\ubcc0\uc218\uc5d0\ub294 shopName, \u2018\ud488\ubaa9\ubcc4\u2019\uc744 \uc120\ud0dd\ud558\uba74 item\uc774 \ub9de\ucda4 \ucffc\ub9ac\uc5d0 \uc804\ub2ec\ub418\ub294 \uac83\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1<strong>CASE \uad6c\ubb38\uc774\ub780?<\/strong> \uc870\uac74\uc5d0 \ub530\ub77c \ub2e4\ub978 \uac12\uc744 \ubc18\ud658\ud558\ub294 SQL\uc758 \uc870\uac74\ubb38\uc785\ub2c8\ub2e4. \uae30\ubcf8 \uc0ac\uc6a9 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CASE \n    WHEN \uc870\uac741 THEN \uacb0\uacfc1\n    WHEN \uc870\uac742 THEN \uacb0\uacfc2\n    ELSE \uae30\ubcf8\uacb0\uacfc\nEND<\/code><\/pre>\n\n\n\n<p><br>\uc870\uac74 1\uc774 \ucc38\uc774\uba74 \uacb0\uacfc1\uc744 \ubc18\ud658, \uc870\uac74 1\uc774 \uac70\uc9d3\uc774\uace0 \uc870\uac742\uac00 \ucc38\uc774\uba74 \uacb0\uacfc2\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4. \ubaa8\ub4e0 \uc870\uac74\uc774 \uac70\uc9d3\uc774\uba74 \uae30\ubcf8 \uacb0\uacfc\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uce21\uc815\ud56d\ubaa9(<code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@SELECT_METRIC<\/mark><\/code><\/strong><\/code>)<\/strong><\/li>\n<\/ul>\n\n\n\n<p><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@SELECT_METRIC<\/mark><\/code><\/strong><\/code><\/strong><\/code> \ub9e4\uac1c\ubcc0\uc218 \uc5ed\uc2dc CASE\ubb38\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774 \ub9e4\uac1c\ubcc0\uc218\uc5d0 revenue, quantity \uac12\uc744 \uc815\uc758\ud558\uc600\ub294\ub370 \uac01\uac01\uc758 \uac12\uc758 \ub77c\ubca8\uc740 \u2018\ub9e4\ucd9c\u2019\uacfc \u2018\uc218\ub7c9\u2019\uc774\uc5c8\uc2b5\ub2c8\ub2e4. \uc5ed\uc2dc \ub4dc\ub86d\ub2e4\uc6b4\uc5d0\uc11c \u2018\ub9e4\ucd9c\u2019\uc744 \uc120\ud0dd\ud558\uba74 \ub9e4\uac1c\ubcc0\uc218\ub294 revenue\ub97c, \u2018\uc218\ub7c9\u2019\uc744 \uc120\ud0dd\ud558\uba74 quantity\ub97c \uc804\ub2ec\ud560 \uac83\uc785\ub2c8\ub2e4.<br><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uae30\uac04 \ub9e4\uac1c\ubcc0\uc218<\/strong>(<strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@<code>DS_START_DATE<\/code><\/mark><\/code><\/strong><\/code><\/strong>, <code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@<code>DS_END_DATE<\/code><\/mark><\/code><\/strong><\/code><\/strong><\/code>)<\/li>\n<\/ul>\n\n\n\n<p>\uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\ub294 STRING \ud615\ud0dc\ub85c \uc804\ub2ec\ub418\uae30 \ub54c\ubb38\uc5d0 \ub0a0\uc9dc \ud615\ud0dc\ub85c \ud30c\uc2f1\ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uac01\uac01\uc758 CTE\uc5d0\uc11c\ub294 \uc774 \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\ub97c WHERE \uc870\uac74 \uc808\uc5d0 \uc0ac\uc6a9\ud558\uc5ec \uc804\ub144\ub3c4, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \ub610\ub294 \uc218\ub7c9\uc744 \uc9d1\uacc4\ud569\ub2c8\ub2e4. BETWEEN\uc740 SQL\uc5d0\uc11c \ubc94\uc704 \uc870\uac74\uc744 \uc9c0\uc815\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \uc5f0\uc0b0\uc790\uc785\ub2c8\ub2e4. \ubcf4\ud1b5 \ub0a0\uc9dc\ub098 \uc22b\uc790 \ubc94\uc704\ub97c \ud544\ud130\ub9c1\ud560 \ub54c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<br><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ubc18\ud488 \ud3ec\ud568 \uc5ec\ubd80(<code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@RETURN_CONDITIONS<\/mark><\/code><\/strong><\/code><\/strong><\/code>)<\/strong><\/li>\n<\/ul>\n\n\n\n<p>\uc774 \ub9e4\uac1c\ubcc0\uc218\ub294 WHERE\uc808\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1 \ud558\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. <code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@RETURN_CONDITIONS<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code>\uac00 \u2018include\u2019\uc774\uba74 \uc870\uac74 \uc5c6\uc774 \ubaa8\ub4e0 \ub9e4\ucd9c \ub610\ub294 \uc218\ub7c9\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc <code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@RETURN_CONDITIONS<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code>\uac00 \u2018exclude\u2019\uc774\uba74 \ub9e4\ucd9c \ub610\ub294 \uc218\ub7c9\uc774 \uc74c\uc218\uc778 \uac83\uc740 \uc81c\uc678\ud558\uc9c0\uc694.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\uc544\ub798 \uc870\uac74\ubb38\uc5d0\uc11c <code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">@RETURN_CONDITIONS<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code> \uc758 \uc120\ud0dd \uac12\uc5d0 \ub530\ub77c CASE\ubb38\uc5d0\uc11c \uc815\uc758\ub41c \u2018selectMetric\u2019\uc744 \uc9c1\uc811 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694? selectMetric\uc740 CASE \ubb38\uc744 \uc0ac\uc6a9\ud574 SELECT\uc808 \uc548\uc5d0\uc11c\ub9cc \uc815\uc758\ub418\ub294 \ubcc4\uce6d(Alias)\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc774 \ubcc4\uce6d\uc740 SQL \uc2e4\ud589 \uc21c\uc11c \uc0c1 WHERE\uc808\uc5d0\uc11c\ub294 \uc778\uc2dd\uc774 \ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">GROUP BY<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code>\ub85c \uadf8\ub8f9\ud654\ub41c \uacb0\uacfc\uc5d0 \ub300\ud574 \uc870\uac74\uc744 \uac78 \uc218 \uc788\ub294 HAVING\uc808\uc744 \uc0ac\uc6a9\ud558\uba74 \u2018selectMetric\u2019\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc, \ubc18\ud488 \uac74\uae4c\uc9c0 \uc774\ubbf8 \uadf8\ub8f9\ud654\ub418\uc5b4\uc788\ub294 \uacb0\uacfc\uc5d0 \ub300\ud574\uc11c \ud544\ud130\ub9c1\uc744 \ud558\ub294 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \uac12\uc774 \uc815\ud655\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc774 \uacbd\uc6b0\uc5d0\ub294 WHERE\uc808\uc5d0 \uc870\uac74\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc801\ud569\ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> @RETURN_CONDITIONS = 'include'\n    OR (\n      @RETURN_CONDITIONS = 'exclude'\n      AND (\n        (@SELECT_METRIC = 'revenue' AND revenue \uff1e= 0)\n        OR\n        (@SELECT_METRIC = 'quantity' AND quantity \uff1e= 0)\n      )\n    )<\/code><\/pre>\n\n\n\n<p><br>\ub2e4\uc74c\uc73c\ub85c \uac80\ud1a0\ud560 CTE\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 \uac01 \uae30\uac04\ubcc4 CTE\ub97c <code><code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">FULL OUTER JOIN<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code><\/code> \ud558\uc5ec \ud1b5\ud569\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>joinedData AS (\nSELECT\n  COALESCE(o.salesDate, l.salesDate, m1.salesDate, m2.salesDate, m3.salesDate) AS salesDate,\n  COALESCE(o.selectDimension, l.selectDimension, m1.selectDimension, m2.selectDimension, m3.selectDimension) AS selectDimension,\n  COALESCE(o.selectMetric, 0) AS currentYearValue,\n  COALESCE(l.selectMetric, 0) AS lastYearValue,\n  COALESCE(m1.selectMetric, 0) AS oneMonthAgoValue,\n  COALESCE(m2.selectMetric, 0) AS twoMonthAgoValue,\n  COALESCE(m3.selectMetric, 0) AS threeMonthAgoValue\nFROM\n  salesData o\nFULL OUTER JOIN\n  lastYearData l\nON\n  o.selectDimension = l.selectDimension AND o.salesDate = l.salesDate\nFULL OUTER JOIN\n  oneMonthAgoData m1\nON\n  COALESCE(o.selectDimension, l.selectDimension) = m1.selectDimensionAND \n  COALESCE(o.salesDate, l.salesDate) = m1.salesDate\nFULL OUTER JOIN\n  twoMonthAgoData m2\nON\n  COALESCE(o.selectDimension, l.selectDimension, m1.selectDimension) = m2.selectDimensionAND\n  COALESCE(o.salesDate, l.salesDate, m1.salesDate) = m2.salesDate\nFULL OUTER JOIN\n  threeMonthAgoData m3\nON\n  COALESCE(o.selectDimension, l.selectDimension, m1.selectDimension, m2.selectDimension) = m3.selectStandard AND\n  COALESCE(o.salesDate, l.salesDate, m1.salesDate, m2.salesDate) = m3.salesDate\n)<\/code><\/pre>\n\n\n\n<p><br>\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc124\uba85\ud558\uc600\ub4ef\uc774 <code><code><code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">FULL OUTER JOIN<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code><\/code><\/code> \uc740 \ub450 \ud14c\uc774\ube14 \uac04\uc758 \ubaa8\ub4e0 \ud589\uc744 \ud3ec\ud568\ud558\uc5ec \uc870\uc778\ud558\uace0 <code><code><code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">COALESCE()<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code><\/code><\/code> \ub294 \uc5ec\ub7ec \uc778\uc218 \uc911 <code><code><code><code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code><\/code><\/code><\/code> \uc774 \uc544\ub2cc \uccab \ubc88\uc9f8 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. \ub450 \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud574\uc11c \ubaa8\ub4e0 \ub0a0\uc9dc\ub97c \ud3ec\ud568\ud558\uc5ec \ub370\uc774\ud130 \uc190\uc2e4 \uc5c6\uc774 CTE\ub4e4\uc744 \ud1b5\ud569\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uac19\uc740 \uc774\uc720\uc5d0\uc11c \uce21\uc815 \ud56d\ubaa9\uc778 \ub9e4\ucd9c\/\uc218\ub7c9\uc5d0\ub3c4 \ud310\ub9e4\uac00 \uc5c6\ub294 \uacbd\uc6b0\uc5d0\ub294 0\uc73c\ub85c \uc124\uc815\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1<code><code><code><code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">FULL OUTER JOIN<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code><\/code><\/code><\/code> \uacfc <code><code><code><strong><code><strong><code><strong><code><mark style=\"background-color:#fafe69;color:#ff14cc\" class=\"has-inline-color\">COALESCE()<\/mark><\/code><\/strong><\/code><\/strong><\/code><\/strong><\/code><\/code><\/code> \uad6c\ubb38\uc774 \ubcf8 \ud3ec\uc2a4\ud2b8\uc5d0 \uc801\uc6a9\ub41c \uc6d0\ub9ac\uc5d0 \ub300\ud574\uc11c \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uace0 \uc2f6\ub2e4\uba74 \uc544\ub798\uc758 \ud3ec\uc2a4\ud2b8\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694.<br><br><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2025\/04\/10\/how-to-use-full-outer-join-and-coalesce\/\" target=\"_blank\" rel=\"noopener\" title=\"\">FULL OUTER JOIN\uacfc COALESCE\ub97c \ud65c\uc6a9\ud574 \uc5ec\ub7ec \uac1c\uc758 \ud14c\uc774\ube14\uc744 \uae54\ub054\ud558\uac8c \uc870\uc778\ud558\uae30<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p>\ucffc\ub9ac \uc791\uc131\uc744 \ub9c8\ucce4\uc73c\ub2c8 \uc774\uc81c \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ucd94\uac00\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc6b0\uce21 \ud558\ub2e8\uc758 \u2018<strong>\ucd94\uac00<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"429\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-19-1024x429.png\" alt=\"\" class=\"wp-image-16924\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-19-1024x429.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-19-300x126.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-19-768x322.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-19.png 1445w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \ud55c\uae00\ub85c \ubcc0\uacbd\ud558\uc600\uc2b5\ub2c8\ub2e4. \uac01 \ud544\ub4dc\ub97c \ud074\ub9ad\ud558\uba74 \ubcc0\uacbd\ud560 \uc218 \uc788\uc73c\uba70, \ubcc0\uacbd \ud6c4\uc5d0\ub294 \uc6d0\ub798\uc758 \ud544\ub4dc\uba85\uc774 \ubb34\uc5c7\uc774\uc5c8\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc5c6\uc73c\ubbc0\ub85c \uc6d0\ubcf8 \ud544\ub4dc\uba85\uc740 \u2018\uc124\uba85\u2019 \ub780\uc5d0 \uae30\uc785\ud574\ub450\uba74 \ud3b8\ub9ac\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"584\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-20-1024x584.png\" alt=\"\" class=\"wp-image-16925\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-20-1024x584.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-20-300x171.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-20-768x438.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-20.png 1193w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc774\uc81c \ub9e4\uac1c\ubcc0\uc218\ub97c \uc9c1\uc811 \uc870\uc791\ud560 \uc218 \uc788\ub294 \ub4dc\ub86d\ub2e4\uc6b4\uc744 \ucd94\uac00\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"aioseo-4\">4. \ub4dc\ub86d\ub2e4\uc6b4 \uc124\uc815<\/h1>\n\n\n\n<p><br>\uc218\uc815 \ud654\uba74\uc5d0\uc11c \u2018<strong>\ucee8\ud2b8\ub864 \ucd94\uac00<\/strong>\u2019 \u2192 \u2018<strong>\ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d<\/strong>\u2019\uc744 \uc120\ud0dd \ud6c4 \uc801\uc808\ud55c \uacf3\uc5d0 \ubc30\uce58\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"688\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-21-1024x688.png\" alt=\"\" class=\"wp-image-16926\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-21-1024x688.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-21-300x201.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-21-768x516.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-21.png 1203w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc6b0\uce21 \ud544\ub4dc \ubaa9\ub85d\uc5d0\ub294 \ub9de\ucda4 \ucffc\ub9ac\uc5d0\uc11c \ucd94\uac00\ud588\ub358 \ub9e4\uac1c\ubcc0\uc218\uac00 \ub098\uc635\ub2c8\ub2e4. \ub9e4\uac1c\ubcc0\uc218\ub97c \ub4dc\ub86d\ub2e4\uc6b4\uc758 \ucee8\ud2b8\ub864 \ud544\ub4dc\ub85c \uc62e\uaca8\uc90d\ub2c8\ub2e4. \ub9de\ucda4 \ucffc\ub9ac\ub97c \uc791\uc131\ud560 \ub54c \uc0ac\uc6a9\ud588\ub358 \ub098\uba38\uc9c0 \ub9e4\uac1c\ubcc0\uc218\uc5d0 \ub300\ud558\uc5ec\ub3c4 \ub3d9\uc77c\ud55c \uc791\uc5c5\uc744 \uc9c4\ud589\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"403\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-22-1024x403.png\" alt=\"\" class=\"wp-image-16927\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-22-1024x403.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-22-300x118.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-22-768x303.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-22.png 1424w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"aioseo-5\"><br>5. \ucc28\ud2b8 \uc124\uc815<\/h1>\n\n\n\n<p><br>\ucc28\ud2b8\uc5d0\ub294 \ub9e4\ucd9c\/\uc218\ub7c9 \ud544\ub4dc\ub4e4\uc744 \uce21\uc815 \ud56d\ubaa9\uc5d0 \uc0bd\uc785\ud569\ub2c8\ub2e4. \uc774 \ud544\ub4dc\ub4e4\uc740 \ub9e4\uac1c\ubcc0\uc218 \uac12\uc5d0 \ub530\ub77c \ub3d9\uc801\uc73c\ub85c \ubcc0\ud654\ud558\ub294 \ud544\ub4dc\ub4e4\uc774\uc9c0\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"416\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-23-1024x416.png\" alt=\"\" class=\"wp-image-16928\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-23-1024x416.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-23-300x122.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-23-768x312.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-23-1536x624.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-23.png 1832w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\ucc28\ud2b8\uc758 \ud5e4\ub354\ub97c \ubcc4\ub3c4\ub85c \uc81c\uc791\ud558\ub294 \ubc29\ubc95\uc740 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \ub0b4\uc6a9\uc774 \uad81\uae08\ud558\ub2e4\uba74 \uc544\ub798\uc758 \ud3ec\uc2a4\ud2b8\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694.<br><br><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2025\/05\/08\/how-to-use-custom-queries-using-parameters2\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ud65c\uc6a9\ud558\uae30 \u2013 \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 2<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p>\ucc28\ud2b8\uac00 \uc644\uc131\ub418\uc5c8\uc73c\ub2c8 \ud55c\ubc88 \ud14c\uc2a4\ud2b8\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uce21\uc815\uae30\uc900\uc744 \u2018<strong>\ud488\ubaa9\ubcc4<\/strong>\u2019\ub85c \ubcc0\uacbd\ud558\uba74 \uc544\ub798 \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \ud488\ubaa9\ubcc4 \ub9e4\ucd9c\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"474\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-24-1024x474.png\" alt=\"\" class=\"wp-image-16929\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-24-1024x474.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-24-300x139.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-24-768x355.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-24-1536x711.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-24.png 1791w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc774\ubc88\uc5d0\ub294 \uce21\uc815\ud56d\ubaa9\uc744 \u2018<strong>\uc218\ub7c9<\/strong>\u2019\uc73c\ub85c \ubcc0\uacbd\ud558\uc600\uc2b5\ub2c8\ub2e4. \ud488\ubaa9\ubcc4 \ud310\ub9e4 \uc218\ub7c9 \ucc28\ud2b8\ub85c \uc798 \ubc14\ub00c\uc5c8\uc9c0\uc694?<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"477\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-25-1024x477.png\" alt=\"\" class=\"wp-image-16930\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-25-1024x477.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-25-300x140.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-25-768x358.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-25-1536x715.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-25.png 1791w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\ub9c8\uc9c0\ub9c9\uc73c\ub85c \u2018<strong>\ubc18\ud488 \ud3ec\ud568 \uc5ec\ubd80<\/strong>\u2019\ub97c \ubc18\ud488\uc744 \ud3ec\ud568\ud558\ub294 \uac83\uc73c\ub85c \uc124\uc815\ud558\uc600\uc2b5\ub2c8\ub2e4. \ubc18\ud488\uc744 \ud3ec\ud568\ud558\uae30 \ub54c\ubb38\uc5d0 \ucd1d \ud569\uacc4\uc5d0\uc11c \uc22b\uc790\uac00 \ub0b4\ub824\uac04 \uac83\uc774 \ubcf4\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"477\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-26-1024x477.png\" alt=\"\" class=\"wp-image-16931\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-26-1024x477.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-26-300x140.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-26-768x357.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-26-1536x715.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-26.png 1779w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc774\uac83\uc73c\ub85c \uc624\ub298 \ubaa9\ud45c\ub85c \ud588\ub358 \ub300\uc2dc\ubcf4\ub4dc\ub97c \uc644\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \uc774 \uae30\ub2a5\ub4e4\uc744 \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 \uad6c\ud604\ud55c\ub2e4\uba74 \ud488\ubaa9\ubcc4 \ub9e4\ucd9c\uacfc \uc218\ub7c9 \ucc28\ud2b8, \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c\uacfc \uc218\ub7c9 \ucc28\ud2b8 \ub4f1 \ucc28\ud2b8\ub97c \uc5ec\ub7ec\uac1c \ucd94\uac00\ud574\uc57c\ub9cc \ud569\ub2c8\ub2e4. \uc774\ucc98\ub7fc \ub9de\ucda4 \ucffc\ub9ac\uc5d0\uc11c \uc0ac\uc6a9\uc790 \ub9e4\uac1c\ubcc0\uc218\ub97c \ud65c\uc6a9\ud558\uba74 \ucc28\ud2b8\uc758 \uc7ac\uc0ac\uc6a9\uc131\uc774 \ub192\uc544\uc9c4\ub2e4\ub294 \uc7a5\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub9e4\uac1c\ubcc0\uc218\uc640 \ub9de\ucda4 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub2c8 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc18c\ud1b5\uc744 \ud558\ub294 \uac83\uacfc \uac19\uc740 \uae30\ubd84\uc774 \ub4dc\ub294 \uac83 \uac19\uc9c0\uc694? \ud83e\udd29 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uc0ac\uc6a9\uc790\ub77c\uba74 \uc774 \uc720\uc6a9\ud55c \uae30\ub2a5\uc744 \uaf2d \uc2e4\ubb34\uc5d0\ub3c4 \uc801\uc6a9\ud574\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4!<br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br>\ub2e4\uc74c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \uc624\ub298 \uc0b4\ud3b4\ubcf8 \ub0b4\uc6a9\uc5d0 \uc774\uc5b4\uc11c, \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \uc815\ub82c \uae30\uc900\uacfc \uc21c\uc11c\ub97c \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"555\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-27-1024x555.png\" alt=\"\" class=\"wp-image-16932\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-27-1024x555.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-27-300x163.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-27-768x416.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-27.png 1499w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\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\/06\/image-27-1.png\" alt=\"\" class=\"wp-image-17110\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-27-1.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/06\/image-27-1-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\"><strong>\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<br>\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/strong><\/h2>\n\n\n\n<p><br><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSfh9CSxm4aKG4Rhh6Xdh7Y6p5e_8ZhwWS_ryvxGOeQVIpmaRw\/viewform\" 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","protected":false},"excerpt":{"rendered":"<p>\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc6b0\ub9ac\ub294 \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\ub97c \ud65c\uc6a9\ud558\uc5ec \uae30\uac04\ubcc4 \ub9e4\ucd9c \ube44\uad50, \uae30\uac04\uc5d0 \ub530\ub978 \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c\uc744 \ube44\uad50\ud558\ub294 \uae30\ub2a5\uacfc, \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\ub97c \ud65c\uc6a9\ud558\uc5ec \ub3d9\uc801\uc73c\ub85c \ub0a0\uc9dc\ub97c \ud45c\uc2dc\ud574\uc8fc\ub294 \ucc28\ud2b8\uc758 \ud5e4\ub354\ub97c \uc81c\uc791\ud558\ub294 \ubc29\ubc95\uae4c\uc9c0 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. (\u2b07\ufe0f \uc544\ub798 \uc774\ubbf8\uc9c0 \ucc38\uc870) \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc640 \ube45\ucffc\ub9ac\ub97c \uc5f0\ub3d9\ud560 \ub54c \uc774\ub807\uac8c \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\ub97c \ubcf4\ub2e4 \ub3d9\uc801\uc73c\ub85c \ubd88\ub7ec\uc62c \uc218 \uc788\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc5c8\uc9c0\uc694? \uc774\ubc88 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc744&#8230;<\/p>\n","protected":false},"author":6,"featured_media":16934,"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":[6,41],"tags":[551,42,568,7,100,546,577,575,54,576,578],"class_list":["post-16906","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lookerstudio","category-bigquery","tag-autooffice","tag-bigquery","tag-lookerstudio","tag-spreadsheet","tag-100","tag-546","tag-577","tag-575","tag-54","tag-576","tag-578"],"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\/16906","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=16906"}],"version-history":[{"count":8,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16906\/revisions"}],"predecessor-version":[{"id":17118,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16906\/revisions\/17118"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/16934"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=16906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=16906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=16906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}