{"id":16867,"date":"2025-05-08T14:57:02","date_gmt":"2025-05-08T05:57:02","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=16867"},"modified":"2025-08-18T18:39:53","modified_gmt":"2025-08-18T09:39:53","slug":"how-to-use-custom-queries-using-parameters2","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/05\/08\/how-to-use-custom-queries-using-parameters2\/","title":{"rendered":"\ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ud65c\uc6a9\ud558\uae30 &#8211; \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 2"},"content":{"rendered":"\n<p><br><\/p>\n\n\n<div class=\"wp-block-aioseo-table-of-contents\"><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1\">1. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac70\ub798\ucc98\uc758 \uae30\uac04\ubcc4 \ub9e4\ucd9c \ube44\uad50\ud558\uae30<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1-1\">1-1. \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1-2\">1-2. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ucd94\uac00<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1-3\">1-3. \ucffc\ub9ac\ubb38 \uc791\uc131<\/a><\/li><\/ul><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2\">2. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud5e4\ub354 \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5\ud558\uae30<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-1\">2-1. \ub514\uc790\uc778 \uc785\ud788\uae30<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-2\">2-2. \ub0a0\uc9dc \ud45c\uae30\uc6a9 \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \uc791\uc131<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-2\">2-2. \ud45c \uc0bd\uc785<\/a><\/li><\/ul><\/li><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><\/div>\n\n\n<p><br><\/p>\n\n\n\n<p>\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc5d0 \ub300\ud55c \uae30\ubcf8 \uac1c\ub150\uacfc \uc0ac\uc6a9 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/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>\u2018<strong>\ub9de\ucda4 \ucffc\ub9ac<\/strong>\u2019 \ub610\ub294 \u2018<strong>\ucee4\uc2a4\ud140 \ucffc\ub9ac<\/strong>\u2019\ub77c\uace0\ub3c4 \ud558\ub294\ub370 \uc774 \uae30\ub2a5\uc740 \ube45\ucffc\ub9ac\uc5d0\uc11c \uc2e4\ud589\ud560 SQL\ubb38\uc744 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uc791\uc131\ud55c \ub4a4\uc5d0, \ube45\ucffc\ub9ac\uc5d0\uc11c \uc2e4\ud589\ud574\uc11c \uadf8 \uacb0\uacfc\ub97c \ubc1b\uc544\uc640\uc11c \ud65c\uc6a9\ud558\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4. \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\ub098 \ud544\ud130 \uae30\ub2a5\uc744 \ud1b5\ud574\uc11c \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \uc870\uc791\ud558\uba74 \uc6d0\ud558\ub294 \ub370\uc774\ud130\ub97c <strong><mark style=\"background-color:#fcff82\" class=\"has-inline-color\">\ub3d9\uc801\uc73c\ub85c<\/mark><\/strong> \ubd88\ub7ec\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4, \uc544\ub798\uc758 \ucc28\ud2b8\ub294 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc0dd\uc131\ud558\uc600\ub358 \ucc28\ud2b8\uc785\ub2c8\ub2e4. \ud45c\uc2dc\ub41c \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\ub97c \uc870\uc791\ud558\uba74 \ud574\ub2f9 \uae30\uac04\uc774 \ucffc\ub9ac\uc5d0 \uc804\ub2ec\uc774 \ub418\uace0, \ud574\ub2f9\ud558\ub294 \uae30\uac04\uc5d0 \ub300\ud55c \ub9e4\ucd9c, \uc804\ub144\ub3c4 \ub9e4\ucd9c, 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c, 2\uac1c\uc6d4 \uc804 \ub9e4\ucd9c, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c\uc744 \uac01\uac01 \uc77c\uc790\ubcc4\ub85c \ubcf4\uc5ec\uc8fc\ub294 \ud654\uba74\uc744 \uad6c\ud604\ud588\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=\"462\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-1024x462.png\" alt=\"\" class=\"wp-image-16868\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-1024x462.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-300x135.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-768x347.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-1536x694.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image.png 1787w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uc77c\uc790\ubcc4 \ub9e4\ucd9c \ube44\uad50<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><br>\uc5ec\uae30\uc11c \ucc28\ud2b8\uc758 \ud5e4\ub354\ub294 \uc804\ub144\ub3c4, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \uc774\ub77c\uace0 \ub418\uc5b4\uc788\uc9c0\ub9cc \uac01 \uae30\uac04\uc774 \uc5b8\uc81c\uc778\uc9c0 \uba85\ud655\ud788 \uc54c\ub824\uba74 \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\uc5d0\uc11c \uc120\ud0dd\ub41c \ub0a0\uc9dc\uc5d0\uc11c \uac01 \uae30\uac04\uc744 \uba38\ub9bf\uc18d\uc73c\ub85c \uacc4\uc0b0\ud574\uc57c \ud558\uc9c0\uc694. \ubb3c\ub860 \uadf8\uac83\uc774 \uc5b4\ub835\uc9c0 \uc54a\uc9c0\ub9cc <strong><mark style=\"background-color:#fcff82\" class=\"has-inline-color\">\ub300\uc2dc\ubcf4\ub4dc\ub294 \uc9c1\uad00\uc801\uc774\uc5b4\uc57c \ud558\uace0, \uac00\ub3c5\uc131\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/mark><\/strong><\/p>\n\n\n\n<p>\ub530\ub77c\uc11c \uc624\ub298\uc740 \uc9c0\ub09c\ubc88\uc5d0 \uc791\uc131\ud588\ub358 \ucffc\ub9ac\ub97c \uc57d\uac04 \uc218\uc815\ud558\uc5ec \uc544\ub798 \ucc28\ud2b8\ub97c \uc644\uc131\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc8fc\uc694 \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>(1) <span style=\"text-decoration: underline;\">\ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac70\ub798\ucc98\uc758 \uae30\uac04\ubcc4 \ub9e4\ucd9c \ube44\uad50\ud558\uae30<\/span><\/strong><\/p>\n\n\n\n<p><strong>(2) <span style=\"text-decoration: underline;\">\ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud5e4\ub354 \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5\ud558\uae30<\/span><\/strong><\/p>\n\n\n\n<p>\uc544\ub798 \uc774\ubbf8\uc9c0\ub97c \ubcf4\uba74 \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c\uc744 \uae30\uac04\ubcc4\ub85c \ube44\uad50\ud558\uace0 \uac01 \uc5f4\uc758 \ud5e4\ub354\uc5d0\ub294 \ube44\uad50\ud558\ub294 \uae30\uac04\uc758 \ub0a0\uc9dc\uac00 \ud45c\uae30\ub418\uc5b4\uc788\uc9c0\uc694. \uc9c0\ub09c\ubc88\uc5d0 \uc791\uc131\ud588\ub358 \ucffc\ub9ac\ub97c \uc57d\uac04 \uc218\uc815\ud558\uc5ec \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c\uc744 \ubcf4\uc5ec\uc8fc\uace0 \uac01 \uc5f4\uc758 \ud5e4\ub354\uc5d0 \ub0a0\uc9dc\ub97c \ud45c\uae30\ud558\uae30 \uc704\ud574\uc11c \uc0c8\ub85c\uc6b4 \ub9de\ucda4 \ucffc\ub9ac\ub97c \ucd94\uac00\ud560 \uac83\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=\"473\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-1-1024x473.png\" alt=\"\" class=\"wp-image-16869\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-1-1024x473.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-1-300x139.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-1-768x355.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-1.png 1430w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c \ube44\uad50<br><\/figcaption><\/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\uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \ubcf5\uc7a1\ud55c SQL\ucffc\ub9ac\ub97c \ub2e4\ub8e8\ubbc0\ub85c SQL\ubb38\ubc95\uc774 \uc775\uc219\ud558\uc9c0 \uc54a\ub2e4\uba74 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\ub97c \uba3c\uc800 \uc77d\uc5b4\ubcf4\uc2dc\uae38 \ucd94\ucc9c\ud569\ub2c8\ub2e4.<\/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<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-1\">1. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac70\ub798\ucc98\uc758 \uae30\uac04\ubcc4 \ub9e4\ucd9c \ube44\uad50\ud558\uae30<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p><br>\uc544\ub798\uc758 \ub3c4\uc2dd\uc740 \ub9e4\uac1c\ubcc0\uc218\ub97c \uc804\ub2ec\ud560 \ub54c \ub9e4\uac1c\ubcc0\uc218\uac00 \uc791\ub3d9\ud558\ub294 \uc6d0\ub9ac\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uc2dc\uc791 \uc77c\uc790\uc640 \uc885\ub8cc \uc77c\uc790 \ub9e4\uac1c\ubcc0\uc218\ub97c \uae30\uc900\uc73c\ub85c 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \uae30\uac04\uc744 <strong><mark style=\"background-color:#fcff82\" class=\"has-inline-color\">\uac70\ub798\ucc98\ubcc4\ub85c \uc5f0\uc0b0\ud569\ub2c8\ub2e4.<\/mark><\/strong><br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"315\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-2-1024x315.png\" alt=\"\" class=\"wp-image-16870\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-2-1024x315.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-2-300x92.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-2-768x236.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-2.png 1449w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uac01 \uae30\uac04\uc5d0 \ud574\ub2f9\ud558\ub294 \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c\uc744 CTE\ubcc4\ub85c \ub098\ub204\uc5b4 SELECT \ud55c \ub4a4\uc5d0, \uac01\uac01\uc758 CTE\ub97c \ud1b5\ud569\ud558\uba74 \uc6d0\ud558\ub294 \ucc28\ud2b8\ub97c \uad6c\ud604\ud560 \uc218 \uc788\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<strong>CTE\ub780?<\/strong> CTE(Common Table Expression)\ub294 SQL\uc5d0\uc11c \uc784\uc2dc\ub85c \uc0dd\uc131\ud558\ub294 \ud14c\uc774\ube14\uc785\ub2c8\ub2e4. \uc774\uac83\uc740 \ucffc\ub9ac\uc758 \uac00\ub3c5\uc131\uc744 \ub192\uc774\uace0 \uc7ac\uc0ac\uc6a9\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. WITH\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc815\uc758\ud569\ub2c8\ub2e4. \uc608\uc2dc\uc5d0\uc11c\ub294 \uac01 \uae30\uac04 \ubcc4\ub85c SELECT\ud558\ub294 \uad6c\ubb38\uc774 \uad04\ud638\ub85c \ubb36\uc5ec\uc788\ub294\ub370, \uc774 \ub2e8\uc704\ub4e4\uc744 CTE\ub77c\uace0 \ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-1-1\">1-1. \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/h3>\n\n\n\n<p><br>\uc0ac\uc6a9\ud560 \ub370\uc774\ud130\ub294 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ud588\ub358 \uac83\uacfc \ub3d9\uc77c\ud558\uac8c \u2018LS_salesData\u2019 \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\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=\"505\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-3-1024x505.png\" alt=\"\" class=\"wp-image-16871\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-3-1024x505.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-3-300x148.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-3-768x379.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-3-1536x758.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-3.png 1905w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\ube45\ucffc\ub9ac\uc758 \ub370\uc774\ud130<br><\/figcaption><\/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\uad6c\uae00 \uc2dc\ud2b8\ub97c \ube45\ucffc\ub9ac\uc640 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\ub85c \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95\uc740 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694<\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/02\/05\/%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%a5%bc-%eb%b9%85%ec%bf%bc%eb%a6%ac%ec%99%80-%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%eb%a1%9c\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \ub370\uc774\ud130\ub97c \ube45\ucffc\ub9ac\uc640 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\ub85c \uc2dc\uac01\ud654\ud558\uae30<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-1-2\">1-2. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ucd94\uac00<\/h3>\n\n\n\n<p><br>\uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\uc640 \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \ucd94\uac00\ud558\ub294 \ubc29\ubc95\uc740 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc18c\uac1c\ud558\uc600\uc73c\ubbc0\ub85c, \ucffc\ub9ac \uc785\ub825\ucc3d\uc5d0\uc11c \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\ub97c \uc124\uc815\ud558\ub294 \ubc29\ubc95\ubd80\ud130 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ucffc\ub9ac \uc785\ub825 \ucc3d\uc5d0\uc11c \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 \ubcc4\ub3c4 \uc124\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uc55e\uc11c \ub300\uc2dc\ubcf4\ub4dc\uc5d0 \uc788\ub358 \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\uc5d0\uc11c \uc120\ud0dd\ud55c \uc2dc\uc791 \uc77c\uc790\uc640 \uc885\ub8cc \uc77c\uc790\ub97c \ub9e4\uac1c\ubcc0\uc218\ub85c \uc0ac\uc6a9\ud558\ub824\uba74 \ub9de\ucda4 \ucffc\ub9ac \uc785\ub825 \ucc3d \ud558\ub2e8\uc758 \u2018<strong>\uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \uc0ac\uc6a9 \uc124\uc815<\/strong>\u2019 \ubc84\ud2bc\uc744 \uccb4\ud06c\ud574\uc57c \ud569\ub2c8\ub2e4. \uc2dc\uc791 \uc77c\uc790\ub294 <strong><code><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">@DS_START_DATE<\/mark><\/code><\/strong>, \uc885\ub8cc \uc77c\uc790\ub294 <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">@DS_END_DATE<\/mark><\/strong><\/code>\ub85c \uc815\uc758\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"943\" height=\"636\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-4.png\" alt=\"\" class=\"wp-image-16872\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-4.png 943w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-4-300x202.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-4-768x518.png 768w\" sizes=\"auto, (max-width: 943px) 100vw, 943px\" \/><\/figure>\n\n\n\n<p><br>\uae30\ubcf8 \uc124\uc815\uc744 \ub9c8\ucce4\uc73c\ub2c8 \ucffc\ub9ac\ubb38\uc744 \uc791\uc131\ud574\ubcfc\uae4c\uc694?<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-1-3\">1-3. \ucffc\ub9ac\ubb38 \uc791\uc131<\/h3>\n\n\n\n<p><br>\ucffc\ub9ac\uc758 \uc8fc\uc694 \ubaa9\ud45c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong><span style=\"text-decoration: underline;\">\uc120\ud0dd \uae30\uac04\uc758 \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c \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 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c \ubd88\ub7ec\uc624\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><\/li>\n<\/ol>\n\n\n\n<p>\uc544\ub798\ub294 \uc644\uc131\ub41c \uc804\uccb4 \ucf54\ub4dc\uc785\ub2c8\ub2e4. \uc77c\uc790\ubcc4 \ub9e4\ucd9c\uc744 \ubcf4\uc5ec\uc8fc\ub358 \ucffc\ub9ac\uc640 \ube44\uc2b7\ud558\uc9c0\ub9cc \uac70\ub798\ucc98\uba85\uc778 \u2018shopName\u2019\uc744 \ud568\uaed8 SELECT \ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uac01\uac01\uc758 CTE\ub294 \ucd5c\uc885\uc801\uc73c\ub85c \ube44\uad50\ud558\ub294 \uae30\uac04\uc758 \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c\ud569\uacc4\ub97c \uacc4\uc0b0\ud560 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \ucffc\ub9ac\uc758 \ub9c8\uc9c0\ub9c9 \uad6c\ubb38\uc5d0 <code><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><strong>GROUP BY<\/strong><\/mark><\/code> \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc77c\uc790\uc640 \uac70\ub798\ucc98\uba85\uc73c\ub85c \uadf8\ub8f9\ud654 \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\udca1GROUP BY \uad6c\ubb38\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \uad6c\uae00\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uc544\ub798\uc758 \uacf5\uc2dd \ub808\ud37c\ub7f0\uc2a4\ub97c \ud655\uc778\ud574\uc8fc\uc138\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax#group_by_clause\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"129\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google.png\" alt=\"\" class=\"wp-image-16873\" style=\"width:325px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google.png 392w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-300x99.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><\/figure>\n\n\n\n<p><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax#group_by_clause\" target=\"_blank\" rel=\"noopener\" title=\"\">Query syntax &nbsp;|&nbsp; BigQuery &nbsp;|&nbsp; Google Cloud<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \uc120\ud0dd \uae30\uac04\uc758 \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c \ubd88\ub7ec\uc624\uae30\nWITH current_sales AS (\n    SELECT salesDate, shopName, SUM(revenue) AS currentRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN PARSE_DATE('%Y%m%d', @DS_START_DATE) AND PARSE_DATE('%Y%m%d', @DS_END_DATE)\n    GROUP BY salesDate, shopName\n),\n-- \uc791\ub144 \ub3d9\uae30\uac04 \ub9e4\ucd9c \uac70\ub798\ucc98\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \nlastYearData  AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 YEAR) AS salesDate, shopName, SUM(revenue) AS lastYearRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 YEAR) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 YEAR)\n    GROUP BY salesDate, shopName\n),\n-- 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uac70\ub798\ucc98\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \noneMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 MONTH) AS salesDate, shopName, SUM(revenue) AS oneMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 MONTH) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 MONTH)\n    GROUP BY salesDate, shopName\n),\n-- 2\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uac70\ub798\ucc98\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \ntwoMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 2 MONTH) AS salesDate, shopName, SUM(revenue) AS twoMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 2 MONTH) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 2 MONTH)\n    GROUP BY salesDate, shopName\n),\n-- 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uac70\ub798\ucc98\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \nthreeMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 3 MONTH) AS salesDate, shopName, SUM(revenue) AS threeMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 3 MONTH) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 3 MONTH)\n    GROUP BY salesDate, shopName\n)\nSELECT \n    COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate, m3.salesDate) AS salesDate,\n    COALESCE(c.shopName, l.shopName, m1.shopName, m2.shopName, m3.shopName) AS shopName,\n    COALESCE(c.currentRevenue, 0) AS currentRevenue,\n    COALESCE(l.lastYearRevenue, 0) AS lastYearRevenue,\n    COALESCE(m1.lastMonthRevenue, 0) AS lastMonthRevenue,\n    COALESCE(m2.twoMonthAgoRevenue, 0) AS twoMonthAgoRevenue,\n    COALESCE(m3.threeMonthAgoRevenue, 0) AS threeMonthAgoRevenue\nFROM current_sales c\nFULL OUTER JOIN lastYearData l \n    ON c.salesDate = l.salesDate AND c.shopName = l.shopName\nFULL OUTER JOIN oneMonthAgoData m1 \n    ON COALESCE(c.salesDate, l.salesDate) = m1.salesDate \n    AND COALESCE(c.shopName, l.shopName) = m1.shopName\nFULL OUTER JOIN twoMonthAgoData m2 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate) = m2.salesDate \n    AND COALESCE(c.shopName, l.shopName, m1.shopName) = m2.shopName\nFULL OUTER JOIN threeMonthAgoData m3 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate) = m3.salesDate \n    AND COALESCE(c.shopName, l.shopName, m1.shopName, m2.shopName) = m3.shopName\nORDER BY salesDate ASC, shopName ASC;<\/code><\/pre>\n\n\n\n<p><br>\ucffc\ub9ac\ub97c CTE\ubcc4\ub85c \ubd84\ub958\ud558\uc5ec \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<p><strong>(1) \uc120\ud0dd \uae30\uac04\uc758 \ub9e4\ucd9c \ubd88\ub7ec\uc624\uae30<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>current_sales AS (\n  SELECT salesDate, shopName, SUM(revenue) AS currentRevenue\n  FROM autoofficeshare.commerce_sample.LS_salesData\n  WHERE salesDate BETWEEN PARSE_DATE('%Y%m%d', @DS_START_DATE) AND PARSE_DATE('%Y%m%d', @DS_END_DATE)\n  GROUP BY salesDate, shopName\n)<\/code><\/pre>\n\n\n\n<p><br>\u26a0\ufe0f \uc5ec\uae30\uc11c \uc2dc\uc791 \uc77c\uc790(<code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">@DS_START_DATE<\/mark><\/strong><\/code>)\uc640 \uc885\ub8cc \uc77c\uc790(<code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">@DS_END_DATE<\/mark><\/strong><\/code>) \ub9e4\uac1c\ubcc0\uc218\ub97c <strong><mark style=\"background-color:#fcff82\" class=\"has-inline-color\">DATE\ud0c0\uc785\uc73c\ub85c \ud30c\uc2f1<\/mark><\/strong>\ud558\uc600\uc2b5\ub2c8\ub2e4. \ucffc\ub9ac \uc785\ub825\ucc3d \ud558\ub2e8\uc5d0 \ud45c\uae30\ub418\uc5b4 \uc788\ub4ef\uc774, \uc2dc\uc791\uc77c\uacfc \uc885\ub8cc\uc77c \uc2dd\ubcc4\uc790\uc758 SQL\uc720\ud615\uc740 STRING \ud615\ud0dc\ub85c, \ub0a0\uc9dc\ub97c \u2018YYYYMMDD\u2019 \ud615\uc2dd\uc73c\ub85c \ucde8\uae09\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ucc38\uc870\ud558\ub294 \ud14c\uc774\ube14\uc5d0\uc11c\uc758 \ub0a0\uc9dc\ub294 DATE\ud0c0\uc785\uc73c\ub85c \uc800\uc7a5\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \uc81c\uacf5\ud558\ub294 \ud30c\ub77c\ubbf8\ud130\uc758 \ub370\uc774\ud130 \ud0c0\uc785\ub3c4 DATE\ud0c0\uc785\uc73c\ub85c \ub3d9\uc77c\ud558\uac8c \ub9de\ucdb0\uc8fc\uae30 \uc704\ud574 <code><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><strong>PARSE_DATE()<\/strong><\/mark><\/code> \ud568\uc218\ub97c \uc0ac\uc6a9\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=\"719\" height=\"141\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-5.png\" alt=\"\" class=\"wp-image-16874\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-5.png 719w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-5-300x59.png 300w\" sizes=\"auto, (max-width: 719px) 100vw, 719px\" \/><\/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\udca1PARSE_DATE() \uad6c\ubb38\uc758 \uc790\uc138\ud55c \uc0ac\uc6a9\ubc29\ubc95\uc740 \uad6c\uae00 \ud074\ub77c\uc6b0\ub4dc \ubb38\uc11c\ub97c \ucc38\uc870\ud558\uc138\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/cloud.google.com\/looker\/docs\/studio\/parsedate?hl=ko\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"129\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-1.png\" alt=\"\" class=\"wp-image-16875\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-1.png 392w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-1-300x99.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><\/figure>\n\n\n\n<p><a href=\"https:\/\/cloud.google.com\/looker\/docs\/studio\/parsedate\" target=\"_blank\" rel=\"noopener\" title=\"\">PARSE_DATE &nbsp;|&nbsp; Looker Studio &nbsp;|&nbsp; Google Cloud<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p><strong>(2) \uc120\ud0dd \uae30\uac04\uc758 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \ubd88\ub7ec\uc624\uae30<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \uc791\ub144 \ub3d9\uae30\uac04 \ub9e4\ucd9c \uac70\ub798\ucc98\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \nlastYearData  AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 YEAR) AS salesDate, shopName, SUM(revenue) AS lastYearRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 YEAR) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 YEAR)\n    GROUP BY salesDate, shopName\n),\n-- 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uac70\ub798\ucc98\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \noneMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 MONTH) AS salesDate, shopName, SUM(revenue) AS oneMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 MONTH) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 MONTH)\n    GROUP BY salesDate, shopName\n),\n-- 2\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uac70\ub798\ucc98\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \ntwoMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 2 MONTH) AS salesDate, shopName, SUM(revenue) AS twoMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 2 MONTH) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 2 MONTH)\n    GROUP BY salesDate, shopName\n),\n-- 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uac70\ub798\ucc98\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \nthreeMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 3 MONTH) AS salesDate, shopName, SUM(revenue) AS threeMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 3 MONTH) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 3 MONTH)\n    GROUP BY salesDate, shopName\n)<\/code><\/pre>\n\n\n\n<p><br>\uac01\uac01\uc758 CTE\ub97c \ud1b5\ud569\ud558\uae30 \uc704\ud574\uc11c\ub294 <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">JOIN<\/mark><\/strong><\/code> \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud574\uc57c \ud558\ub294\ub370, \ubb34\uc5c7\uc744 \uae30\uc900\uc73c\ub85c <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">JOIN<\/mark><\/strong><\/code> \ud560 \uac83\uc778\uc9c0 \uc870\uac74\uc774 \ud544\uc694\ud558\uc9c0\uc694. \uae30\uc900 \uc77c\uc790\ub97c \uc120\ud0dd \uae30\uac04 \uae30\uc900\uc73c\ub85c \ub9de\ucdb0\uc8fc\uae30 \uc704\ud574 \uac01\uac01\uc758 CTE\uc5d0\uc11c <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">DATE_ADD()<\/mark><\/strong><\/code> \ud568\uc218\uc640 <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">DATE_SUB()<\/mark><\/strong><\/code>\ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uae30\uc900 \uc77c\uc790\uc778 salesDate\ub97c \uc77c\uce58\uc2dc\ucf30\uc73c\ub2c8 \uc774\uc81c CTE\ub4e4\uc744 \ud1b5\ud569\ud558\uae30\ub9cc \ud558\uba74 \ub429\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\udca1DATE_SUB() \uad6c\ubb38\uc758 \uc790\uc138\ud55c \uc0ac\uc6a9 \ubc29\ubc95\uc740 \uad6c\uae00 \ud074\ub77c\uc6b0\ub4dc \ubb38\uc11c\ub97c \ucc38\uc870\ud558\uc138\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/date_functions#date_sub\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"129\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-3.png\" alt=\"\" class=\"wp-image-16877\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-3.png 392w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-3-300x99.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><\/figure>\n\n\n\n<p><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/date_functions#date_sub\" target=\"_blank\" rel=\"noopener\" title=\"\">Date functions &nbsp;|&nbsp; BigQuery &nbsp;|&nbsp; Google Cloud<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p><strong>(3) \ud14c\uc774\ube14 \ud1b5\ud569<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \uc804\uccb4 \uae30\uac04 \ub370\uc774\ud130 \ud1b5\ud569\ud558\uae30\nSELECT \n    COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate, m3.salesDate) AS salesDate,\n    COALESCE(c.shopName, l.shopName, m1.shopName, m2.shopName, m3.shopName) AS shopName,\n    COALESCE(c.currentRevenue, 0) AS currentRevenue,\n    COALESCE(l.lastYearRevenue, 0) AS lastYearRevenue,\n    COALESCE(m1.lastMonthRevenue, 0) AS lastMonthRevenue,\n    COALESCE(m2.twoMonthAgoRevenue, 0) AS twoMonthAgoRevenue,\n    COALESCE(m3.threeMonthAgoRevenue, 0) AS threeMonthAgoRevenue\nFROM current_sales c\nFULL OUTER JOIN lastYearData l \n    ON c.salesDate = l.salesDate AND c.shopName = l.shopName\nFULL OUTER JOIN oneMonthAgoData m1 \n    ON COALESCE(c.salesDate, l.salesDate) = m1.salesDate \n    AND COALESCE(c.shopName, l.shopName) = m1.shopName\nFULL OUTER JOIN twoMonthAgoData m2 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate) = m2.salesDate \n    AND COALESCE(c.shopName, l.shopName, m1.shopName) = m2.shopName\nFULL OUTER JOIN threeMonthAgoData m3 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate) = m3.salesDate \n    AND COALESCE(c.shopName, l.shopName, m1.shopName, m2.shopName) = m3.shopName\nORDER BY salesDate ASC, shopName ASC;<\/code><\/pre>\n\n\n\n<p><br>\uc774 \ucffc\ub9ac\ub294 \uc0dd\uc131\ud558\uc600\ub358 \uc120\ud0dd \uae30\uac04, 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c\uc744 \ud55c \ubc88\uc5d0 \ube44\uad50\ud560 \uc218 \uc788\ub3c4\ub85d <code><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code> \uad6c\ubb38\uc744 \uc774\uc6a9\ud574 \ub370\uc774\ud130\ub97c \uc815\ub9ac\ud558\ub294 \uacfc\uc815\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ud574\ub97c \ub3d5\uae30 \uc704\ud574 \uc120\ud0dd \uae30\uac04, \uc791\ub144 \ub3d9\uae30\uac04, 1\uac1c\uc6d4 \uc804 \ub3d9\uae30\uac04 CTE\ub97c \ud1b5\ud569\ud558\ub294 \uc6d0\ub9ac\ub97c \uc544\ub798\uc640 \uac19\uc774 \ub3c4\uc2dd\ud654\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc55e\uc11c <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">DATE_ADD()<\/mark><\/strong><\/code>\uc640 <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">DATE_SUB()<\/mark><\/strong><\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec salesDate\ub97c \uc77c\uce58\uc2dc\ucf30\uae30 \ub54c\ubb38\uc5d0 3\uac1c CTE\uc758 \uae30\uc900 \uc77c\uc790\uc758 \uc77c\uc790\uac00 \ubaa8\ub450 \uc120\ud0dd \uae30\uac04\uacfc \ub3d9\uc77c\ud569\ub2c8\ub2e4. \ub9e4\ucd9c\uc740 \uac01\uac01 \uc120\ud0dd\uae30\uac04\/\uc791\ub144\ub3d9\uae30\uac04\/1\uac1c\uc6d4\uc804\uc73c\ub85c \ub2e4\ub978 \uac12\uc744 \uac00\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ub807\uac8c salesDate\ub97c \uc77c\uce58\uc2dc\ud0a8 \ub4a4 \uc77c\uce58\uc2dc\ud0a8 \uae30\uc900 \uc77c\uc790\uc640 \uac70\ub798\ucc98\uba85\uc744 \ud0a4 \uac12\uc73c\ub85c \uc0ac\uc6a9\ud558\uc5ec \uac01\uac01\uc758 CTE\ub97c \ud1b5\ud569\ud558\ub294 \uac83\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=\"722\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-6-1024x722.png\" alt=\"\" class=\"wp-image-16878\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-6-1024x722.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-6-300x212.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-6-768x542.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-6.png 1093w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc720\uc758\ud560 \uc810\uc740 <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">FULL OUTER JOIN<\/mark><\/strong><\/code> \uad6c\ubb38\uacfc <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">COALESCE()<\/mark><\/strong><\/code> \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc600\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#fb1693\" class=\"has-inline-color\"><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">FULL OUTER JOIN<\/mark><\/strong><\/code><\/mark><\/strong><\/code> \uc740 \ub450 \ud14c\uc774\ube14\uc744 \uc870\uc778\ud560 \ub54c, <strong>\uc591\ucabd \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ud589\uc744 \ud3ec\ud568<\/strong>\ud569\ub2c8\ub2e4. \uc989, \ud55c\ucabd \ud14c\uc774\ube14\uc5d0\ub9cc \uc788\ub294 \ud589\ub3c4 \ubaa8\ub450 \uac00\uc838\uc624\uba70, <strong>\ub9e4\uce6d\ub418\uc9c0 \uc54a\ub294 \ud589\uc740<\/strong> <code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">NULL<\/mark><\/strong><\/code><strong>\ub85c \ud45c\uc2dc<\/strong>\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">COALESCE()<\/mark><\/strong><\/code><\/code> \ub294 \uc5ec\ub7ec \uac1c\uc758 \uc778\uc218\ub97c \ubc1b\uc544 <strong>\uc21c\ucc28\uc801\uc73c\ub85c \uac80\ud1a0\ud558\uc5ec<\/strong> <code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">NULL<\/mark><\/strong><\/code><\/code><strong>\uc774 \uc544\ub2cc \uac12\uc744 \ubc18\ud658<\/strong>\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\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<code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">FULL OUTER JOIN<\/mark><\/strong><\/code><\/code> \uad6c\ubb38\uacfc <code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">COALESCE()<\/mark><\/strong><\/code><\/code> \uad6c\ubb38\uc5d0 \ub300\ud574\uc11c\ub294 \uc544\ub798\uc758 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \ub354 \uc790\uc138\ud788 \uc124\uba85\ud558\uace0 \uc788\uc73c\ubbc0\ub85c \ucc38\uc870\ud574\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n<p><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><br><br>\uad6c\uae00\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uacf5\uc2dd \ub808\ud37c\ub7f0\uc2a4\ub294 \uc544\ub798\uc758 \ub9c1\ud06c\uc5d0\uc11c \ud655\uc778\ud574\uc8fc\uc138\uc694.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>COALESCE()<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/conditional_expressions#coalesce\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"129\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-4.png\" alt=\"\" class=\"wp-image-16879\" style=\"width:421px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-4.png 392w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-4-300x99.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><\/figure>\n\n\n\n<p><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/conditional_expressions#coalesce\" target=\"_blank\" rel=\"noopener\" title=\"\">Conditional expressions &nbsp;|&nbsp; BigQuery &nbsp;|&nbsp; Google Cloud<\/a><br><br><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>FULL OUTER JOIN<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax#full_join\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"129\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-5.png\" alt=\"\" class=\"wp-image-16880\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-5.png 392w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/Google-5-300x99.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><\/figure>\n\n\n\n<p><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax#full_join\" target=\"_blank\" rel=\"noopener\" title=\"\">Query syntax &nbsp;|&nbsp; BigQuery &nbsp;|&nbsp; Google Cloud<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br>\uc5ec\uae30\uc11c <code><code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">FULL OUTER JOIN<\/mark><\/strong><\/code><\/code> <\/code> \uad6c\ubb38\uc758 \uc870\uc778 \uc870\uac74\uc5d0 <code><code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">COALESCE()<\/mark><\/strong><\/code><\/code><\/code> \ub97c \uc0ac\uc6a9\ud55c \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694? \uc774 \ucffc\ub9ac\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ub97c \ub0a0\uc9dc\uc640 \uac70\ub798\ucc98\uba85\uc744 \uae30\uc900\uc73c\ub85c \ud1b5\ud569\ud558\ub294\ub370, \uac01 CTE\uc5d0 <strong>\ud574\ub2f9 \ub0a0\uc9dc\uc640 \uac70\ub798\ucc98\uba85\uc774 \ubaa8\ub450 \uc788\ub294 \uac83\uc774 \ubcf4\uc7a5\ub418\uc9c0 \uc54a\uae30 \ub54c\ubb38<\/strong>\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc5b4\ub5a4 \ub9e4\ucd9c \ub370\uc774\ud130\ub294 <code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">current_sales<\/mark><\/strong><\/code><\/code> CTE\uc5d0\ub9cc \uc788\uace0 \ub2e4\ub978 \ud14c\uc774\ube14\uc5d0\ub294 \uc5c6\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\ubc18\ub300\ub85c \uacfc\uac70 \ub9e4\ucd9c \ub370\uc774\ud130\ub9cc \uc788\uace0 \ud604\uc7ac \ub370\uc774\ud130\uac00 \uc5c6\uc744 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\uc774 \ubb38\uc81c\ub4e4\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub450 \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud55c \uac83\uc774\uc9c0\uc694.<\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4 2025\ub144 1\uc6d4 1\uc77c\ubd80\ud130 2025\ub144 1\uc6d4 31\uc77c \uae4c\uc9c0 \uae30\uac04\uc744 \uc120\ud0dd\ud588\uc744 \ub54c, 2025\ub144 1\uc6d4 15\uc77c\uc5d0 \ub9e4\ucd9c \ub370\uc774\ud130\uac00 \uc5c6\ub354\ub77c\ub3c4, 1\ub144 \uc804\uc778 2024\ub144 1\uc6d4 15\uc77c\uc5d0 \ub9e4\ucd9c \ub370\uc774\ud130\uac00 \uc788\ub2e4\uba74 \uadf8 \ub370\uc774\ud130\ub3c4 \uc804\ub144\ub3c4 \ub9e4\ucd9c \ubaa9\ub85d\uc5d0 \ubd88\ub7ec\uc640\uc57c \ud569\ub2c8\ub2e4. \uc544\ub798\uc640 \uac19\uc774 <code><code><code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">COALESCE()<\/mark><\/strong><\/code><\/code><\/code><\/code> \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc120\ud0dd \uae30\uac04 \ub9e4\ucd9c(o.slaesDate)\uc774 <code><code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">NULL<\/mark><\/strong><\/code><\/code><\/code>\uc774\ub77c\uba74 1\ub144 \uc804 \ub9e4\ucd9c(l.salesDate)\uc744 \ud655\uc778\ud558\uace0 \uadf8\uac83\ub3c4 <code><code><code><strong><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\">NULL<\/mark><\/strong><\/code><\/code><\/code>\uc774\ub77c\uba74 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c, \u2026 \uc21c\ucc28\uc801\uc73c\ub85c \ud655\uc778\ud558\uc5ec \uac12\uc774 \uc874\uc7ac\ud558\ub294 \ub0a0\uc9dc\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>COALESCE(o.salesDate, l.salesDate, m1.salesDate, m2.salesDate, m3.salesDate) AS salesDate<\/code><\/pre>\n\n\n\n<p><br>\uac19\uc740 \uc774\uc720\uc5d0\uc11c \uac70\ub798\ucc98\uba85\ub3c4 \ub611\uac19\uc774 \ucc98\ub9ac\ud574\uc57c \ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>COALESCE(c.shopName, l.shopName, m1.shopName, m2.shopName, m3.shopName) AS shopName<\/code><\/pre>\n\n\n\n<p><br>\ucffc\ub9ac\ub97c \ubaa8\ub450 \uc791\uc131\ud558\uc600\uc73c\ub2c8 \uc774\uc81c \ub370\uc774\ud130\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=\"661\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-7-1024x661.png\" alt=\"\" class=\"wp-image-16881\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-7-1024x661.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-7-300x194.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-7-768x495.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-7.png 1403w\" 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\uac01\uac01\uc758 \uceec\ub7fc\uba85\uc740 \uc544\ub798\uc758 \ub370\uc774\ud130 \uc18c\uc2a4 \uc218\uc815 \ud654\uba74\uc5d0\uc11c \ubcc0\uacbd\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=\"1010\" height=\"404\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-8.png\" alt=\"\" class=\"wp-image-16882\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-8.png 1010w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-8-300x120.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-8-768x307.png 768w\" sizes=\"auto, (max-width: 1010px) 100vw, 1010px\" \/><\/figure>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p>\ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ucd94\uac00\ud55c \ub4a4 \uceec\ub7fc\uba85\uc744 \uc218\uc815\ud558\uace0 \uc544\ub798\uc640 \uac19\uc774 \ucc28\ud2b8\ub97c \uc0dd\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774\uc81c \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\uc758 \uae30\uac04\uc744 \uc870\uc791\ud558\uba74 \ub9de\ucda4 \ucffc\ub9ac\ub97c \ud1b5\ud574\uc11c \ub9e4\uac1c\ubcc0\uc218\ub85c \uc804\ub2ec\ud558\uace0, \uc870\uac74\ubb38\uc5d0\uc11c \ud574\ub2f9 \uae30\uac04\uc744 \uc5f0\uc0b0\ud558\uc5ec \uac01 \uae30\uac04\uc5d0 \ub300\ud55c \ub9e4\ucd9c\uc744 \ubd88\ub7ec\uc624\uac8c \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"459\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-10-1024x459.png\" alt=\"\" class=\"wp-image-16883\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-10-1024x459.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-10-300x134.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-10-768x344.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-10-1536x689.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-10.png 1586w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uac70\ub798\ucc98\uc758 \uae30\uac04\ubcc4 \ub9e4\ucd9c \ube44\uad50 \ucc28\ud2b8\uac00 \uc644\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774\uc81c \ucc28\ud2b8\uc758 \ud5e4\ub354\ub97c \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5 \ud574\ubcfc\uae4c\uc694?<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2\">2. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud5e4\ub354 \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5\ud558\uae30<\/h2>\n\n\n\n<p><br>\uc544\ub798\uc758 \ucc28\ud2b8\ub294 \uac01 \uae30\uac04\uc758 \uad6c\ubd84\uc774 \uc2dc\uac01\uc801\uc73c\ub85c \uba85\ud655\ud558\uba70, \ube44\uad50\ud558\ub294 \uae30\uac04\uc5d0 \ub300\ud574\uc11c\ub3c4 \uba85\ud655\ud788 \ubcf4\uc5ec\uc8fc\uace0 \uc788\uc9c0\uc694. \uc774\ub807\uac8c \uc2dc\uac01\uc801\uc778 \uc694\uc18c\ub97c \uc801\uc808\ud788 \ucd94\uac00\ud558\uba74 <strong><mark style=\"background-color:#fcff82\" class=\"has-inline-color\">\ub300\uc2dc\ubcf4\ub4dc\uc758 \uac00\ub3c5\uc131\uc740 \ud6e8\uc52c \ub192\uc544\uc9d1\ub2c8\ub2e4.<\/mark><\/strong><br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"475\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-11-1024x475.png\" alt=\"\" class=\"wp-image-16884\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-11-1024x475.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-11-300x139.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-11-768x356.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-11-1536x712.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-11.png 1776w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc774\uc81c \uadf8 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-1\">2-1. \ub514\uc790\uc778 \uc785\ud788\uae30<\/h3>\n\n\n\n<p><br>\ud5e4\ub354\uc758 \uac01 \uc5f4\uc744 \uc0c9\uc0c1\uc73c\ub85c \uad6c\ubd84\ud558\uace0 \uc5f4 \uc774\ub984\uc744 \uc9c0\uc815\ud558\ub294 \uac83\uc740 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uc218\uc815 \ud654\uba74 \uc0c1\ub2e8\uc5d0 \uc788\ub294 \ud14d\uc2a4\ud2b8 \ubc15\uc2a4\uc640 \ub3c4\ud615 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"741\" height=\"152\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-12.png\" alt=\"\" class=\"wp-image-16885\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-12.png 741w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-12-300x62.png 300w\" sizes=\"auto, (max-width: 741px) 100vw, 741px\" \/><\/figure>\n\n\n\n<p><br>\uc544\ub798\uc640 \uac19\uc774 \ucc28\ud2b8\uc758 \ud5e4\ub354\uc5d0 \uc0c9\uc0c1\uc744 \ub123\uc740 \uc0ac\uac01\ud615 \ub3c4\ud615\uc744 \uc0bd\uc785\ud55c \ub4a4,<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"392\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-13-1024x392.png\" alt=\"\" class=\"wp-image-16886\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-13-1024x392.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-13-300x115.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-13-768x294.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-13.png 1243w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uadf8 \uc704\uc5d0 \ud14d\uc2a4\ud2b8 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc5f4 \uc774\ub984\uc744 \uc9c0\uc815\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=\"381\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-14-1024x381.png\" alt=\"\" class=\"wp-image-16887\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-14-1024x381.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-14-300x112.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-14-768x286.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-14.png 1240w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uadf8\ub9ac\uace0 \uadf8 \uc704\uc5d0 \ub0a0\uc9dc\uac00 \ud45c\uae30\ub418\ub294 \u2018<strong>\ud45c<\/strong>\u2019\ub97c \uc0bd\uc785\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc544\ub798\uc758 \uc774\ubbf8\uc9c0\uc5d0 \uc788\ub294 \uc22b\uc790 \ud45c\uc2dc\ub294 \uba87\uac1c\uc758 \ud45c\uac00 \uc0bd\uc785\ub418\uc5b4\uc788\ub294\uc9c0\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\uc5d0\uc11c \uc120\ud0dd\ud55c \ub0a0\uc9dc\ub97c \uae30\uc900\uc73c\ub85c \uc120\ud0dd \uae30\uac04\uc758 \uc2dc\uc791 \uc77c\uc790\uc640 \ub9c8\uc9c0\ub9c9 \uc77c\uc790, \uc791\ub144 \ub3d9\uae30\uac04\uc758 \uc2dc\uc791 \uc77c\uc790\uc640 \ub9c8\uc9c0\ub9c9 \uc77c\uc790\u2026. \uc774\ub807\uac8c \ucd1d 10\uac1c\uc758 \uc2dc\uc791\uc77c\uacfc \uc885\ub8cc\uc77c\uc744 \ud45c\uae30\ud558\uace0 \uc788\uc9c0\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"385\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-15-1024x385.png\" alt=\"\" class=\"wp-image-16888\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-15-1024x385.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-15-300x113.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-15-768x289.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-15.png 1237w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\uac00 \uc5b4\ub290 \ub0a0\uc9dc\ub97c \uc120\ud0dd\ud588\ub294\uc9c0\uc5d0 \ub530\ub77c \u2018<strong>\ud45c<\/strong>\u2019\uc758 \ub0a0\uc9dc\ub3c4 \ub3d9\uc801\uc73c\ub85c \ubcc0\uacbd\ub418\uc5b4\uc57c \ud558\uae30 \ub54c\ubb38\uc5d0 \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud574\uc57c\uaca0\uc8e0? \uc774\uc81c \ucc28\ud2b8\uc758 \ud5e4\ub354\uc5d0 \ub0a0\uc9dc\ub97c \ud45c\uae30\ud558\uae30 \uc704\ud55c \ub77c\ubca8\uc6a9 \ub9de\ucda4 \ucffc\ub9ac\ub97c \uc791\uc131\ud574\ubcf4\uaca0\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\ub3c4\ud615 \ub3c4\uad6c\uc640 \u2018<strong>\ud45c<\/strong>\u2019 \ucc28\ud2b8\ub97c \uc751\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \ub2e4\ub8e8\uc5c8\uc73c\ubbc0\ub85c \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\ub97c \uc77d\uc5b4\ubcf4\uc9c0 \uc54a\uc558\ub2e4\uba74 \uc544\ub798\uc758 \ud3ec\uc2a4\ud2b8\ub97c \uba3c\uc800 \uc77d\uc5b4\ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/12\/31\/%ec%b0%a8%ed%8a%b8-%ea%b0%80%eb%8f%85%ec%84%b1%ec%9d%84-%eb%86%92%ec%9d%b4%eb%8a%94-%eb%94%94%ec%9e%90%ec%9d%b8%ec%a0%81-%ec%9a%94%ec%86%8c%eb%a5%bc-%ec%b6%94%ea%b0%80%ed%95%98%eb%8a%94-%eb%b0%a9\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ucc28\ud2b8 \uac00\ub3c5\uc131\uc744 \ub192\uc774\ub294 \ub514\uc790\uc778\uc801 \uc694\uc18c\ub97c \ucd94\uac00\ud558\ub294 \ubc29\ubc95<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-2\">2-2. \ub0a0\uc9dc \ud45c\uae30\uc6a9 \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \uc791\uc131<\/h3>\n\n\n\n<p><br>\ub9de\ucda4 \ucffc\ub9ac\ub97c \uc785\ub825\ud558\ub294 \ud654\uba74\uc5d0\uc11c \u2018<strong>\uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \uc0ac\uc6a9 \uc124\uc815<\/strong>\u2019\uc744 \uccb4\ud06c\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=\"642\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-16-1024x642.png\" alt=\"\" class=\"wp-image-16889\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-16-1024x642.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-16-300x188.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-16-768x481.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-16.png 1288w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc120\ud0dd\ud55c \uc2dc\uc791 \ub0a0\uc9dc\uc640 \uc885\ub8cc \ub0a0\uc9dc\ub97c \ub9e4\uac1c\ubcc0\uc218\ub85c \ubc1b\uc73c\uba74 \uadf8 \ub0a0\uc9dc\ub97c \uae30\uc900\uc73c\ub85c \uacc4\uc0b0\ud558\uc5ec \uac01 \uc5f4\uc758 \uc2dc\uc791 \ub0a0\uc9dc\uc640 \uc885\ub8cc \ub0a0\uc9dc\ub97c \uad6c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud544\uc694\ud55c \uac12\uc774 10\uac1c\ub77c\uace0 \ud558\uc600\uc9c0\uc694?<\/p>\n\n\n\n<p>1\ufe0f\u20e3: \uc120\ud0dd \uae30\uac04\uc758 \uc2dc\uc791 \uc77c\uc790<\/p>\n\n\n\n<p>2\ufe0f\u20e3: \uc120\ud0dd \uae30\uac04\uc758 \uc885\ub8cc \uc77c\uc790<\/p>\n\n\n\n<p>3\ufe0f\u20e3: 1\ub144 \uc804 \uc2dc\uc791 \uc77c\uc790<\/p>\n\n\n\n<p>4\ufe0f\u20e3: 1\ub144 \uc804 \uc885\ub8cc \uc77c\uc790<\/p>\n\n\n\n<p>5\ufe0f\u20e3: 1\uac1c\uc6d4 \uc804 \uc2dc\uc791 \uc77c\uc790<\/p>\n\n\n\n<p>6\ufe0f\u20e3: 1\uac1c\uc6d4 \uc804 \uc885\ub8cc \uc77c\uc790<\/p>\n\n\n\n<p>7\ufe0f\u20e3: 2\uac1c\uc6d4 \uc804 \uc2dc\uc791 \uc77c\uc790<\/p>\n\n\n\n<p>8\ufe0f\u20e3: 2\uac1c\uc6d4 \uc804 \uc885\ub8cc \uc77c\uc790<\/p>\n\n\n\n<p>9\ufe0f\u20e3: 3\uac1c\uc6d4 \uc804 \uc2dc\uc791 \uc77c\uc790<\/p>\n\n\n\n<p>\ud83d\udd1f: 3\uac1c\uc6d4 \uc804 \uc885\ub8cc \uc77c\uc790<\/p>\n\n\n\n<p><br>\uac01 \uae30\uac04\uc744 SELECT\ud558\ub294 \ucffc\ub9ac\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \uc791\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WITH SelectedPeriod AS (\n  -- \uc785\ub825\ub41c \uae30\uac04\uc758 \uc2dc\uc791\uc77c\uacfc \uc885\ub8cc\uc77c\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4.\n  SELECT\n    PARSE_DATE('%Y%m%d', @DS_START_DATE) AS start_date,\n    PARSE_DATE('%Y%m%d', @DS_END_DATE) AS end_date\n)\n\n-- \uc120\ud0dd\ud55c \uae30\uac04\uc758 \uc2dc\uc791\uc77c\uacfc \uc885\ub8cc\uc77c, \uadf8\ub9ac\uace0 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804\uc758 \uc2dc\uc791\uc77c\uacfc \uc885\ub8cc\uc77c\uc744 \ucd9c\ub825\ud569\ub2c8\ub2e4.\nSELECT\n    start_date,\n    end_date,\n    DATE_SUB(start_date, INTERVAL 1 YEAR) AS previousYearStart,\n    DATE_SUB(end_date, INTERVAL 1 YEAR) AS previousYearEnd,\n    DATE_SUB(start_date, INTERVAL 1 MONTH) AS previousMonth1Start,\n    DATE_SUB(end_date, INTERVAL 1 MONTH) AS previousMonth1End,\n    DATE_SUB(start_date, INTERVAL 2 MONTH) AS previousMonth2Start,\n    DATE_SUB(end_date, INTERVAL 2 MONTH) AS previousMonth2End,\n    DATE_SUB(start_date, INTERVAL 3 MONTH) AS previousMonth3Start,\n    DATE_SUB(end_date, INTERVAL 3 MONTH) AS previousMonth3End\nFROM\n    SelectedPeriod<\/code><\/pre>\n\n\n\n<p><br>(1) <mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><code><strong>SelectedPeriod<\/strong><\/code> <\/mark>CTE\uc5d0\uc11c \ub9e4\uac1c\ubcc0\uc218\ub85c \ubc1b\uc740 \uac12\uc744 \ud30c\uc2f1\ud569\ub2c8\ub2e4. \ub9e4\uac1c\ubcc0\uc218\ub97c \ubb38\uc790\uc5f4 \ud615\ud0dc\ub85c \ubc1b\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0 SQL\uc5d0\uc11c \ub0a0\uc9dc\ub85c \uc778\uc2dd\ud560 \uc218 \uc788\ub3c4\ub85d \ub0a0\uc9dc \ud615\uc2dd\uc73c\ub85c \ud30c\uc2f1\ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ucffc\ub9ac\uc5d0\uc11c\ub294 \ub9e4\uac1c\ubcc0\uc218\ub97c \ub0a0\uc9dc \ud615\uc2dd\uc73c\ub85c \ud30c\uc2f1 \ud6c4 <mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><code><strong>AS<\/strong><\/code><\/mark> \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec <mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><code><strong>start_date<\/strong><\/code><\/mark>, <code><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><code><strong>end_date<\/strong><\/code><\/mark><\/code> \ub85c \uc815\uc758\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>(2) <code><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><code><strong>SelectedPeriod<\/strong><\/code> <\/mark><\/code> CTE\uc5d0\uc11c \uc2dc\uc791\uc77c(<code><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><code><strong>start_date<\/strong><\/code><\/mark><\/code>)\uc640 \uc885\ub8cc\uc77c(<code><code><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><code><strong>end_date<\/strong><\/code><\/mark><\/code><\/code>)\uc744 \uae30\uc900\uc73c\ub85c \ub0a0\uc9dc\ub97c \uacc4\uc0b0\ud558\uc5ec SELECT \ud569\ub2c8\ub2e4. \ud2b9\uc815 \ub0a0\uc9dc\uc5d0\uc11c \uc77c\uc815\ud55c \uae30\uac04\ub9cc\ud07c \u2018\ube7c\uae30\u2019\ub97c \uc218\ud589\ud558\ub294<code> <code><mark style=\"background-color:#fcff82;color:#fb1693\" class=\"has-inline-color\"><code><strong>DATE_SUB()<\/strong><\/code><\/mark><\/code><\/code> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac01 \ub0a0\uc9dc\ub97c \uacc4\uc0b0\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-2\">2-2. \ud45c \uc0bd\uc785<\/h3>\n\n\n\n<p><br>\ub9de\ucda4 \ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ucd94\uac00\ud55c \ub4a4 \ud45c\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4. \ud45c\ub97c \ub514\uc790\uc778 \uc694\uc18c\ub85c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc758 \uc124\uc815\uc740 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \ub2e4\ub8e8\uc5c8\uc73c\ubbc0\ub85c \uac04\ub2e8\ud788 \uc9da\uace0 \ub118\uc5b4\uac00\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=\"437\" height=\"319\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-17.png\" alt=\"\" class=\"wp-image-16890\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-17.png 437w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-17-300x219.png 300w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/><\/figure>\n<\/div>\n\n\n<p><br>\ud45c \ucd94\uac00 \ud6c4 \uc2a4\ud0c0\uc77c \uc635\uc158\uc5d0\uc11c \u2018<strong>\ud5e4\ub354 \ubcf4\uae30<\/strong>\u2019 \uc640 \u2018<strong>\ud589 \ubc88\ud638<\/strong>\u2019\ub97c \uccb4\ud06c \ud574\uc81c\ud569\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=\"355\" height=\"689\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-18.png\" alt=\"\" class=\"wp-image-16891\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-18.png 355w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-18-155x300.png 155w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/figure>\n<\/div>\n\n\n<p><br>\ud45c \ucc28\ud2b8\uc758 \uc124\uc815 \uc635\uc158\uc5d0\uc11c \ud589 \ud45c\uc2dc \uc635\uc158\uc744 \uc544\ub798\uc640 \uac19\uc774 \u2018<strong>\uc0c1\uc704 \ud589\ub9cc \ud45c\uc2dc<\/strong>\u2019 \ub85c \uc124\uc815\ud569\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=\"351\" height=\"416\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-19.png\" alt=\"\" class=\"wp-image-16892\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-19.png 351w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-19-253x300.png 253w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/figure>\n<\/div>\n\n\n<p><br>\ud45c \uc0ac\uc774\uc988\ub97c \ucd5c\uc18c\ud654\ud55c \ub4a4, \uce21\uc815 \uae30\uc900\uc5d0 \uac01 \ub0a0\uc9dc\ub97c \uc0bd\uc785\ud558\uc5ec \uc801\uc808\ud55c \uc704\uce58\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=\"588\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-20-1024x588.png\" alt=\"\" class=\"wp-image-16893\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-20-1024x588.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-20-300x172.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-20-768x441.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-20.png 1422w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc774\ub807\uac8c \ubaa8\ub4e0 \uc5f4\uc5d0 \ub0a0\uc9dc\ub97c \uc0bd\uc785\ud558\uba74 \uc544\ub798\uc640 \uac19\uc740 \ucc28\ud2b8\uac00 \uc644\uc131\ub429\ub2c8\ub2e4. \uc774\uc81c \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\uc758 \ub0a0\uc9dc\ub97c \ubcc0\uacbd\ud558\uba74 \ubaa8\ub4e0 \ud5e4\ub354\uc758 \ub0a0\uc9dc\ub3c4 \ub3d9\uc801\uc73c\ub85c \ubcc0\uacbd\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"480\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-21-1024x480.png\" alt=\"\" class=\"wp-image-16894\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-21-1024x480.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-21-300x141.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-21-768x360.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-21-1536x720.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-21.png 1779w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br>\uc624\ub298\uc740 \uac70\ub798\ucc98\ubcc4 \ub9e4\ucd9c\uc758 \uae30\uac04\ubcc4 \ube44\uad50\ub97c \uc704\ud55c \ub9de\ucda4 \ucffc\ub9ac\uc640 \ud5e4\ub354\ub97c \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5 \ud558\uae30 \uc704\ud55c \ub9de\ucda4 \ucffc\ub9ac\ub97c \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \ubcf5\uc7a1\ud55c \ucffc\ub9ac\ub97c \ub2e4\ub8f0\uc904 \uc544\ub294 \uac83 \ub9cc\ud07c \uc911\uc694\ud55c \uac83\uc740 \uc5bc\ub9c8\ub098 \uc9c1\uad00\uc801\uc73c\ub85c \ub300\uc2dc\ubcf4\ub4dc\ub97c \ubcf4\uc5ec\uc8fc\ub290\ub0d0 \ud558\ub294 \uac83\uc774\uc9c0\uc694. \ub9de\ucda4 \ucffc\ub9ac\uc640 \ub514\uc790\uc778 \uc694\uc18c\ub97c \uc801\uc808\ud788 \ud65c\uc6a9\ud558\uba74 \ub370\uc774\ud130\uc758 \uc804\ub2ec\ub825\uacfc \uac00\ub3c5\uc131\uc744 \ub3d9\uc2dc\uc5d0 \ub04c\uc5b4\uc62c\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uc81c \uc5ec\ub7ec\ubd84\uc758 \ub300\uc2dc\ubcf4\ub4dc\uc5d0\ub3c4 \uc624\ub298 \uc0b4\ud3b4\ubcf8 \ub0b4\uc6a9\ub4e4\uc744 \uc9c1\uc811 \uc801\uc6a9\ud574\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4!<\/p>\n\n\n\n<p>\ub2e4\uc74c \ud3ec\uc2a4\ud2b8\ub294 \ub9e4\uac1c\ubcc0\uc218 \uae30\ub2a5\uc744 \uc751\uc6a9\ud558\uc5ec \ub4dc\ub86d\ub2e4\uc6b4\uc744 \ud1b5\ud574 \uce21\uc815 \uae30\uc900\uc744 \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/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\/05\/image-27.png\" alt=\"\" class=\"wp-image-17107\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-27.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/05\/image-27-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<p><br><\/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><\/p>\n\n\n\n<p><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><br><br><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc5d0 \ub300\ud55c \uae30\ubcf8 \uac1c\ub150\uacfc \uc0ac\uc6a9 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\uc600\uc2b5\ub2c8\ub2e4. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ud65c\uc6a9\ud558\uae30 \u2013 \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \u2018\ub9de\ucda4 \ucffc\ub9ac\u2019 \ub610\ub294 \u2018\ucee4\uc2a4\ud140 \ucffc\ub9ac\u2019\ub77c\uace0\ub3c4 \ud558\ub294\ub370 \uc774 \uae30\ub2a5\uc740 \ube45\ucffc\ub9ac\uc5d0\uc11c \uc2e4\ud589\ud560 SQL\ubb38\uc744 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uc791\uc131\ud55c \ub4a4\uc5d0, \ube45\ucffc\ub9ac\uc5d0\uc11c \uc2e4\ud589\ud574\uc11c \uadf8 \uacb0\uacfc\ub97c \ubc1b\uc544\uc640\uc11c \ud65c\uc6a9\ud558\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4. \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\ub098 \ud544\ud130 \uae30\ub2a5\uc744 \ud1b5\ud574\uc11c \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \uc870\uc791\ud558\uba74 \uc6d0\ud558\ub294 \ub370\uc774\ud130\ub97c \ub3d9\uc801\uc73c\ub85c \ubd88\ub7ec\uc62c \uc218&#8230;<\/p>\n","protected":false},"author":6,"featured_media":16895,"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":[69,551,42,568,7,100,546,559,54,12],"class_list":["post-16867","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lookerstudio","category-bigquery","tag-script","tag-autooffice","tag-bigquery","tag-lookerstudio","tag-spreadsheet","tag-100","tag-546","tag-559","tag-54","tag-12"],"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\/16867","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=16867"}],"version-history":[{"count":8,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16867\/revisions"}],"predecessor-version":[{"id":17120,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16867\/revisions\/17120"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/16895"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=16867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=16867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=16867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}