{"id":11041,"date":"2024-12-14T03:31:19","date_gmt":"2024-12-13T18:31:19","guid":{"rendered":"https:\/\/www.stechstar.com\/user\/wordpress\/?p=11041"},"modified":"2026-08-17T09:19:36","modified_gmt":"2026-08-17T00:19:36","slug":"chatgpt-chatgpt%eb%a5%bc-%ed%99%9c%ec%9a%a9%ed%95%9c-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%84%a4%ea%b3%84-%eb%b0%8f-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b6%84%ec%84%9d-%ec%bf%bc","status":"publish","type":"post","link":"https:\/\/www.stechstar.com\/user\/wordpress\/chatgpt-chatgpt%eb%a5%bc-%ed%99%9c%ec%9a%a9%ed%95%9c-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%84%a4%ea%b3%84-%eb%b0%8f-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b6%84%ec%84%9d-%ec%bf%bc\/","title":{"rendered":"[chatGPT] ChatGPT\ub97c \ud65c\uc6a9\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ub370\uc774\ud130\ubd84\uc11d \ucffc\ub9ac \uc2e4\uc2b5 \uc0ac\ub840 &#8211; eCommerce \ud50c\ub7ab\ud3fc\uc744 \uc704\ud55c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc124\uacc4"},"content":{"rendered":"<h1>[chatGPT] ChatGPT\ub97c \ud65c\uc6a9\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ub370\uc774\ud130\ubd84\uc11d \ucffc\ub9ac \uc2e4\uc2b5 \uc0ac\ub840 &#8211; eCommerce \ud50c\ub7ab\ud3fc\uc744 \uc704\ud55c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc124\uacc4<\/h1>\n<p>\uc624\ub298\uc740 ChatGPT\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ub370\uc774\ud130 \ubd84\uc11d \ucffc\ub9ac\ub97c \ub9cc\ub4dc\ub370 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud55c \uccab\ubc88\uc9f8 \ub0b4\uc6a9\uc73c\ub85c \uc774 \uae00\uc5d0\uc11c\ub294 ChatGPT\ub97c \ud65c\uc6a9\ud558\uc5ec eCommerce \ud50c\ub7ab\ud3fc\uc744 \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ub370\uc774\ud130 \ubd84\uc11d \ucffc\ub9ac\ub97c \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"1-\uc694\uad6c\uc0ac\ud56d-\ubd84\uc11d\" class=\"anchor anchorWithStickyNavbar_LWe7\">1. \uc694\uad6c\uc0ac\ud56d \ubd84\uc11d<a class=\"hash-link\" title=\"Direct link to 1. \uc694\uad6c\uc0ac\ud56d \ubd84\uc11d\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#1-%EC%9A%94%EA%B5%AC%EC%82%AC%ED%95%AD-%EB%B6%84%EC%84%9D\" aria-label=\"Direct link to 1. \uc694\uad6c\uc0ac\ud56d \ubd84\uc11d\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#1-%EC%9A%94%EA%B5%AC%EC%82%AC%ED%95%AD-%EB%B6%84%EC%84%9D\">\u200b<\/a><\/h2>\n<p>eCommerce \ud50c\ub7ab\ud3fc \uac1c\ubc1c\uc744 \uc704\ud574 \uac00\uc7a5 \uba3c\uc800 \ud544\uc694\ud55c \uc791\uc5c5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub97c \uc704\ud55c \uc694\uad6c \uc0ac\ud56d\uc744 \ud30c\uc545 \ud558\ub294 \uc77c\uc785\ub2c8\ub2e4. \uc2e4\uc81c \uc694\uad6c\uc0ac\ud56d \ubd84\uc11d \ub2e8\uacc4\ub294 \uace0\uac1d\uc0ac\uc758 \ub2c8\uc988\ub97c \ud30c\uc545\ud558\uace0 \uc0ac\uc6a9\uc790 \uc2dc\ub098\ub9ac\uc624 \ubd84\uc11c, \uc131\ub2a5, \ud655\uc7a5\uc131 \ub4f1 \ub2e4\uc591\ud55c \uc870\uc0ac\uc640 \uc791\uc5c5\ub4e4\uc774 \ud544\uc694\ud558\uc9c0\ub9cc \uc624\ub298\uc740 ChatGPT\ub97c \ud1b5\ud574 \uc77c\ubc18\uc801\uc778 \uc694\uad6c \uc0ac\ud56d\uc744 \ud655\uc778\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. ChatGPT\uc5d0\uac8c \uba3c\uc800 eCommerce \ud50c\ub7ab\ud3fc \uac1c\ubc1c\uc744 \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub97c \uc704\ud55c \uc694\uad6c \uc0ac\ud56d\uc744 \ud655\uc778\ud574\ubd05\ub2c8\ub2e4.<\/p>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">eCommerce \ud50c\ub7ab\ud3fc \uac1c\ubc1c\uc744 \uc704\ud55c DB \uc124\uacc4 \uc694\uad6c \uc0ac\ud56d\uc744 \uc815\ub9ac \ud574\uc918<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/9134547ff914c4744f30baa2e88f869c.png\" alt=\"01. pic1-507426aed497b8dfbc1fdc3e7e3e9d17.png\" data-file-srl=\"105044\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/9134547ff914c4744f30baa2e88f869c.png\"><\/p>\n<h2 id=\"2-\ub370\uc774\ud130\ubca0\uc774\uc2a4-\uc124\uacc4-\ubc0f-\ud14c\uc774\ube14-\uc0dd\uc131\" class=\"anchor anchorWithStickyNavbar_LWe7\">2. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ud14c\uc774\ube14 \uc0dd\uc131<a class=\"hash-link\" title=\"Direct link to 2. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ud14c\uc774\ube14 \uc0dd\uc131\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#2-%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4-%EC%84%A4%EA%B3%84-%EB%B0%8F-%ED%85%8C%EC%9D%B4%EB%B8%94-%EC%83%9D%EC%84%B1\" aria-label=\"Direct link to 2. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ud14c\uc774\ube14 \uc0dd\uc131\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#2-%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4-%EC%84%A4%EA%B3%84-%EB%B0%8F-%ED%85%8C%EC%9D%B4%EB%B8%94-%EC%83%9D%EC%84%B1\">\u200b<\/a><\/h2>\n<h3 id=\"1-\uc124\uacc4\" class=\"anchor anchorWithStickyNavbar_LWe7\">1) \uc124\uacc4<a class=\"hash-link\" title=\"Direct link to 1) \uc124\uacc4\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#1-%EC%84%A4%EA%B3%84\" aria-label=\"Direct link to 1) \uc124\uacc4\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#1-%EC%84%A4%EA%B3%84\">\u200b<\/a><\/h3>\n<p>\uc704\uc5d0\uc11c \uc694\uad6c\uc0ac\ud56d\uc744 \ud30c\uc545 \ud55c \uac83 \ucc98\ub7fc eCommerce \ud50c\ub7ab\ud3fc\uc744 \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc0ac\uc6a9\uc790 \uc815\ubcf4, \uc81c\ud488 \uc815\ubcf4, \uc8fc\ubb38 \uc815\ubcf4, \uacb0\uc81c \uc815\ubcf4, \ubc30\uc1a1 \uc815\ubcf4, \ub9ac\ubdf0 \ubc0f \ud3c9\uc810, \uc7a5\ubc14\uad6c\ub2c8 \uc815\ubcf4 \ub4f1\uc744 \uad00\ub9ac\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc815\ubcf4\ub97c \uad00\ub9ac\ud558\uae30 \uc704\ud574 \ub2e4\uc74c\uacfc \uac19\uc740 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li>Users<\/li>\n<li>Products<\/li>\n<li>Orders<\/li>\n<li>OrderDetails<\/li>\n<li>Payments<\/li>\n<li>Shipping<\/li>\n<li>Reviews<\/li>\n<li>Cart<\/li>\n<\/ul>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">eCommerce \ud50c\ub7ab\ud3fc \uac1c\ubc1c\uc744 \uc704\ud55c DB table \ub4e4\uc744 \uc815\ub9ac \ud574\uc918<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/856ca40631d91945594070a9d6b1721a.png\" alt=\"02. pic2-eb33c323f111cbcd32f9fef80f6c19b9.png\" data-file-srl=\"105045\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/856ca40631d91945594070a9d6b1721a.png\"><\/p>\n<h3 id=\"2-erd-\uc791\uc131\" class=\"anchor anchorWithStickyNavbar_LWe7\">2) ERD \uc791\uc131<a class=\"hash-link\" title=\"Direct link to 2) ERD \uc791\uc131\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#2-erd-%EC%9E%91%EC%84%B1\" aria-label=\"Direct link to 2) ERD \uc791\uc131\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#2-erd-%EC%9E%91%EC%84%B1\">\u200b<\/a><\/h3>\n<p>\uc774\ub7ec\ud55c \ud14c\uc774\ube14 \uac04\uc758 \uad00\uacc4\ub294 ERD(Entity Relationship Diagram)\ub97c \ud1b5\ud574 \uc2dc\uac01\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. ERD\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14 \uac04\uc758 \uad00\uacc4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ub3c4\uad6c\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \uacfc\uc815\uc5d0\uc11c \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. eCommerce\uc758 \ud14c\uc774\ube14 \uac04\uc758 \uad00\uacc4\ub97c \ud30c\uc545\ud558\uae30 \uc704\ud55c ERD\ub97c \uadf8\ub824\ubcf4\uace0 \uc704\uc758 \ud14c\uc774\ube14\ub4e4\uc744 \ub9cc\ub4e4\uace0 ERD<\/p>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">\uc704\uc758 \ud14c\uc774\ube14 \ubaa9\ub85d\uc744 \uae30\ubc18\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 ERD\ub97c \uadf8\ub824\uc918<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/860b531b21b54cd9f7c6c1f7cb95cfc1.png\" alt=\"03 ecommerce-database-design-pic3-fbb9e60ae5f87c499817afb5ae11e829.png\" data-file-srl=\"105046\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/860b531b21b54cd9f7c6c1f7cb95cfc1.png\"><\/p>\n<p>\ucc38\uace0\ub85c ERD\ub97c \uadf8\ub9ac\uae30 \uc704\ud574\uc11c\ub294 Show Me \ub77c\ub294 ChatGPT \ud50c\ub7ec\uadf8\uc778\uc744 \uc124\uce58 \ud558\uc154\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li>ChatGPT \ud50c\ub7ec\uadf8\uc778 \uc124\uce58 \ubc0f \uc0ac\uc6a9 \ubc29\ubc95\uc740&nbsp;<a href=\"https:\/\/www.developerfastlane.com\/blog\/how-to-use-chatgpt-plugins\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/blog\/how-to-use-chatgpt-plugins\">ChatGPT \ud50c\ub7ec\uadf8\uc778(Plugin) \uc0ac\uc6a9\ubc29\ubc95 \ubc0f \ud65c\uc6a9 \uc608\uc2dc<\/a>&nbsp;\uc5d0\uc11c \ud655\uc778 \ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h2 id=\"3-\ub370\uc774\ud130\ubca0\uc774\uc2a4-\ucffc\ub9ac-\uc791\uc131\" class=\"anchor anchorWithStickyNavbar_LWe7\">3. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac \uc791\uc131<a class=\"hash-link\" title=\"Direct link to 3. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac \uc791\uc131\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#3-%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4-%EC%BF%BC%EB%A6%AC-%EC%9E%91%EC%84%B1\" aria-label=\"Direct link to 3. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac \uc791\uc131\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#3-%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4-%EC%BF%BC%EB%A6%AC-%EC%9E%91%EC%84%B1\">\u200b<\/a><\/h2>\n<p>\uba3c\uc800 ChatGPT\ub85c \uc704\uc758 \uc694\uad6c\uc0ac\ud56d \ubd84\uc11d \ubc0f ERD \uc791\uc131\uc744 \ud1b5\ud574 \ub3c4\ucd9c\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uae30 \uc704\ud55c \ucffc\ub9ac\ub97c \ub9cc\ub4e4\uc5b4\ubd05\ub2c8\ub2e4.<\/p>\n<h3 id=\"1-\ud14c\uc774\ube14-\uc0dd\uc131-\ucffc\ub9ac\" class=\"anchor anchorWithStickyNavbar_LWe7\">1) \ud14c\uc774\ube14 \uc0dd\uc131 \ucffc\ub9ac<a class=\"hash-link\" title=\"Direct link to 1) \ud14c\uc774\ube14 \uc0dd\uc131 \ucffc\ub9ac\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#1-%ED%85%8C%EC%9D%B4%EB%B8%94-%EC%83%9D%EC%84%B1-%EC%BF%BC%EB%A6%AC\" aria-label=\"Direct link to 1) \ud14c\uc774\ube14 \uc0dd\uc131 \ucffc\ub9ac\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#1-%ED%85%8C%EC%9D%B4%EB%B8%94-%EC%83%9D%EC%84%B1-%EC%BF%BC%EB%A6%AC\">\u200b<\/a><\/h3>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">\uc704\uc758 \ud14c\uc774\ube14 \uc0dd\uc131\uc744 \uc704\ud55c mysql \ucffc\ub9ac\ub97c \uc791\uc131\ud574\uc918<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/8f188fed0259f7c246a291d1ea5a203b.png\" alt=\"04 pic4-01fa31d2245a2d52607f9d9a2ed26a8c.png\" data-file-srl=\"105047\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/8f188fed0259f7c246a291d1ea5a203b.png\"><\/p>\n<h3 id=\"2-\uc8fc\uc694-\ub3d9\uc791operation-\ucffc\ub9ac\" class=\"anchor anchorWithStickyNavbar_LWe7\">2) \uc8fc\uc694 \ub3d9\uc791(Operation) \ucffc\ub9ac<a class=\"hash-link\" title=\"Direct link to 2) \uc8fc\uc694 \ub3d9\uc791(Operation) \ucffc\ub9ac\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#2-%EC%A3%BC%EC%9A%94-%EB%8F%99%EC%9E%91operation-%EC%BF%BC%EB%A6%AC\" aria-label=\"Direct link to 2) \uc8fc\uc694 \ub3d9\uc791(Operation) \ucffc\ub9ac\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#2-%EC%A3%BC%EC%9A%94-%EB%8F%99%EC%9E%91operation-%EC%BF%BC%EB%A6%AC\">\u200b<\/a><\/h3>\n<p>\ud14c\uc774\ube14 \uc0dd\uc131 \ud6c4\uc5d0\ub294 MySQL \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790 \uc0dd\uc131, \uc81c\ud488 \uc870\ud68c, \uc8fc\ubb38 \uc5c5\ub370\uc774\ud2b8, \uacb0\uc81c \uc815\ubcf4 \uc870\ud68c, \ubc30\uc1a1 \uc815\ubcf4 \uc0dd\uc131, \ub9ac\ubdf0 \uc791\uc131, \uc7a5\ubc14\uad6c\ub2c8\uc5d0 \uc81c\ud488 \ucd94\uac00, \uc7a5\ubc14\uad6c\ub2c8\uc5d0\uc11c \uc81c\ud488 \uc0ad\uc81c, \uc7a5\ubc14\uad6c\ub2c8 \uc870\ud68c \ub4f1\uc758 \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \ub370 \ud544\uc694\ud55c \uae30\ubcf8\uc801\uc778 \ucffc\ub9ac\ub97c \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uba3c\uc800 ChatGPTfh \uc8fc\uc694 \ub3d9\uc791(Operation)\ub4e4\uc744 \uc815\ub9ac\ud574\ubd05\ub2c8\ub2e4.<\/p>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">\uc8fc\uc694 operation \ub4e4\uc744 \uc815\ub9ac \ud574\uc918<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/9dd6d7a28cef396c0e847a17b5d1d222.png\" alt=\"05 pic5-1550d712be796c2c2e36e04db78f37fe.png\" data-file-srl=\"105048\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/9dd6d7a28cef396c0e847a17b5d1d222.png\"><\/p>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">\uc704\uc5d0\uc11c \uc815\ub9ac\ud574\uc900 \uc8fc\uc694 \ub3d9\uc791(Operation)\uc744 \uc704\ud55c mysql \ucffc\ub9ac\ub97c \uc815\ub9ac \ud574\uc918<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/da1db9eb8ad7f509964b3e9430ada099.png\" alt=\"06 pic6-cfd31c44115bf9de63912dcddf754934.png\" data-file-srl=\"105049\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/da1db9eb8ad7f509964b3e9430ada099.png\"><\/p>\n<h3 id=\"3-\uc8fc\uc694-\ub3d9\uc791operation-\uc0c1\ud0dc-\uad00\ub9ac-\ubc0f-\uc0c1\ud0dc-\ub2e4\uc774\uc5b4\uadf8\ub7a8\" class=\"anchor anchorWithStickyNavbar_LWe7\">3) \uc8fc\uc694 \ub3d9\uc791(Operation) \uc0c1\ud0dc \uad00\ub9ac \ubc0f \uc0c1\ud0dc \ub2e4\uc774\uc5b4\uadf8\ub7a8<a class=\"hash-link\" title=\"Direct link to 3) \uc8fc\uc694 \ub3d9\uc791(Operation) \uc0c1\ud0dc \uad00\ub9ac \ubc0f \uc0c1\ud0dc \ub2e4\uc774\uc5b4\uadf8\ub7a8\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#3-%EC%A3%BC%EC%9A%94-%EB%8F%99%EC%9E%91operation-%EC%83%81%ED%83%9C-%EA%B4%80%EB%A6%AC-%EB%B0%8F-%EC%83%81%ED%83%9C-%EB%8B%A4%EC%9D%B4%EC%96%B4%EA%B7%B8%EB%9E%A8\" aria-label=\"Direct link to 3) \uc8fc\uc694 \ub3d9\uc791(Operation) \uc0c1\ud0dc \uad00\ub9ac \ubc0f \uc0c1\ud0dc \ub2e4\uc774\uc5b4\uadf8\ub7a8\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#3-%EC%A3%BC%EC%9A%94-%EB%8F%99%EC%9E%91operation-%EC%83%81%ED%83%9C-%EA%B4%80%EB%A6%AC-%EB%B0%8F-%EC%83%81%ED%83%9C-%EB%8B%A4%EC%9D%B4%EC%96%B4%EA%B7%B8%EB%9E%A8\">\u200b<\/a><\/h3>\n<p>\uc8fc\ubb38 \uad00\ub9ac, \uacb0\uc81c \uad00\ub9ac, \ubc30\uc1a1 \uad00\ub9ac\uc758 \uacbd\uc6b0 \uc0c1\ud0dc\uad00\ub9ac\uac00 \uc911\uc694\ud55c \ud14c\uc774\ube14 \ub4e4\uc774\ub77c \uc0c1\ud0dc \uad00\ub9ac\ub97c \uc704\ud55c \uc0c1\ud0dc \ub4e4\uc744 \uc815\uc758 \ud574\ub2ec\ub77c\uace0 \uc694\uccad \ud569\ub2c8\ub2e4.<\/p>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">\uc8fc\ubb38 \uad00\ub9ac, \uacb0\uc81c \uad00\ub9ac, \ubc30\uc1a1 \uad00\ub9ac \uc0c1\ud0dc \uad00\ub9ac\ub97c \uc704\ud55c \uc0c1\ud0dc \ub4e4\uc744 \uc815\ub9ac \ud574\uc918<\/span>\n<\/span>\n<\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/5c66bbaaa16615e18a796ece4cdfbfeb.png\" alt=\"07 pic6-2-5c42375d749bbe2525e1488c2ab23939.png\" data-file-srl=\"105050\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/5c66bbaaa16615e18a796ece4cdfbfeb.png\"><\/p>\n<p>ChatGPT\uac00 \uc815\ub9ac \ud574\uc900 \uc0c1\ud0dc \uc815\uc758\ub97c \uae30\ubc18\uc73c\ub85c \uc0c1\ud0dc \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uc791\uc131 \ud574\ub2ec\ub77c\uace0 \uc694\uccad \ud569\ub2c8\ub2e4.<\/p>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">\uc8fc\ubb38 \uad00\ub9ac, \uacb0\uc81c \uad00\ub9ac, \ubc30\uc1a1 \uad00\ub9ac \uc0c1\ud0dc \uad00\ub9ac\ub97c \uc704\ud55c \uc0c1\ud0dc \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uac01\uac01 \uc791\uc131 \ud574\uc918<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/864d1d0034270daf0f43ce1a85632463.png\" alt=\"08 pic6-3-609a499d7619136652de7fead7a8f826.png\" data-file-srl=\"105051\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/864d1d0034270daf0f43ce1a85632463.png\"><\/p>\n<p>&nbsp;<img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/3e1446cbbe618ce13c6382c4da319c26.png\" alt=\"09 pic6-4-efe54c273ec3c276e47d07d59eac61ca.png\" data-file-srl=\"105052\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/3e1446cbbe618ce13c6382c4da319c26.png\"><\/p>\n<p>&nbsp;<img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/362682359b2b8640d09b3734af61e3fb.png\" alt=\"10 pic6-5-7c1b3479c3e01e45b3bfa8e27bab48fc.png\" data-file-srl=\"105053\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/362682359b2b8640d09b3734af61e3fb.png\"><\/p>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c ChatGPT\uc5d0\uac8c \uc8fc\ubb38 \uad00\ub9ac, \uacb0\uc81c \uad00\ub9ac, \ubc30\uc1a1 \uad00\ub9ac \uc0c1\ud0dc \uad00\ub9ac \uc5c5\ub370\uc774\ud2b8\ub97c \uc704\ud55c \ucffc\ub9ac\ubb38\ub4e4\uc744 \uc791\uc131\ud574 \ub2ec\ub77c\uace0 \uc694\uccad \ud569\ub2c8\ub2e4.<\/p>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">\uc8fc\ubb38 \uad00\ub9ac, \uacb0\uc81c \uad00\ub9ac, \ubc30\uc1a1 \uad00\ub9ac \uc0c1\ud0dc \uad00\ub9ac \uc5c5\ub370\uc774\ud2b8\ub97c \uc704\ud55c \ucffc\ub9ac\ubb38\ub4e4\uc744 \uc791\uc131\ud574\uc918<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/a55ebbbaf9565901017dac4bfd1a73d1.png\" alt=\"11 pic6-6-13d838497016de194cfc0c113ee543af.png\" data-file-srl=\"105054\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/a55ebbbaf9565901017dac4bfd1a73d1.png\"><\/p>\n<p>\uc774\uc0c1\uc73c\ub85c \uae30\ubcf8\uc801\uc778 \ud14c\uc774\ube14 \uc0dd\uc131 \ubc0f \uae30\ubcf8 \ub3d9\uc791 \ubc0f \uc8fc\uc694 \ud14c\uc774\ube14\ub4e4\uc758 \uc0c1\ud0dc \uad00\ub9ac\ub97c \uc704\ud55c \ucffc\ub9ac \uae4c\uc9c0 \uc791\uc131 \ud574\ubcfc \uc218 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc73c\ub85c\ub294 \uc6d4\ubcc4 \uace0\uac1d \ub370\uc774\ud130 \ubd84\uc11d\uacfc \ud310\ub9e4 \uc2e4\uc801 \ubd84\uc11d \ub4f1 \ub370\uc774\ud130 \ubd84\uc11d\uc744 \uc704\ud55c \ucffc\ub9ac\ub97c \ub9cc\ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"3-\ub370\uc774\ud130-\ubd84\uc11d-\ucffc\ub9ac-\ub9cc\ub4e4\uae30\" class=\"anchor anchorWithStickyNavbar_LWe7\">3. \ub370\uc774\ud130 \ubd84\uc11d \ucffc\ub9ac \ub9cc\ub4e4\uae30<a class=\"hash-link\" title=\"Direct link to 3. \ub370\uc774\ud130 \ubd84\uc11d \ucffc\ub9ac \ub9cc\ub4e4\uae30\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#3-%EB%8D%B0%EC%9D%B4%ED%84%B0-%EB%B6%84%EC%84%9D-%EC%BF%BC%EB%A6%AC-%EB%A7%8C%EB%93%A4%EA%B8%B0\" aria-label=\"Direct link to 3. \ub370\uc774\ud130 \ubd84\uc11d \ucffc\ub9ac \ub9cc\ub4e4\uae30\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#3-%EB%8D%B0%EC%9D%B4%ED%84%B0-%EB%B6%84%EC%84%9D-%EC%BF%BC%EB%A6%AC-%EB%A7%8C%EB%93%A4%EA%B8%B0\">\u200b<\/a><\/h2>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc900\ube44 \ub418\uace0\ub098\uba74, \ub370\uc774\ud130 \ubd84\uc11d\uc744 \uc704\ud55c \ucffc\ub9ac\ub97c \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc6d4\ubcc4 \uc2e0\uaddc \uace0\uac1d \uc218, \uc6d4\ubcc4 \ucd1d \ud310\ub9e4\ub7c9, \uc6d4\ubcc4 \ucd1d \ud310\ub9e4\uc561, \uc6d4\ubcc4 \ubca0\uc2a4\ud2b8\uc140\ub7ec \uc0c1\ud488 \ub4f1\uc758 \uc815\ubcf4\ub97c \uc5bb\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \ucffc\ub9ac\ub97c \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"language-text codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockTitle_Ktv7\">ChatGPT\ud504\ub86c\ud504\ud2b8<\/div>\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-text codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token plain\">\uc6d4\ubcc4 \uace0\uac1d \ub370\uc774\ud130 \ubd84\uc11d\uacfc \ud310\ub9e4 \uc2e4\uc801 \ubd84\uc11d\uc744 \uc704\ud55c \ucffc\ub9ac\ub4e4\uc744 \uc815\ub9ac \ud574\uc918<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/92295\/042\/105\/403c9fbdd062aa104edaa040bddca7d8.png\" alt=\"12 pic7-193a47b09819c4f235bc900dcd361f8c.png\" data-file-srl=\"105055\" data-cke-saved-src=\"https:\/\/www.stechstar.com\/user\/zbxe\/.\/files\/attach\/images\/92295\/042\/105\/403c9fbdd062aa104edaa040bddca7d8.png\"><\/p>\n<p>\uc6d4\ubcc4 \uace0\uac1d \ub370\uc774\ud130 \ubd84\uc11d\uacfc \ud310\ub9e4 \uc2e4\uc801 \ubd84\uc11d\uc744 \uc704\ud55c \ucffc\ub9ac\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<p>\uc6d4\ubcc4 \uc2e0\uaddc \uace0\uac1d \uc218(New Customers per Month):<\/p>\n<div class=\"language-sql codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-sql codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token keyword\">SELECT<\/span><span class=\"token plain\"> DATE_FORMAT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token plain\">creation_date<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'%Y-%m'<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> <span class=\"token keyword\">month<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">COUNT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span><span class=\"token plain\"> new_customers<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">FROM<\/span><span class=\"token plain\"> Users<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">GROUP<\/span> <span class=\"token keyword\">BY<\/span> <span class=\"token keyword\">month<\/span><span class=\"token punctuation\">;<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p>\uc774 \ucffc\ub9ac\ub294 \uac01 \uc6d4\ubcc4\ub85c \uc2e0\uaddc \uac00\uc785\ud55c \uace0\uac1d \uc218\ub97c \uacc4\uc0b0\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c creation_date\ub294 \uc0ac\uc6a9\uc790\uac00 \uacc4\uc815\uc744 \uc0dd\uc131\ud55c \ub0a0\uc9dc\ub97c \ub098\ud0c0\ub0b4\ub294 \ud544\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc6d4\ubcc4 \ucd1d \ud310\ub9e4\ub7c9(Total Sales per Month):<\/p>\n<div class=\"language-sql codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-sql codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token keyword\">SELECT<\/span><span class=\"token plain\"> DATE_FORMAT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token plain\">order_date<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'%Y-%m'<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> <span class=\"token keyword\">month<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">COUNT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span><span class=\"token plain\"> total_sales<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">FROM<\/span><span class=\"token plain\"> Orders<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">WHERE<\/span><span class=\"token plain\"> payment_status <\/span><span class=\"token operator\">=<\/span> <span class=\"token string\">'Completed'<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">GROUP<\/span> <span class=\"token keyword\">BY<\/span> <span class=\"token keyword\">month<\/span><span class=\"token punctuation\">;<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p>\uc774 \ucffc\ub9ac\ub294 \uac01 \uc6d4\ubcc4\ub85c \uc644\ub8cc\ub41c \uc8fc\ubb38\uc758 \ucd1d \uc218\ub97c \uacc4\uc0b0\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c order_date\ub294 \uc8fc\ubb38\uc774 \uc0dd\uc131\ub41c \ub0a0\uc9dc\ub97c \ub098\ud0c0\ub0b4\ub294 \ud544\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc6d4\ubcc4 \ucd1d \ud310\ub9e4\uc561(Total Sales Amount per Month):<\/p>\n<div class=\"language-sql codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-sql codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token keyword\">SELECT<\/span><span class=\"token plain\"> DATE_FORMAT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token plain\">Orders<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">order_date<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'%Y-%m'<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> <span class=\"token keyword\">month<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">SUM<\/span><span class=\"token punctuation\">(<\/span><span class=\"token plain\">OrderDetails<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">quantity <\/span><span class=\"token operator\">*<\/span><span class=\"token plain\"> Products<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">price<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span><span class=\"token plain\"> total_sales_amount<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">FROM<\/span><span class=\"token plain\"> Orders<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">JOIN<\/span><span class=\"token plain\"> OrderDetails <\/span><span class=\"token keyword\">ON<\/span><span class=\"token plain\"> Orders<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">order_id <\/span><span class=\"token operator\">=<\/span><span class=\"token plain\"> OrderDetails<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">order_id<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">JOIN<\/span><span class=\"token plain\"> Products <\/span><span class=\"token keyword\">ON<\/span><span class=\"token plain\"> OrderDetails<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">product_id <\/span><span class=\"token operator\">=<\/span><span class=\"token plain\"> Products<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">product_id<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">WHERE<\/span><span class=\"token plain\"> Orders<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">payment_status <\/span><span class=\"token operator\">=<\/span> <span class=\"token string\">'Completed'<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">GROUP<\/span> <span class=\"token keyword\">BY<\/span> <span class=\"token keyword\">month<\/span><span class=\"token punctuation\">;<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p>\uc774 \ucffc\ub9ac\ub294 \uac01 \uc6d4\ubcc4\ub85c \ud310\ub9e4\ub41c \uc81c\ud488\uc758 \ucd1d\uc561\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc6d4\ubcc4 \ubca0\uc2a4\ud2b8\uc140\ub7ec \uc0c1\ud488(Bestselling Products per Month):<\/p>\n<div class=\"language-sql codeBlockContainer_Ckt0 theme-code-block\">\n<div class=\"codeBlockContent_biex\">\n<pre class=\"prism-code language-sql codeBlock_bY9V thin-scrollbar\" tabindex=\"0\"><code class=\"codeBlockLines_e6Vv\"><span class=\"token-line\"><span class=\"token keyword\">SELECT<\/span><span class=\"token plain\"> DATE_FORMAT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token plain\">Orders<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">order_date<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'%Y-%m'<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> <span class=\"token keyword\">month<\/span><span class=\"token punctuation\">,<\/span><span class=\"token plain\"> Products<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">product_name<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">SUM<\/span><span class=\"token punctuation\">(<\/span><span class=\"token plain\">OrderDetails<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">quantity<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span><span class=\"token plain\"> quantity_sold<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">FROM<\/span><span class=\"token plain\"> Orders<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">JOIN<\/span><span class=\"token plain\"> OrderDetails <\/span><span class=\"token keyword\">ON<\/span><span class=\"token plain\"> Orders<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">order_id <\/span><span class=\"token operator\">=<\/span><span class=\"token plain\"> OrderDetails<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">order_id<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">JOIN<\/span><span class=\"token plain\"> Products <\/span><span class=\"token keyword\">ON<\/span><span class=\"token plain\"> OrderDetails<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">product_id <\/span><span class=\"token operator\">=<\/span><span class=\"token plain\"> Products<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">product_id<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">WHERE<\/span><span class=\"token plain\"> Orders<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">payment_status <\/span><span class=\"token operator\">=<\/span> <span class=\"token string\">'Completed'<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">GROUP<\/span> <span class=\"token keyword\">BY<\/span> <span class=\"token keyword\">month<\/span><span class=\"token punctuation\">,<\/span><span class=\"token plain\"> Products<\/span><span class=\"token punctuation\">.<\/span><span class=\"token plain\">product_name<\/span>\n<\/span><span class=\"token-line\"><span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span><span class=\"token plain\"> quantity_sold <\/span><span class=\"token keyword\">DESC<\/span><span class=\"token punctuation\">;<\/span>\n<\/span><\/code><\/pre>\n<div class=\"buttonGroup__atx\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p>\uc774 \ucffc\ub9ac\ub294 \uac01 \uc6d4\ubcc4\ub85c \uac00\uc7a5 \ub9ce\uc774 \ud310\ub9e4\ub41c \uc81c\ud488\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7ec\ud55c \ucffc\ub9ac\ub294 \uc6d4\ubcc4 \uace0\uac1d \ub370\uc774\ud130\uc640 \ud310\ub9e4 \uc2e4\uc801\uc744 \ubd84\uc11d\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \uc2e4\uc81c \uad6c\ud604\uc2dc\uc5d0\ub294 \ube44\uc988\ub2c8\uc2a4 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c \ucffc\ub9ac\uac00 \ub2ec\ub77c\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"7-\ub9c8\uce58\uba70\" class=\"anchor anchorWithStickyNavbar_LWe7\">7. \ub9c8\uce58\uba70<a class=\"hash-link\" title=\"Direct link to 7. \ub9c8\uce58\uba70\" href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#7-%EB%A7%88%EC%B9%98%EB%A9%B0\" aria-label=\"Direct link to 7. \ub9c8\uce58\uba70\" data-cke-saved-href=\"https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design#7-%EB%A7%88%EC%B9%98%EB%A9%B0\">\u200b<\/a><\/h2>\n<p>eCommerce \ud50c\ub7ab\ud3fc \uac1c\ubc1c\uc740 \ubcf5\uc7a1\ud55c \uacfc\uc815\uc774\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \uc0c1\ud0dc \uad00\ub9ac\uc5d0\ub3c4 \ub9ce\uc740 \uace0\ubbfc\uc774 \ud544\uc694\ud558\uc9c0\ub9cc, ChatGPT\ub97c \ud65c\uc6a9\ud574\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ub370\uc774\ud130 \ubd84\uc11d \ucffc\ub9ac \uc791\uc131 \uacfc\uc815\uc744 \uc27d\uac8c \uad00\ub9ac\ud560 \uc218 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc744 \ud1b5\ud574 eCommerce \ud50c\ub7ab\ud3fc\uc744 \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ub370\uc774\ud130 \ubd84\uc11d \ucffc\ub9ac \uc791\uc131\uc5d0 \ub300\ud55c \uae30\ubcf8\uc801\uc778 \uc774\ud574 \ubfd0\ub9cc \uc544\ub2c8\ub77c \uc6d0\ud558\ub294 \uc2dc\uc2a4\ud15c\uc744 \ub514\uc790\uc778\ud558\uace0 \uac1c\ubc1c \ud558\ub294\ub370 \ub3c4\uc6c0\uc774 \ub418\uc168\uc73c\uba74 \uc88b\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>[\ucd9c\ucc98]&nbsp;https:\/\/www.developerfastlane.com\/docs\/backend-database\/ecommerce-platform-database-design<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11041\" class=\"pvc_stats all  \" data-element-id=\"11041\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.stechstar.com\/user\/wordpress\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>[chatGPT] ChatGPT\ub97c \ud65c\uc6a9\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ub370\uc774\ud130\ubd84\uc11d \ucffc\ub9ac \uc2e4\uc2b5 \uc0ac\ub840 &#8211; eCommerce \ud50c\ub7ab\ud3fc\uc744 \uc704\ud55c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc124\uacc4 \uc624\ub298\uc740 ChatGPT\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ub370\uc774\ud130 \ubd84\uc11d \ucffc\ub9ac\ub97c \ub9cc\ub4dc\ub370 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud55c \uccab\ubc88\uc9f8 \ub0b4\uc6a9\uc73c\ub85c \uc774 \uae00\uc5d0\uc11c\ub294 ChatGPT\ub97c \ud65c\uc6a9\ud558\uc5ec eCommerce \ud50c\ub7ab\ud3fc\uc744 \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \ub370\uc774\ud130 \ubd84\uc11d \ucffc\ub9ac\ub97c \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. 1. \uc694\uad6c\uc0ac\ud56d \ubd84\uc11d\u200b eCommerce \ud50c\ub7ab\ud3fc \uac1c\ubc1c\uc744 \uc704\ud574 [&hellip;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11041\" class=\"pvc_stats all  \" data-element-id=\"11041\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.stechstar.com\/user\/wordpress\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[25,21,16,24],"tags":[],"class_list":["post-11041","post","type-post","status-publish","format-standard","hentry","category-25","category-21","category-16","category-24"],"a3_pvc":{"activated":true,"total_views":23,"today_views":0},"_links":{"self":[{"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/posts\/11041","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/comments?post=11041"}],"version-history":[{"count":2,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/posts\/11041\/revisions"}],"predecessor-version":[{"id":11714,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/posts\/11041\/revisions\/11714"}],"wp:attachment":[{"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/media?parent=11041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/categories?post=11041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/tags?post=11041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}