SQLPratice/4일차 실습.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"toc_visible":true,"authorship_tag":"ABX9TyOTZsPm3NQcGV7xMuOB9bYW"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","execution_count":null,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"o8UDQ3zLJn7N","executionInfo":{"status":"ok","timestamp":1683793790893,"user_tz":-540,"elapsed":7,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"86131c18-5221-40ff-9f7e-85cc8b00e55d"},"outputs":[{"output_type":"stream","name":"stdout","text":["The sql extension is already loaded. To reload it, use:\n","  %reload_ext sql\n"]}],"source":["%load_ext sql"]},{"cell_type":"code","source":[],"metadata":{"id":"RGV1hwGZJo8t"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["!pip install SQLAlchemy==1.4.47"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":311},"id":"fzgCw1f1Jrmn","executionInfo":{"status":"ok","timestamp":1683780740608,"user_tz":-540,"elapsed":7474,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"1bf6cf75-658e-4f56-b81b-d8fd3f877b98"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n","Collecting SQLAlchemy==1.4.47\n","  Downloading SQLAlchemy-1.4.47-cp310-cp310-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.6 MB)\n","\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m1.6/1.6 MB\u001b[0m \u001b[31m19.1 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n","\u001b[?25hRequirement already satisfied: greenlet!=0.4.17 in /usr/local/lib/python3.10/dist-packages (from SQLAlchemy==1.4.47) (2.0.2)\n","Installing collected packages: SQLAlchemy\n","  Attempting uninstall: SQLAlchemy\n","    Found existing installation: SQLAlchemy 2.0.10\n","    Uninstalling SQLAlchemy-2.0.10:\n","      Successfully uninstalled SQLAlchemy-2.0.10\n","Successfully installed SQLAlchemy-1.4.47\n"]},{"output_type":"display_data","data":{"application/vnd.colab-display-data+json":{"pip_warning":{"packages":["sqlalchemy"]}}},"metadata":{}}]},{"cell_type":"code","source":["! kill -9 $(ps -A | grep python | awk '{print $1}')"],"metadata":{"id":"q1mSep9CJwR_"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["##JOIN\n","왼쪽 테이블을 LEFT라고 하고 오른쪽 테이블을 RIGHT이라고 하자. JOIN의 결과는 방식에 상관없이 양쪽의 필드를 모두 가진 새로운 테이블을 만들어내게 됨. 조인의 방식에 따라 다음 두 가지가 달라짐\n","\n","- 어떤 레코드들이 선택되는지?\n","- 어떤 필드들이 채워지는지?"],"metadata":{"id":"kXX9xyBd9cbO"}},{"cell_type":"code","source":["%%sql\n","\n","SELECT *\n","  FROM RAW_DATA.VITAL V\n","  JOIN RAW_DATA.ALERT A\n","    ON V.VITALID = A.VITALID;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":98},"id":"dnRtuMgkKCwP","executionInfo":{"status":"ok","timestamp":1683786116668,"user_tz":-540,"elapsed":761,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"6aeba0ff-4523-42a4-8d17-ad3135bd8292"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","1 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(101, 4, datetime.date(2020, 1, 2), 95, 1, 4, 'WeightIncrease', datetime.date(2020, 1, 1), 101)]"],"text/html":["<table>\n","    <tr>\n","        <th>userid</th>\n","        <th>vitalid</th>\n","        <th>date</th>\n","        <th>weight</th>\n","        <th>alertid</th>\n","        <th>vitalid_1</th>\n","        <th>alerttype</th>\n","        <th>date_1</th>\n","        <th>userid_1</th>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>4</td>\n","        <td>2020-01-02</td>\n","        <td>95</td>\n","        <td>1</td>\n","        <td>4</td>\n","        <td>WeightIncrease</td>\n","        <td>2020-01-01</td>\n","        <td>101</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":5}]},{"cell_type":"code","source":["%%sql\n","\n","SELECT *\n","  FROM RAW_DATA.VITAL V\n","  LEFT JOIN RAW_DATA.ALERT A\n","         ON V.VITALID = A.VITALID;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":163},"id":"zzPfZNlieSl2","executionInfo":{"status":"ok","timestamp":1683786277272,"user_tz":-540,"elapsed":722,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"bdb65f14-9f78-409a-8b27-c5f39c6a4dfc"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","4 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(100, 1, datetime.date(2020, 1, 1), 75, None, None, None, None, None),\n"," (100, 3, datetime.date(2020, 1, 2), 78, None, None, None, None, None),\n"," (101, 2, datetime.date(2020, 1, 1), 90, None, None, None, None, None),\n"," (101, 4, datetime.date(2020, 1, 2), 95, 1, 4, 'WeightIncrease', datetime.date(2020, 1, 1), 101)]"],"text/html":["<table>\n","    <tr>\n","        <th>userid</th>\n","        <th>vitalid</th>\n","        <th>date</th>\n","        <th>weight</th>\n","        <th>alertid</th>\n","        <th>vitalid_1</th>\n","        <th>alerttype</th>\n","        <th>date_1</th>\n","        <th>userid_1</th>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>1</td>\n","        <td>2020-01-01</td>\n","        <td>75</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>3</td>\n","        <td>2020-01-02</td>\n","        <td>78</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>2</td>\n","        <td>2020-01-01</td>\n","        <td>90</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>4</td>\n","        <td>2020-01-02</td>\n","        <td>95</td>\n","        <td>1</td>\n","        <td>4</td>\n","        <td>WeightIncrease</td>\n","        <td>2020-01-01</td>\n","        <td>101</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":7}]},{"cell_type":"code","source":["%%sql\n","\n","SELECT *\n","  FROM RAW_DATA.VITAL V\n","  RIGHT JOIN RAW_DATA.ALERT A\n","          ON V.VITALID = A.VITALID;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":141},"id":"5kQZNNVXezCR","executionInfo":{"status":"ok","timestamp":1683786392647,"user_tz":-540,"elapsed":757,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"80e35c06-b7c8-486a-86e2-5bc1e47c8136"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","3 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(101, 4, datetime.date(2020, 1, 2), 95, 1, 4, 'WeightIncrease', datetime.date(2020, 1, 1), 101),\n"," (None, None, None, None, 2, None, 'MissingVital', datetime.date(2020, 1, 4), 100),\n"," (None, None, None, None, 3, None, 'MissingVital', datetime.date(2020, 1, 4), 101)]"],"text/html":["<table>\n","    <tr>\n","        <th>userid</th>\n","        <th>vitalid</th>\n","        <th>date</th>\n","        <th>weight</th>\n","        <th>alertid</th>\n","        <th>vitalid_1</th>\n","        <th>alerttype</th>\n","        <th>date_1</th>\n","        <th>userid_1</th>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>4</td>\n","        <td>2020-01-02</td>\n","        <td>95</td>\n","        <td>1</td>\n","        <td>4</td>\n","        <td>WeightIncrease</td>\n","        <td>2020-01-01</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>2</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>100</td>\n","    </tr>\n","    <tr>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>3</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>101</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":8}]},{"cell_type":"code","source":["%%sql\n","\n","SELECT *\n","  FROM RAW_DATA.VITAL V\n","   FULL JOIN RAW_DATA.ALERT A\n","          ON V.VITALID = A.VITALID;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":205},"id":"JA5cL_FvfV0W","executionInfo":{"status":"ok","timestamp":1683786490431,"user_tz":-540,"elapsed":746,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"d0219fbd-a11e-4d79-fbb7-f7444512ea11"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","6 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(101, 4, datetime.date(2020, 1, 2), 95, 1, 4, 'WeightIncrease', datetime.date(2020, 1, 1), 101),\n"," (None, None, None, None, 2, None, 'MissingVital', datetime.date(2020, 1, 4), 100),\n"," (None, None, None, None, 3, None, 'MissingVital', datetime.date(2020, 1, 4), 101),\n"," (101, 2, datetime.date(2020, 1, 1), 90, None, None, None, None, None),\n"," (100, 1, datetime.date(2020, 1, 1), 75, None, None, None, None, None),\n"," (100, 3, datetime.date(2020, 1, 2), 78, None, None, None, None, None)]"],"text/html":["<table>\n","    <tr>\n","        <th>userid</th>\n","        <th>vitalid</th>\n","        <th>date</th>\n","        <th>weight</th>\n","        <th>alertid</th>\n","        <th>vitalid_1</th>\n","        <th>alerttype</th>\n","        <th>date_1</th>\n","        <th>userid_1</th>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>4</td>\n","        <td>2020-01-02</td>\n","        <td>95</td>\n","        <td>1</td>\n","        <td>4</td>\n","        <td>WeightIncrease</td>\n","        <td>2020-01-01</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>2</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>100</td>\n","    </tr>\n","    <tr>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>3</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>2</td>\n","        <td>2020-01-01</td>\n","        <td>90</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>1</td>\n","        <td>2020-01-01</td>\n","        <td>75</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>3</td>\n","        <td>2020-01-02</td>\n","        <td>78</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","        <td>None</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":9}]},{"cell_type":"code","source":["%%sql\n","\n","SELECT *\n","  FROM RAW_DATA.VITAL V\n","CROSS JOIN RAW_DATA.ALERT A;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":333},"id":"uRYMhjG2ft2a","executionInfo":{"status":"ok","timestamp":1683786751634,"user_tz":-540,"elapsed":1047,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"30b389d7-45c6-45a7-ff3b-1bc63e3404a6"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","12 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(100, 1, datetime.date(2020, 1, 1), 75, 1, 4, 'WeightIncrease', datetime.date(2020, 1, 1), 101),\n"," (100, 3, datetime.date(2020, 1, 2), 78, 1, 4, 'WeightIncrease', datetime.date(2020, 1, 1), 101),\n"," (101, 2, datetime.date(2020, 1, 1), 90, 1, 4, 'WeightIncrease', datetime.date(2020, 1, 1), 101),\n"," (101, 4, datetime.date(2020, 1, 2), 95, 1, 4, 'WeightIncrease', datetime.date(2020, 1, 1), 101),\n"," (100, 1, datetime.date(2020, 1, 1), 75, 2, None, 'MissingVital', datetime.date(2020, 1, 4), 100),\n"," (100, 3, datetime.date(2020, 1, 2), 78, 2, None, 'MissingVital', datetime.date(2020, 1, 4), 100),\n"," (101, 2, datetime.date(2020, 1, 1), 90, 2, None, 'MissingVital', datetime.date(2020, 1, 4), 100),\n"," (101, 4, datetime.date(2020, 1, 2), 95, 2, None, 'MissingVital', datetime.date(2020, 1, 4), 100),\n"," (100, 1, datetime.date(2020, 1, 1), 75, 3, None, 'MissingVital', datetime.date(2020, 1, 4), 101),\n"," (100, 3, datetime.date(2020, 1, 2), 78, 3, None, 'MissingVital', datetime.date(2020, 1, 4), 101),\n"," (101, 2, datetime.date(2020, 1, 1), 90, 3, None, 'MissingVital', datetime.date(2020, 1, 4), 101),\n"," (101, 4, datetime.date(2020, 1, 2), 95, 3, None, 'MissingVital', datetime.date(2020, 1, 4), 101)]"],"text/html":["<table>\n","    <tr>\n","        <th>userid</th>\n","        <th>vitalid</th>\n","        <th>date</th>\n","        <th>weight</th>\n","        <th>alertid</th>\n","        <th>vitalid_1</th>\n","        <th>alerttype</th>\n","        <th>date_1</th>\n","        <th>userid_1</th>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>1</td>\n","        <td>2020-01-01</td>\n","        <td>75</td>\n","        <td>1</td>\n","        <td>4</td>\n","        <td>WeightIncrease</td>\n","        <td>2020-01-01</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>3</td>\n","        <td>2020-01-02</td>\n","        <td>78</td>\n","        <td>1</td>\n","        <td>4</td>\n","        <td>WeightIncrease</td>\n","        <td>2020-01-01</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>2</td>\n","        <td>2020-01-01</td>\n","        <td>90</td>\n","        <td>1</td>\n","        <td>4</td>\n","        <td>WeightIncrease</td>\n","        <td>2020-01-01</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>4</td>\n","        <td>2020-01-02</td>\n","        <td>95</td>\n","        <td>1</td>\n","        <td>4</td>\n","        <td>WeightIncrease</td>\n","        <td>2020-01-01</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>1</td>\n","        <td>2020-01-01</td>\n","        <td>75</td>\n","        <td>2</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>100</td>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>3</td>\n","        <td>2020-01-02</td>\n","        <td>78</td>\n","        <td>2</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>100</td>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>2</td>\n","        <td>2020-01-01</td>\n","        <td>90</td>\n","        <td>2</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>100</td>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>4</td>\n","        <td>2020-01-02</td>\n","        <td>95</td>\n","        <td>2</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>100</td>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>1</td>\n","        <td>2020-01-01</td>\n","        <td>75</td>\n","        <td>3</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>100</td>\n","        <td>3</td>\n","        <td>2020-01-02</td>\n","        <td>78</td>\n","        <td>3</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>2</td>\n","        <td>2020-01-01</td>\n","        <td>90</td>\n","        <td>3</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>101</td>\n","    </tr>\n","    <tr>\n","        <td>101</td>\n","        <td>4</td>\n","        <td>2020-01-02</td>\n","        <td>95</td>\n","        <td>3</td>\n","        <td>None</td>\n","        <td>MissingVital</td>\n","        <td>2020-01-04</td>\n","        <td>101</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":13}]},{"cell_type":"code","source":["%%sql\n","SELECT COUNT(1)\n","  FROM raw_data.boolean_test\n"," WHERE FLAG = NULL;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":98},"id":"hv4bLH9zgf4x","executionInfo":{"status":"ok","timestamp":1683787480586,"user_tz":-540,"elapsed":899,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"b6a57acf-d158-47d7-efd3-5b30f9e6165c"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","1 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(0,)]"],"text/html":["<table>\n","    <tr>\n","        <th>count</th>\n","    </tr>\n","    <tr>\n","        <td>0</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":15}]},{"cell_type":"code","source":["%%sql\n","\n","SELECT VALUE\n","     , COALESCE(VALUE, 0) -- 만약 value가 NULL이면 0을 RETURN \n","  FROM raw_data.count_test;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":227},"id":"QimngourjIfG","executionInfo":{"status":"ok","timestamp":1683789360592,"user_tz":-540,"elapsed":729,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"73faf86e-7a92-4220-d0c2-021bd5a1069c"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","7 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(None, 0), (1, 1), (1, 1), (0, 0), (0, 0), (4, 4), (3, 3)]"],"text/html":["<table>\n","    <tr>\n","        <th>value</th>\n","        <th>coalesce</th>\n","    </tr>\n","    <tr>\n","        <td>None</td>\n","        <td>0</td>\n","    </tr>\n","    <tr>\n","        <td>1</td>\n","        <td>1</td>\n","    </tr>\n","    <tr>\n","        <td>1</td>\n","        <td>1</td>\n","    </tr>\n","    <tr>\n","        <td>0</td>\n","        <td>0</td>\n","    </tr>\n","    <tr>\n","        <td>0</td>\n","        <td>0</td>\n","    </tr>\n","    <tr>\n","        <td>4</td>\n","        <td>4</td>\n","    </tr>\n","    <tr>\n","        <td>3</td>\n","        <td>3</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":16}]},{"cell_type":"code","source":["%%sql\n","\n","SELECT COUNT(CASE WHEN FLAG = True THEN 1 END) TRUE_CNT1\n","     , COUNT(CASE WHEN FLAG IS True THEN 1 END) TRUE_CNT2\n","     , COUNT(CASE WHEN FLAG IS NOT False THEN 1 END) NOT_FALSE_CNT\n","  FROM raw_data.boolean_test"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":98},"id":"AQHUsbvtqqjj","executionInfo":{"status":"ok","timestamp":1683789715013,"user_tz":-540,"elapsed":771,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"8b7865f5-d895-4f13-865d-7249707f818f"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","1 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(2, 2, 3)]"],"text/html":["<table>\n","    <tr>\n","        <th>true_cnt1</th>\n","        <th>true_cnt2</th>\n","        <th>not_false_cnt</th>\n","    </tr>\n","    <tr>\n","        <td>2</td>\n","        <td>2</td>\n","        <td>3</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":17}]},{"cell_type":"code","source":["%%sql\n","\n","SELECT DISTINCT SESSIONID FROM RAW_DATA.SESSION_TIMESTAMP\n"," MINUS\n","SELECT DISTINCT SESSIONID FROM RAW_DATA.USER_SESSION_CHANNEL"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":77},"id":"dUDM9wtcsBDt","executionInfo":{"status":"ok","timestamp":1683791111594,"user_tz":-540,"elapsed":737,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"4c46b478-f84b-4d07-b623-5050c59b3492"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","0 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[]"],"text/html":["<table>\n","    <tr>\n","        <th>sessionid</th>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":18}]},{"cell_type":"markdown","source":["# 과제"],"metadata":{"id":"inr2GBP7cAwz"}},{"cell_type":"markdown","source":["### 1) 사용자별로 처음 채널과 마지막 채널이 무엇이었는지 찾기\n","\n","![image.png](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfcAAAHiCAIAAAB6DBJYAAAgAElEQVR4nO3db4jc6J0v+t/TeMBm98UEchY1KYNr4gvrgCFuCLSKNXgq+EU8ewKWqIauOrkw1zkLuz174Hp6A/e03DPTrdoLiccLe6fPwm56B+4eqcFFleGGcWDNlAM+lApyaAc8jAPrPQp0QYm9CzHczLQPPdvPfaH/VVJXVXf9ffr7YUjakp5Hj6p++unRI6nEDg4OKOKrr74iojNnzlCSk8wlon/5l3/5gz/4g6HXjPVivVgv1ov1ps09k1jgiBacZO7c3NyIasZ6sV6sF+vFehPnzh2xNAAAzDpkeQAAkSHLAwCIDFkeAEBkyPIAACJDlgcAEBmyPACAyM64N9IHOv7Z4SRziejw8DBtGawX68V6sV6sdxTrPeru+kTnzp0btAgAAAxLxw8W9HScZ18554M1CgAAhoExhmdfAQAghCwPACAyZHkAAJEhywMAiAxZHgBAZMjyAAAiQ5YHABDZMJ99BQCAURv0yVj05QEARHacZ18BAGBS8OwrAACEkOUBAESGLA8AIDJkeQAAkSHLAwCIDFkeAEBkyPIAACJDlgcAENkZx3Gi/z48PCSiubnk7O/OBQCASelI2oGO7M0Yc9/eyjpe4ur+EkLas1VfffXVa6+9hve+AgBMRJC7u6Vlb4zYAACIDFkeAEBkyPIAACJDlgcAEBmyPACAyJDlAQBEhiwPACAyvPcVAGCW4L2vwrDKjJWbROSYS0zdSX7arY/ig2iWGStb/S4dNGyMLZwqg31crtnfapg1c2cGNOkGQ+DV853Vty7PM8bekH/44eM+kmyzzBItmemFuzL4AKlt8BbOPMdcSv6MkdlhWAZN2ujLT5izow6ScwOvnv6f+W/99dmVn9uc888rym//85XSjt3HCvUG73K/KJ14Q4bXwhhrk7HNAbvLQ6rW2kxM16rZ6lG5Yrbjn29DH1rDAQaGLJ/IMZf6Ti4vn5u3t56eZG0Foz1ozn1haP/5az/9B/1G5iwRnc3c0P9m1S6Wa/96knYM1XBa+PK3baL/b//VoGv/jVn6X1brvztRtfKdrsNhu1qks2eHfUL79K9yb/3dwMc/gD4hy5+U83Ot9FcvB05DJ2M/Nh/+6Yp6MTLp26V3CtvGo2kZFRlOC19Ut/6G6Cdbtd8MtHKntv7uq43V/O8Pt1qiF7vmtxeywz7xufIf9Uvr72y/GHK1AC5k+VnkPH1SV+RLr8cmSpfkK7XnU9IlHEYLf2eVf/DD325UjT9/+u5/+vBpase806vHH608e2f1ZkoyHqTaVy89zq+t+uP6trl9pZi/0m9D+vb7+ZUN+uFf1l4OvWaA6cvy7lDJQ+snb73B2BuyVv8dEb16/qD8w/y35hljjL0hq6s7z18REb18+GexUeyXP3uHMVaqhBMe/hljP6r309F++d8+/KH8BmPsjRurD3+zH5+Z1gCyNtl8sUak5VgwwpO68BC9ekV05lzHxHkpS7+2e3WVtVz8omA/w1K14nxYQtb8SuZLlVG0kIiInIfa95VPvvOJcUcp/vWn2xcfqt/XHvZV0jZ+Up7/X2/IZ09W7YvttxjLXlXVJVVdUrW/b1g75R/+zcLKzeEneSLKfq+kfKxv/2oUdcNpN21ZnoiI/sut0pPc3fon+p+9tfD7ZP+d+i1l+7dvatv1Tz+t/VT5d40Pi/nVn70ken3hqkKVxq7fBXr+qyoRmb/83MuqLxsP/4ZWri4k7u9RL3/2zqWrq/XzK9X6p3e/9/LD/037JNKtSm8AXSp8Wr2TJ7r1Uf3TTwuXjl64H5GLsTltgI+sfx1XX9fk6Erl5HXGLidaul9J2ygMv32v/vVpbVN94+r21+48bfz1jSwRUfbGvU8bd762ffUNddO0WkceNF/UzZ9fKb3ZmYsHrvbirU84bz/79NN//PTTf/z0pz8uXXr1ufQX75Yu0slpcteNN5m8Wnh6935fPRKAgUzlnZGO+pG5dsMbVH1qVGx5wzDueJ2z/PeyZ7PfLf/q+Uf/Xpa+cyNP2tNff3RjkYieNmqOvChbj54+p/wVole/rG/Rrar8evqavFVsr2/RD4xP/+9ilojezN+4ouWuEl315j5Mb8Drf5jPXdoiyi68mZd7LdzPpkvLVb7s/mmVWS5lqbOvf53oq44TDmo7Nv3hcQaNw5U2y6yvZvZ0rBZ+5dR+pGgvFlb+VN/9Py69Ho9N6c13q/90y/55detHC+9Keu3HipQUvPZjs0439G8Pu9qdd1ee3ar9l3zPHkM/dIuvLXZMky7JV5wfW8//cgQjQnC6TeWzr4XcQnjd7MrKP36+Ep179lvfuurdIHH24sKNbzuG9XRt8Qq1njd+pbxTy71SGs9b717J0NOmQYUPc1/vtboXuw9/RaUfK9lgDX90a+V6+Yf9NKCzroEWPrbXL13J1x4/ffmDbOQI5jy3nio3s+mlxulYLTwjKfcaypHVZr936+73bqUv8Mr+pzoVbsXWceJq7X8o5X5EH1q6nHY5dxiyF3Pk7D5v0ZXMCNcCAhD12ddXL53n1uOH5v+lvfP9/LsVot84L4mIruQU6enPd22iV893a9/OXbqZu0G13eev3K59/rrcu2/7r06d8pey0ST8tfnOE/O0BgzU2qHJvlm88fF2NXpXxq+Mjyq3StdHcOP7sUyohS+d3xB9/fXhHVBf1te/m/sR6Y+3ixeGVmmi1//dPFHN7nUzPsCgZuDZV/tnq9+dP/e1+W/l/kTf/plz9vqt0vVw7pXFEj16aLXo+X836N/nrtCl3J+S8d+f04vdh7+6cuM7x+vbnj0b6bUd3YCBWjs0F2/pf/1K+4H2sPWKiF69qL3zp3ez5prS88Sl8+qr78iHA7quvo60hSc2/7Weg3T9cJrbq/lLpV/la8+MW384wIEj9nGN8BILnFLCPfv6r7Xy9z/87Q8+ae9z/k+NT//xp3f/XLkUmX/2O/kVqu0+f7r72Fn5ziV3rMD55XPrlw/r3y7lv51acejrUp7qz+3oda+2Hdzt0KsBA7U2WaXUkRW0/9a71Vf+/JP6j84Z38syxr71g4fZv3xqLPc6pC2udT/36rmTNh4vFe93L73Wz+j9cVo4FO3fDuPMyW78fY3+Y/35/7MmD3BkSvy4OOfdA/EAYzL1Wf7F822iG9+/IQV9qV8/rD2KLPD6Qq5Axs5W/VH+yqXXiSh7JS89MPR/qElKrq8LWRdzyiJ9+He14EbuV01zO1hFzwYM1Nou0nK1OyPof9RPu89eurlmPGtzzv+H9dN335yWsZqI8bfwdekCkfPyt0OoKqv87Sd3ly8N5bSgHy//3zaRksWgPAzb1Gf5i1dWJCq/rX74oF5//NDcLH3rzQ+fxwbNJfl63vl425TyCxe9Iio9fPhz6dYf9Xm3wqVbf6XLldJ3l8rmz+sPP15966YWjl/0asDZ358nqhp/97D+65d9tBbSpP7OV7LkX/s5m72s0IPdyInZUKodB/tFg76du4QsD8M29Vn+6zfuPjbevfT8rvLd7xZXt+2Fu092q392hZ587t8VT9nv3LhCRD+QvbGR1y/lbhJRKZ/8YEyCs4trD58Zyivj3RvfvXXv+ZV7n3wU3AneqwGvv3nro+VX1T9567t/WXf6aC2kSB3rSJbyaz9Z+Uae6k9/PeRqR8/e/fnTfs8+AQbSEeQHBwcHBwdpu8DBwUF3ERixtlHo/pnDnho6kW4NWCh84mkgY2xhf4258uPdodeb4DgfV8pW/9NPb9CVu0+H1DAQ1xEZOC17M7dYwL3jMu1emq+++uq1117rKAIwVV491rJFMmx9OI8wjcXTnywsPNd++/fK2C4DwIxirDNpB9Ky99SP2Jxc2qszPL1/Lhxmy9k339m6vr31YFp+nrO339WNe2fv/iekeBgJ5g7CBHr25c+dOzdjffmvXr383VGD4mdfH+JDNDAdfmOWru/eeno39ceHp8nTv8qt0Fbjf8eYPPTGWGfSDqRl71OQ5QEARHGMLJ/8OOtEnnEFAICejs7Pp3JcHgDgFEOWBwAQGbI8AIDIkOUBAESGLA8AIDJkeQAAkSHLAwCIDFkeAEBkZxwn9nMfh4eHRDQ3l5z93bkAADApHUk70JG9g981w29SAgDMDPwmJQAAxCDLAwCIDFkeAEBkyPIAACJDlgcAEBmyPACAyJDlAQBEdsa9xTLQ8c8OR88FAIBRS8vDadPRlwcAEBne+woAMEvw3lcAAAghywMAiAxZHgBAZMjyAAAiQ5YHABAZsjwAgMiQ5QEARIZnXwEAZsmgz76O9emnN9988xe/+MU41wiz4tq1a48fP550KwaDeIY0UxXPY33v6xFvLIRTbhZjYxbbDOMxutjAe18BACAGWR4AQGTI8gAAIpvkb0/+ZMtMm/UXK8VxtgTg5BDPMJ0m/AvDf/If3uqe+Lf/9ZPxtwTg5BDPMIUwYgMAILIJ9+Vfvfqfk20AwBAhnmEKTfjZ1y+++PKb38xGp/zzP9vDXQXA2CCeYQxm7L2vX+7vP/vs+bPPPvf/e/7l/v5kmzRCzTJjrNwcUe2OucTYkumMqPoIa5MxVrZGv6KZMyvxPNRv0DGX3KpGEoHWpmq2hlrj6TPh975+8cU+I+JEzJ8i8qOEi2ucr026ETBCsxLP8h3O7wynKmtzvlTRG0REUvE+H+69RM6Omlsn4+2hVjr7Zuy9r/tf7n+5v+/+75f+332XjvYdrDJjbNPtnVhl5lF3go5FONHrTbs9680yCwt2aZlqRykiZ8efFnZbktbYXTbel7c2WUc9bg/L9Orv0YXpLk5ERPb2krdOf5PCtvmb6X1u5mZsybS1J20vJDtZPB8l6et2zKU+oi490qzUIskR0s3NwkRajqlmK9gfO4qrZtNfRbijde2P3e1slueLNaJa6by7THcku3u9aQYx3yzHPpDoPs7Sd3Ph8biDg4ODgwOe4uDgoLtI/zrK/vgjI+2//uprGwWigtHmnPOGTkQbDc55Y4OI9AbnbVMhUoy92JLhREsnv0jP+oM63VK6NcAak8pGJnbW01l5cstMxSu+ZyhEitn21uiuPZzIGxveH21T8StPXTJh7Udu7xCdJK4mZdjxnC74Fjq/r464OjLqEstGJnZGb1eEJIoEQ7D2zuKRvaOznR37Y0c7I01KjOSGTrHNjGx75z4eKTUOo4vnI2pOy96TvMdmlI+KaDlGDV7ly0RE1KpXK6SYeYmIrqoKlWy/o6pfl3vUVCnNL1H7vneGaz3SiPT8IhHJ+Q2iZ7ZDcsIak8pGWPV1oo28TEQk3zIVrXjXfLuaJSJSshkiymYLXuVSQpuc+oMabazKRJQpVr2zZLeXtuAWXyDSXthEknyHV8kqs3mts5LOJSlp7Xbq9kKnUT/6pMmMLO5/3ZEQWszrRLu2Q4tElBx18bIh50m1RopxVSIiaXlVL+ZKH1vFO+4F5MQI6VtBzfvFa247swtENaKj9se0dhJRaiS7lWeyChHdzEtEdFGJznf3cWl5VS/WtEfW2uKpC2AB75eX33a7D1ouONls2TWiWnGeMcbOl2ruLtGbVLytExFVSvPeWaRjPwtqZrl1ooptJ64xoWxEy94lUi5mKYG7ax3NtispcwrZeKXuSX2OLL9fk7pk4tqTtxfGbfGWUSAi0mR/iKNl7xLRuvfNaES1F3Zy1HWXjbBf1FJDLjlChiFxfzyynUdFMvQiYJanTLHKuX/WqeU2Lfc4Hz3rrC731zFZXOOceyeGldLKDmUvU3ywYs3vUMfXmFA2kucz2QVvtzyeoK/di9dpaq8tHm9FUvL2wrhJxfuc+8MOmly2MtkFio/p3ZGJEqOuq2yk3uxFhWjXHvNNLMn741HtPHEkn2ozneWl7GW/d9ms++dxwSUgqXjPUNwucyavFqj2oO541xL7vDcruKIrr1k6ES1kJfm6TqTVm9G5SWtMKhupWc5vEK3XLSIia7tYo43VYu8ufLjh+ZsKVar1FsUvO3cJDyeOea9rzKYPSdsL4xYErbS8ZRTcXnYkhMKr+glRl1Q2JF1VFapVnzhE5Ozc1Ugx3h79cTxpfzy6nSeJZO2e6Xhb18cIrZD6HL8P5nYX6d9Jyibzru0QbeiRy5WN8IzOuzYbm+hdgYlcC+1df1i519dIqzyc2F02vkb3ame05qQLWanC4t5iydeiI61VYtdp069ad6y9e3tx9dU1zjaHX7d/NdI/dySK9ouTIra7bOwbDIvEa+6KkGT++Iluxa++dhePxX/X/pi4jX7bFLOdFMmRyhOv2bprNMNKTvgt9G90sXFEzWnZG++Kgqkwi7Exi20+XZplJmu6xcc/zjO62Dii5rTsfcZxYqO7h4eHRDQ3lzyS484Vj7XJcuudEycSHJ2aZSZ3nZ9uNLxBWIBxmd595PTpSNqBjuwdHA/Ql4epMIuxMYtthvGYqr78TF99BQCAHpDlAQBEhiwPACAyZHkAAJEhywMAiAxZHgBAZMjyAAAim/B7XwEAYCCDvvd1rL8vf+HCBcZY7+Xg9Llw4cKkmzAwxDOkmap4FuTZ19P2FKJ42zuLW4R4HhbxthfPvgIAwJggy8+k999/f9JNABgaxPNIYcQGpsIsfoOIZ0iDERsAABgTZPmZ9MEHH0y6CQBDg3geKYzYzCTxtncWtwjxPCzibS9GbAAAYEzw7OtMwj0JIBLE80AGffZ1CvryLVNlMeVmOF3d8d9w2CwzxtiSObmGhs3wWnjCUserioiI3nvvveMUgzFAPA8O8TxSc2cGNKJ2KGabc8552yiQJpetjtneS671xv3iiBrQr8U1zsV9o3GzzJbM5DcHH8nZUd385ez4KW4z+A4dc8lPeF7ljrmkmq2htXoKIZ6ngqDxPGjSnoK+fIxUvK0TafVoj6Blqu4uwdfkwWsMvycW7mzhxCAIIl2woD+SUDbWYbHK/my/j+aYS4wtmeZm5xq721N+NPjG+KbrnoSWufJA3VqW3D/abnZ7lvP3k5XqTT/lUWllxyGSivfU6u3j7H6zBvHcF8TzaPG4g4ODg4MDnuLg4KC7SP+Sy+4ZStj34dzSiUi3gumGTkSkGHuD1xyrvKET0UYjtopwYtsoEBWMNueNDSLSGwOUjU5sGwW/tdHtim+UW6qxQX6pgXVvb2Mj/AzbphJtmMtbkaVTQVHI21ivPcE/LZ0KhrHhlWj4dYe1uNXuGQopSsFbprGRsBVhGzomuivqKnWSuJoUxDPiefzxfETNadl72rK8G1VhUFLH9zFQzZFKwr0uGvfu3wWj7a2Xgu8srWwY3+GewCM7VaT9SbtN21TCPTxWw2ASttfS/ca3jUKwB3rrCsPR0iMppqH7f3s7Vcfu7ecL7xMIKtwzlLDlDT3cfwKRUhGNjcj3aOnR71TQLI947gviuX/HyPLTMmJTK84zxhibL1UUYy96JqsYe7yxQbSeO86FnUxxdSOsX91xiBz7GRFpOcYYY7l1oopte2fWRJXSfHDam1A25Ni7REo2k7TSQjY7eEsHknBPQiarVKr1FlGrXq3o+UWiTLHKq8UMEZGUXYgsuuA1u1nXCmo+Q0Qk3+HVZYmIiPT8IhFJ+ZtuTpCK9/1ZmWgt/ra37N2O7W2WGZsvVfRVr8Jwem5db9zxv9tMVnlmT+9J7skgngeCeB6pacnykeOk90X607eKGZLfNhRKuorVB/kO59zraNSKK2ZLyl4mih2u12TyLkN5HZaKO9zWXTasVsouENXs41xyOV6pmIR7EjJ5tVCzW+Q8qdY28m7oWZv+OKushUv6QezYuwlVd+/SzWC0NhepZSHYK2ody7ufpEW56DBus8zk3Xi+ExnieSCI55GalizfQ6a4ZSpE2t2dAQ+WwcWlxbXGBrnfpXw9uCBmlb2r58Ef8pqlE9FCVkosG1rM60TaI4uIqLldqpB+uygltCBGuqoqfinrkdZr8YFI+ZuK9siyX9T067K77bl1f+ePDGiGBWIdojRWWdYiJ7NdMlmle6I3fdfd/50dlcnUiOe7Uw3x3BvieWhmJMsTScurOlGtuDJYscW1tqlosncyq1teN8efmNMKRvuOTCSv7RnKes7rJmw01hZTyobkNd7Q/SK61d/taJli1dJpPccYq1NCjPUp8Z4E6aqqrOdy6+4papRj3kvaA4OTYreXtNmjZ+ns3E2oJZNdqNi2+3fkxjXnSbXmnj43y/PFhYT7SVp27XK2Zx4RFeI5CvE8Wgdx+/v7+/v7Byn29/dp6Fdfh2F0NU+nlO0NLjFF/klEpBiWobgn9eFFLc55pE8UuSfBu27o31TQNr3OjWI2ItfBwiGC6N0FwcKx64FRwt9jM901TyfEc/+6k3bP7M3c22YCPX+t7Ny5c3x2fq2MzcJrOY/xmYzukzyOlqnepq37vU/wjygyXVvUH8RzIsQzjTg2OpJ2IC17Jz/OOrpnXMdsikJnqKbrdz8yxa2b6spOvrrc537hmLer6r3qlJ7eTjHE8zhMfTwfnZ+75+KXh2EqzOI3iHiGNBOJDfzyMADAaYQsP5Om63c/AE4G8TxSGLGZSeJt7yxuEeJ5WMTbXozYAADAmCDLz6TpuicB4GQQzyOFERuYCrP4DSKeIQ1GbAAAYEzOOE7s95IODw+JaG4uOfu7c09idA/vzcRjgSAYxDOMX0fSDnRk76DXjxGbmSTe9s7iFiGeh0W87cWIDQAAjAmy/EzCPQkgEsTzSGHEBqbCLH6DiGdIgxEbAAAYE2T5mYTf/QCRIJ5HCiM2M0m87Z3FLUI8D4t424sRGwAAGJMzbvoPdPyzw9FzYWxwTwKIBPE8kLQ8nDZd8Pe+Dou1ye5ebHe8IczZUecfqPx+cXTrPT1m8Zx9EvFsldnd7F61mBnFamFopuq9r3NnBjSKdsPUcMwlVm5OuhUAZJWZarZoyDHZMlVWtoZU2aQMmrRFH5ePfqnNMlsyHSI3blzqjv+LEM2yNymyjLqkMtYVYd6S6vaLsW1GJ9yTcDqZSzmNaqXzqtmKROzsp60j41kq3udri+NrjHhEz/JJnJ2V0uUG55zzxkJx2yKilqnKu8Ye57xtUGl+09trapdXOY9HWMtUZU23OOdb2We1STSfKHEcs2WqrFze9Pd798gUHtjI2VHZpuX1jHZM1T/IWZtdmcIO50Yqjy/WLLMlVQ0PijAOxfsNnRRjr1rMWGUvYnnb3L27M9tfQlc8O5Hjmd+Xb5kqK5s7XmyaLcs7yvl7a0KUdvbnrPL5Uo20nLtAeJiM7S9msEe04jtCx9zxfDTDcBqzfIS8xtdkIudJtVZQ8xkikoq3dXpmuzuNcjHbWaJl1wrGrUV/yemi7V5sc84bG6TdOyr5ag9oi3Nu6bXi/N2Lbc7bRkELMoVWtFc553sGFVfMFrn7xoLFOeeNDS0XpPUKqXuc3y9KqeuBcZCWqx1XjGafFDmeRadrVdrinDc2aqXzd7N7nO8ZyvrdtCjt6s/Ja3uGQnqDr8lhx463TSXcXyol+zp394jceXvV2022LX9u1dvFtNzmzOT505jlpeVqg3KxYzgRVUrz7iRZo4ptExHRQrZz53Hs3XE2NU3KPQmKelUiIvl6j8OPcjMvEVEmq5C+uiwRSdnLkbnmLZmIMsXVjVr1iUPNukZ6fpGISH7bUPwPh2ghi2uAEyOv7anV89ExxhnW9z02XoRnLyq0sVrMEGWyC+6c1Ch1ef25UKZY5d4hRPLrICLyKpGyl4MdIatE5q4uS94q1uuzkuZPUZaPJmj5DneP8CS7V3iINtxjviseEBHxgJiY9957L2lyv2m3++jVa67mHRXPl2q0a7ufWCHbdaYDY5QpVjnnnLdvVudnp1+ZKCWeux0d4Z1Rmtyf8/ljlYzJWjj16KiezZg/DVleqzeJyKk/8IbRrc3IiDMtZDMkXVX98z6yNo/sHC3m9Uppu0lEjnlPS1tqCtkv+r2KsOuNVzn2M39SwWiHh0DcxjcF4veKJAwtnkJJUZrQn3M1y7l13evZWX0PvQanCC17YhflBid6ls8Ut0xFkxljK3TT+y7lO42Fojs8kyNrzR2dqFoLpfOMMZZb1xtHjTXLa5auyYyxefumoaQuNloD3GNTqdZbRGTV1/stUXtQd4ioVa9WFPWqFDmwkbOjztZ1J+Fks4Va6bxqUnHL3HW7qfMP1K0ZH5cfwj1jSVHa3Z9LMlB3ze0ykvVIo4182hn/tBH/2VdpucqXvb+L3h/yGudrHcstdkyTivfDhxrkO7yauOQyTcT777/f10nu4lpjg+XOsxLphqlQf7d+6jdphbEakW7xYoaI5LU9Qz3vvqFOMfZSh7Ng9KTife49hhcJ7FmXFM/e8Yz2tvqrIylK7zQW2DwrEhHpFncH2ReolGPU4LeMwnyOaUSKYRmKbNtEvQ+VBZ3uMVYhKhjt+xPbD/Ds66kg3vbO4hYhnodlNra3WWb3su3+biqbqmdfkx9nxTOuUw6/+wEiQTwP5Oj83D0XvzwMU2EWv0HEM6SZSGzgl4cBAE4jZPmZhN+xAZEgnkcKIzYzSbztncUtQjwPi3jbixEbAAAYE2T5mYR7EkAkiOeRwogNTIVZ/AYRz5BmqkZsxH/2FQBAJIM++yrI00/Xrl2bdBPG6oMPPuj7Z/xgVK5du8bcJ+pHYHQ1wxhMVUbCiM1MEm97xdsigFHAPTYAABCDLD+TcE8CAPQJIzYwFfANAvQDIzYAABCDLD+T8LsfANAnjNjMJPG2V7wtAhgFjNgAAEAMsvxMwj02ANAn1m63o/8+PDwkorm55Ox/eHj4jW98Y7ZHbFqmet5e5SN9RbVjLs3bt/na4gjXIRiM2AD0g7HOpB3oyN7BPnVGkmLvqu05Lj/E5sLUGeT9xVHOjrpCW9VlydlR54s1IqKNBr/jHkkdc2m+VCEi9833RYkcc2mF7lWLmaE2HuB06EjagdM8Lm+Vmats+ZPsHZUxxphqtrwpjkhhGiMAAB5xSURBVDclmOiYS6y86RfdtIiIWqbKyuVNv7qmX13TX2zJdMaySdN1j03LXHmgbi1L7h9tzjlvG89y6o5DRM7OSvVmm7sTqbSy4xBJxXtq9faYPiuAU074LO+YSzmyOOe8be7m3GRNWpW2OOeNjVrJzTXN8nxxocG5N/Fj73CgPcu2OeeWTut3/eOBtnuxzTlvbJB2z3SIqGWq8q6x52Wx+U0rsR3D1T0ub20yN6uSe8RymxEcfoJjUrPMllQ1OCC1TLXr+FTf7DgoWmEt4dFOVZe8ZayPSwu3ixIRZYpV7zxAyt9Uai9sIpKWq9Vlt+sh5W8qtQd1h4gyxdXLpe3gMAkAIyN6lm/VqxU9v0hEJC1X/TEERb0qEZF8XfcWW1zj/kh99qISlFZu5iUiWszrYY2dZZ0n1VpBzWeISCre1umZPZEuqnxd9xIoOfUHNf26HDn88LapeMckIqqQusf5/aJEVvl8Vd3jnPPGZbeXTVQp2dc5522joOU2LfcwuWu2Oed8z1DCo11t4TbnfE0mq77ufcIRTv1BTbmY7Zhqv6jR5azkN1h7NI4jIsApJ3yWt2sJUxeynSPCjrnk9Va9YWVvue7xr+6yRJXSvFtY1qhi2ydscx8S7rHJZJVKtd6KHNgyxSr3xr6l7EJkUX8TmnXNOz6RfIf7PW43ZUv5m+7RTire92dlorUoXiUte7eQjaXzZpmx+VJFX12Of3rNcm5db9zxL3tnssqEjogAp4roWT6TVXovRM7OSokMb/DY7KdE3IY72OMa6d07noQfl8/k1ULNbpHzpFrbyLttsPxLCEzWwiX9pOzYuwlVd6Rsig775CK1LARZvvM4urjGOecW5SIXQqhZZvKusTeODwcAosTP8guk1ZtE7mh176uj1nYxqfefTrqqBuMY1ub4LsB2NyR/U9EeWfaLmn5dJvL7zu6hx9ITCsQ6+GmssqzplltLI6GWtONoJqvQrt0icj95mRocN9UATIDoWZ7ktT1jV3aHYhYaKfcISsurujfqUs9bA46tZ4pVa6F0njHGcut62iqGK/EeG+mqqqznckmj5OY9rXv5cJDHPT71um7s7NxNqCWTXQgGqZrl4CAXXq7wrmx39eJbdu1ywogYAAzZQdz+/v7+/v5Biv39fSLix3WSspOqeTqlbG/bKESHj9pGwf2SFcMyFNIbnHNLp4I3NsV5pI/vTozMbZuKW1UwhKWYDaNAusX5nl8b55zzxgb5nf3oeJfu37MUDzi//mip9C0CgJjupN0ze7ODg4PoPtjzqahz587xmX72VQjTtb0tU71NWwOdxHQVma4tAphWjHUm7UBa9j6TmNDTsjxMien6HZtMceumurKTry73mecd83ZVvVfFcA3AMRydn7vn4peHYSrgGwToB355GAAAYpDlZ9J0/Y4NAEwxjNjMJPG2V7wtAhgFjNgAAEAMsvxMmq57bABgimHEBqYCvkGAfhxjxOZMx+ufjn4bFN4VBQAwWWl5OG36WJ9+unbtGmNsRJWPrmYYg2vXrk26CQBiGuuIDQAAnATusQEAgBhkeQAAkSHLAwCIDFkeAEBkyPIAACJDlgcAEBmyPACAyPDsKwDALBn02Vf05QEARIb3vgIAzJJB3/uKvjwAgMiQ5QEARIYsDwAgMmR5AACRIcsDAIgMWR4AQGTI8gAAIkOWBwAQ2RnHcaL/Pjw8JKK5ueTs784FAIBJ6UjagY7sHbw7EO99BQCYGXjvKwAAxCDLAwCIDFkeAEBkyPIAACJDlgcAEBmyPACAyJDlAQBEhve+AgDMErz3FQAAQnjvKwDALMF7XwEAIIQsDwAgMmR5AACRIcsDAIgMWR4AQGTI8gAAIkOWBwAQGZ59BQCYJYM++zrJp5/efPPNX/ziFxNsAEyta9euPX78eNKt6AEBDMcz5vCe5Htfj3iBIZxyMxEbM9FImEIniRy89xUAAGKQ5QEARIYsDwAgsin67cmfbJlps/5ipTjOlgAcAwIYptMUZXki+pP/8Fb3xL/9r5+MvyUAx4AAhimEERsAAJFNV1/+1av/OekmABwfAhim0HQ9+/rFl19+841sdMo//w97pGsEGKIvvvjym9+MB/A/I4BhyGb7va/7X7569tnnzz57/uyzzz/77Pmzzz7f//LVpBsV5ZhLjC2ZzlAqa5bVneHUdDzWpmq23D8YY2Vrgk0RxZf7+59Fovezz55/ub8/6UYdV7PMGCs3R1T7UHelIyG8p+u9r1988SUnYkTR/50mUvE+H87dEi1TlTUybw2lsmNwdtTcOhlvExHJdzi/M6mGCOWLL/Y7oneGH41dXON8bdKNgASz/d7XL/f397/c7/jfk1VplZkn0nEOJwZdFWvTnxT2L7rLxjogzo4aVOP1FNzuz46pdq6xq1XnSzWiWnGebVpeqc0yY4xtWtH1sk0rul5zM766xK1rmWr3xGa4oNkiapbnizWiWuk8KzfjnZ1Icf/DSVs7dOqO3v0vx9iXT/juIlF6VGAnlY335bt3EDdsTK9+77wwTdL+RUT29lJqSB8d/GlrT9reU4/HHRwcHBwc8BQHBwfdRY6to6off2Sk/XfsVTQ2iEhvcN42FSLF2OOct40CUcFoRydaOhHpFud7hkKkmO0BykYmuvXQRiNaPFlkRdFSbkF3ettUvFa5q3BX10cLdSvY9rBIWE9n+yNNjVTeuYFdax+pIYbZ6IwhgAcRfrnhFxoENm/oXZGZGMNJZaPB3FFPZ+XJLTOVrgBLDelBgr9r7Udu7/Q4SXgfUTYte0/RPTYje3JEyzFq8CpfJiKiVr1aIcXMS0R0VVWoZPu9AE1mZPFqbEgmXjbk1B/UqGDkM0QkFW/rJbm03Sy657fKxSwRZS8qRLt2i+RMX63Ur8vuH/IdXiWrzOa1zkUWshkiyi4QaS9sIimphVLxPqeWqbJSLWjrk2qN9NVFio44JXZznCfVGinGVYmIpOVVvZgrfWwV72TT1w6hqXj0qVKaX6L2fW8IznqkEen5RSKS8xtEz2yH3DBLCux42Qirvk60kZeJiORbpqIV75pvV7NERIobFdmCV3lSWDj1BzXaWJWJKFOsxgKwM6gGDP7Otdup23uqTdeIzdDJbxsKEZGWC871WrY3VMIYO1+qEe3aDi3eMgpERJocnrEmlA3ZdoXocjYx1S0kT+6TYy4xxnJk+X38QCGbjS+a1EKrzBg7X1X3vN4QEdkvatQf+0XN3526dK0dpoxUvK0TEVVK8954hWM/Iz88WG6dqGLbyWHTXTaiZe/6fZcuKdESY9uVlDmdQTVA8CetPXl7QfAsT5lilXP/pE/LbVqUyXaMOVSXJbeTy/3zRE0uW4llQ0H3Ydi8U4322uKxtq5Z14h0q1qMRH9wVtFT/0vCNFpc45x7gxWV0soOZS9TfLBize9QdwV2Z9lIaGeyC0S1F8dOmH3vLAMFfwIpeXtPPbGzfHCxVCreMxS3P5LJqwWqPag73oUa1WyFf0jLW0bB7TgklQ1J+ZsKVar1FhE55j2NCsatY4ZmXLhHOea9rtPW3luXVdyzE7K2i14XXrqqKlSrPnGo111l0SWdnbsaKcbb2E1mhVX2rljKa5ZORAtZSb6uE2n1ZnRuYmAnlI3ULOc3iNbr7snidrFGG6vF/sYhiSi+swQrSjJA8CdL2l6Ypquvo9EIT/zcC6Txie7FJe5fzCGi4JpkUtnIhVYeDomENUcuWEUvbyZxe1JEBaMdKRWvVoldqvLWEr3SlbB1wYYoBSWsNjz/9Zu05562k2K2Y5en/OmRxqetfYTGEhsnNXWNDL+78DtKiNLEnaK7bDwswx0kcpuAHzax/SJRWDxhVwqDqv/gT1t79/bi6iveFQXTaCZiYyYaCVPoJJFzRNm07H3GcWLDZYeHh0Q0N5c8kuPOhUE45tJ8qfPqk2LsVQc55wWYBc0yk7tGWjYa/A7G/YapI2kHOrJ3cDxAXx6m0UzExkw0EqbQmPvyYl99BQA47ZDlAQBEhiwPACAyZHkAAJEhywMAiAxZHgBAZMjyAAAim673vgIAwNEGfe/rJH9f/sKFC4xN2Sv/YDpcuHBh0k3oDQEMxzPm8Bbz2dfT9lCieNs7E1uEAB41UT8HPPsKAABDgywvgvfff3/STQAYPgT2UGDEBqbRTHyDCGA4HozYAADA0CDLi+CDDz6YdBMAhg+BPRQYsRGBeNs7E1uEAB41UT8HjNgAAMDQ4NlXEeBWBBASAjvRoM++Tl9fvmWqLKbcDKerO/4LD5tlxhhbMifX0LAZXgtPWOp4VRER0XvvvXecYjAK4w/gE0TOYDo2YfQQ2EMxd2ZA42mWYrY555y3jQJpctnqmO29RFhv3C+Opz2pFtc452uLE27FqDTLbMk8xj7t7KhuLnB2/Iy3GXyHjrnk5z+vcsdcUs3W0Fo9DWYmgE+nGQ/sQZP29PXlY6TibZ1Iq0f7KS1TdfcQvnaMN8OHXw8L971wYvDdR3pkQS8poWysG2WV/dl+f8cxlxhbMs3NzjV2t6f8aPCN8U3XrQgtc+WBurUsuX+03WT3LOfvHivVm34GpNLKjkMkFe+p1dvH2eum3vADODEyiYgeleOxFw1XP9e44brj1eAt6fXQzXJn2grjuetEITWwrc3wHMYKKtk0/QxYtpqd7aRmOV4khMAeDh53cHBwcHDAUxwcHHQXObbkqvYMJewKcW7pRKRbwXRDJyJSjL3Ba45V3tCJaKMRW0U4sW0UiApGm/PGBhHpjQHKRie2jYLf2uh2xTfKLdXYIL/UwLq3t7ERfoZtU4k2zOWtyNKpoCjkbazXnuCflk4Fw9jwSjT8usNa3Gr3DIUUpeAt09hI2IqwDR0T3RV1lRpimI3OBAKYN3S/8jAy3a81jKIgXN2vrKFHv9DkJb0F2qbity3cBcKJ4aalB3Y0kDYafrRE2hnuVkl1+vGQ9jnMemD3+n57O6JsWvae8izvBlMkFju+hoFqjlQS7oTRcHf/Lhhtb73xmEsqG+7DYWbnkXiNtD/pMBDZqTpqGEzC9gb7G28bhSDLeOsKo9DSIxmnoft/e/tSx+HKP/55n0BQ4Z6hhC1v6OFuE4iUimhsRL5HS49+p6Jk+WEHcOz7ik701hiLKO+f8ezWvWSkq9F1TAq+6I6JKYHNOff7K/42RuZG6gzWHm1w21QoHjziBXbqdvXtGFl+SkdsasV5xhhj86WKYuxFT2wVY483NojWc8e53JQprm6E9as7DpFjPyMiLccYYyy3TlSxbe9Em6hSmg+GcRLKhhx7l0jJZpJWWshmB2/pQBJuRchklUq13iJq1asVPb9IlClWebWYISKSsguRRRe8ZjfrWkHNZ4iI5Du8uiwREZGeXyQiKX/TzRdS8b4/KxOtxd/2lr3bsb3NMmPzpYq+6lUYTs+t6407/nebySrP7Mmf2w7JiALYsXfTZi1kOz9extj8AzXssqQt6TbrYjxIW3Yt2IrzpRrRbveX0xXY7hhRjhqxfvGR7Bc1olrpPGOMzRdrRLt2ZCAbgT0UU5rlI4dH7/vzp28VMyS/bSiUdFGrD/Id/wBLVCuumC0pe5niPYg1mbzLql6wVtxRtu6yYbVSdoGoZh/nSsvxSsUk3IqQyauFmt0i50m1tpF3Iy4cM5W1cEk/dpMzSPchKhxFzUVqWQh2hlrH8u4naVEuOuraLDN5N57+hDKiAO4/zKxH3tXdhIzej0xWiZ+2Vpd71uTUH9SoYLTvDPCtZi8q8bOT2MeFwB6KKc3yPWSKW6ZCpN0d9Kau4GLp4lpjg9yvUL4eXB9zrxRZkT/kNUsnt/uTVDa0mNeJtEcWEVFzu1Qh/XbvHUy6qip+KeuR1mvxgUj5m4r2yLJf1PTrsrvtuXX/YGYl9LTi/aA0VlnWIuewXTJZpXuiN93rpjk7KpOpEd+fT5djB3AkzJwdNbys2iV7UfH6xc3tUuUYLcyrBao9qDu9VhQhZS+7p8Lk7NztM5qlq6pCteoTJ7ii2+sTQWAPbDazPJG0vKoT1YorgxVbXGubiiZ7gzO65XXb/Yk5zeuJyGt7hrKe83oHG421xZSyIXmNN3S/iG71d3tlpli1dFrPMcbq1Oc5boLEWxGkq6qynsutu2emUY55L2kfDM6F3c7RZo+OZvKenMkuVGzb/Ttyv5rzpFpzz5qb5fniQsLtJS27djlpKEFQxwzgSGTOF2u6lZpQpOVV3R0JkXeVgpd8B2pg8X5Dr5Tme60o1ri3DYW0HGPzRVIKRP2MVGSKVUuvFefd0Y+Okw8E9nAcxO3v7+/v7x+k2N/fp1FffZ3umqdTyvYGV5Yi/yQiUgzLvwEjvJbFOY90hSK3IniXEf17CYILeorZiFz+Coe8ojcVhFf/ote3o8S7x2a6a54t4gX2kdvV72dyRH5OzN7MvW0m0PPXys6dO8dn9tfK2Cy8pfMYn8noPsnjaJnqbdoaaES4q8h0bVEKBPAo/PEf//HPfvYz9+/pCoNhBLbrJNvFWGfSDqRl7+THWcf2jOuYTVHEDNV0/dxHprh1U13Zyfdxvc7lmLer6r3q6RmuOTZRAzgNAjvR0fm5ey5+eRim0Ux8gwhgOJ4T9uXTyuKXhwEATiNkeRFM1899AAwJAnsoMGIjAvG2dya2CAE8aqJ+DhixAQCAoUGWF8F03YoAMCQI7KHAiA1Mo5n4BhHAcDwYsQEAgKE54zixn5o4PDwkorm55Ozvzh2i0T3LdxqeEoTJunDhAgIYjuHChQsnKd6RtAMd2Tvo9WPERgTiba94WwQwFBixAQCAGGR5EeBWBABIgxEbmEb4BgESYcQGAABikOVFgJ/7AIA0GLERgXjbK94WAQwFRmwAACDmjJv+Ax3/7HD0XJgU3GMDcHqk5eG06ejLd3DMJcZY7xe9J7HKjJWbfaxjR2VL5uD1p3rvvfeGWBsAiGTuzIAm3eBRs+2K3uCc35En3ZKTaZkqKx/jSHXSsgAwYoMm7VPWl2+ZKlPVJcbcLNYyVeZyk5pVZjmNtBxTzV9GMl2zzJZMx/ujXHY7+0w1W+7soPtfj68oWrNfD2OMqdsvhrxZuMcGANKcsixPRFRbuM05X5PJKp8vLVicc97Y0HJLpkPyGm/opBh71eJ8SumKRrc5522jUCt9bBGRtTlfIqPNOb9OmrdQd81ELVOVNd3inG9ln9WGu0lp4/L2jho/IAVHGuYdt4jCo1TicFPC8pY/yR/XapkqK5c30ysBgMk5hVleyWaIiKhZ10jPLxIRyW8bSsW2+yruFpHyNxUiInLsZ6TfLkpEtHjLKKTX3LJrBePWIhFJxdv6cDcphVZ6sco5b5tUut1xpGkbVJrfjB+lLF2TI8cDb/ldYy+6vGMu5XbNNuec7xnK+l1/eW33Yptz3tgg7Z6Z/It5ADAJpzDLL3hZnohIy7n9z/OlGu3arSNK+QrZbOzftl1JXK6zZsfePUmjj5bSl1eMt2UikpZX9Uq13uo60qzXrc6jVK36JEzRzpNqraDmM/7yz2yHpOJ9Xl2WiIgy2YXIutSrEhHJ18dzAAOAfp3CLB9RMNo8UC1mkpc6MkFns4W+apaiKXHYUu6xiR7PiDo2JJNViOJHKSl7uauOSmnePVzJGrknJcEYDstp4XKd6wKAKXGKs/xiXq+UtptE7q2NCXeVaPUmETn1B0cMo0v5m4o3RtHcLlXSaw4nOuY9Lb3CIfLPTlpedo8daVp2jSh+lHLsZ111bDTCo5V7McMb8+GcN9BvB5h+pzjLk7y2Z+zKjDE2XyRjby1272SmuGUqmswYW6GbR2UzaXnLoNI8Y+xe1tg4omZ5zdI1mTE2b980lKFuSco9Nt7wSzjwkskq0SPNRl4mKXuZIkcpb+DF27SrajDybm1GL8ASETk7d8dzsAKAEzmI29/f39/fP0ixv79PRHxIhljV2GqeTgnbu2copBumezTRww655R+xwjGltuF3571O+p6hBEWC5f0pba9OUsyGUSDd6lo+Nlo1vC0CAM67k3bP7M0ODg6iSb/nr5WdO3eO49fKpox42yveFgEMBWOdSTuQlr2TH2c9Bc+4CgW/YwNwehydn7vn4peHYRrhGwRIhF8eBgCAGGR5EeB3bAAgDUZsRCDe9oq3RQBDgREbAACIQZYXAe6xAYA0GLGBaYRvECDRMUZs8N5XAIBZgve+EhFdu3Zt0k0YK9xjAwBpMGIjAvG2V7wtAhgK3GMDAAAxyPIiwD02AJAGIzYwjfANAiTCiA0AAMQgy4sA99gAQBqM2IhAvO0Vb4sAhgIjNgAAEIMsLwLcYwMAaVi73Y7++/DwkIjm5pKz/+Hh4Te+8Q2M2PSrZarn7VW+Jk+6ITNnWr5BgCnDWGfSDnRk72AnOiNJUnS5nuPyQ2wujNCRBxhrk9292K4uS0kzAWCqdSTtAMblfc0y85Wb/pQl09z0plktU2WMMabuOJ1FlkyHiMgxl/yyZJWZaraIWqbKyuXNaM1W+XypRlqOlUe9TQn32GSKVZxDAMCpy/ItU5V3jT3OOW+binbP9BJ5pWRf55y3jYKWO2+vcs4tvVbctrwimm5xztsGleY3rfTatd2Lbc55Y4O0e6ZD8tqeoZDe4Guj3qyEcfmWqbKyRe4xrFxeco8+qtkiZ0fNrVOtOB8exgBAXKcsy2eKVV4tZoiIpOxCZIaeXyQiKXuZFPOWTESZrOLOadm1gnFrkYik4m2d1uvpaV5Rr0pEJF/XR9X+46lodNs9htVKH1vScrWxQYqJERuAU+GUZXkiyx9UYbIWTi1ksynLO/Zu+I8g9SdbyGaG0MJj6HWPjXcMy988svkAIKJTluWb5dy63uCcc86tvnrcsS5/y651zG5FDwIT89577x01O/0YBgDCO2VZPuSY97TeSxFRJqtUSttNv8hG3r2kqT2yiMh5Uu3M+wAA0+SUZfnFW0ZByzHG2ArdNpSKbfcskilWLV2TGWPzJTLad2QiqXjPUNZzjLEVUo86I8hkFyZ1jw0AABERsYODg+i/e94vf+7cOTwVNW0Stje4X75ZZvey7ftFicjZUedfrPI7srOjzhdr03wB9rR9gwB9YqwzaQfSsjeyvAjE217xtghgKI6R5c8kJvS0LA/TCb9jA3B6HJ2fE/ry+OVhmEL4BgES4ZeHAQAgBlleBLjHBgDSYMRGBOJtr3hbBDAUGLEBAIAYZHkR4B4bAEiDERuYRvgGARIdY8TmTMfrn45+GxTeFQUAMFlpeTht+iSffrp27RpjbESVj65mGINr165NugkAgpjkiA0AAAwE99gAAEAMsjwAgMiQ5QEARIYsDwAgMmR5AACRIcsDAIgMWR4AQGR49hUAYJYM+uwr+vIAACLDe18BAGbJoO99RV8eAEBkyPIAACJDlgcAEBmyPACAyJDlAQBEhiwPACAyZHkAAJEhywMAiOyM4zjRfx8eHhLR3Fxy9nfnAgDApHQk7UBH9g7eHYj3vgIAzAy89xUAAGKQ5QEARIYsDwAgMmR5AACRIcsDAIgMWR4AQGTI8gAAIsN7XwEAZgne+woAACG89xUAYJbgva8AABBClgcAEBmyPACAyJDlAQBEhiwPACAyZHkAAJEhywMAiAzPvgIAzBI8+woAACE8+woAMEvw7CsAAISQ5QEARIYsDwAgMmR5AACRIcsDAIgMWR4AQGTI8gAAIsOzrwAAswTPvgIAQAjPvgIAzBI8+woAACFkeQAAkSHLAwCIDFkeAEBkyPIAACJDlgcAEBmyPACAyJDlAQBEdsZxnOi/Dw8PiWhuLjn7u3MBAGBSOpJ2oCN7M8Y450Tk/V/A/SWEtGervvrqq9dee62jCAAAjEeQu7ulZW+M2AAAiAxZHgBAZMjyAAAiQ5YHABAZsjwAgMiQ5QEARIYsDwAgMrz3FQBgluC9rwAAEMJ7XwEAZgne+woAACFkeQAAkSHLAwCIDFkeAEBkyPIAACJDlgcAEBmyPACAyPDsKwDALMGzrwAAEMKzrwAAswTPvgIAQAhZHgBAZMjyAAAiQ5YHABAZsjwAgMiQ5QEARIYsDwAgMjz7CgAwSwZ99vU4Tz8xxo5RCgAAxm/gZ18PDg7S5rpHkiPKOo4jSdIxyp5kLtaL9WK9WO9pWK8Lz74CAJwuyPIAACJDlgcAEBmyPACAyJDlAQBEhiwPACAyZHkAAJEhywMAiIy12+3ovw8PD4lobi45+3fMZYxxzoO//+3f/i2YG50V+OKLL37v936vn5qxXqwX68V6sd6hrLdzHdP5TBfWi/VivVgv1nu8mjFiAwAgMmR5AACRIcsDAIgMWR4AQGTI8gAAIkOWBwAQGbI8AIDIhvne155vhT08PBz0jYVYL9aL9WK9WO9JakZfHgBAZAO/9/Ukc+fm5kZUM9aL9WK9WC/Wmzj3/wcwv8aR0jupFQAAAABJRU5ErkJggg==)\n","- ROW_NUMBER VS FIRST_VALUE/LAST_VALUE\n","- ROW_NUMBER를 사용한다면?\n","  - 특정 레코드에 일련 번호를 붙여 SELECT 하는 것 (새로운 field를 추가)\n","  - 일련 번호를 붙일 때는 특정 값(field1)을 기준으로 그룹핑을 하고 ORDER BY를 기준으로 일련 번호를 붙인다.\n","  - ROW_NUMBER() OVER(PARTITION BY field1 ORDER BY field2) NN\n","  - ORDER BY에서 TS(시간)을 오름차순으로 했을 때 첫 번째로 나오는 값이 처음 채널, 내림차순으로 했을 때 첫 번째로 나오는 값이 마지막 채널이 된다.\n","  "],"metadata":{"id":"H3fGARm98JrD"}},{"cell_type":"markdown","source":["- 사용자별이라는 점에서 USERID가 필요하므로 USER_SESSION_CHANNEL 테이블을 사용해야 한다.\n","- 또한 최초, 최종 채널을 구해야 하므로 시간 정보가 필요하다. SESSION_TIMESTAMP가 필요하다.\n","- 이 두 테이블을 조인하여야 하는데 이 두 테이블은 완전한 ONE-TO-ONE의 경우로 INNER JOIN을 사용하면 된다."],"metadata":{"id":"d57JLjX7O-Cd"}},{"cell_type":"code","source":["%%sql\n","\n","WITH TS_RANK AS (\n","      SELECT A.USERID  \n","          , A.SESSIONID\n","          , A.CHANNEL\n","          , ROW_NUMBER() OVER (PARTITION BY A.USERID ORDER BY B.TS DESC) LAST_CHANNEL\n","          , ROW_NUMBER() OVER (PARTITION BY A.USERID ORDER BY B.TS ASC)  FIRST_CHANNEL\n","        FROM RAW_DATA.USER_SESSION_CHANNEL A\n","        JOIN RAW_DATA.SESSION_TIMESTAMP B\n","          ON A.SESSIONID = B.SESSIONID\n",")\n","SELECT T.USERID\n","     , (SELECT CHANNEL\n","          FROM TS_RANK\n","         WHERE USERID = T.USERID\n","           AND FIRST_CHANNEL = 1)       FIRST_CHANNEL\n","     , (SELECT CHANNEL \n","          FROM TS_RANK\n","         WHERE USERID = T.USERID\n","           AND LAST_CHANNEL = 1)        LAST_CHANNEL\n","  FROM TS_RANK T \n","GROUP BY 1"],"metadata":{"id":"X2Sh_RG43EE2","colab":{"base_uri":"https://localhost:8080/","height":1000},"executionInfo":{"status":"ok","timestamp":1683801777238,"user_tz":-540,"elapsed":7494,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"b3f41ec4-f0ef-49b3-e8a3-9976961deb58"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","949 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(44, 'Instagram', 'Naver'),\n"," (113, 'Organic', 'Organic'),\n"," (163, 'Naver', 'Google'),\n"," (191, 'Instagram', 'Naver'),\n"," (197, 'Youtube', 'Naver'),\n"," (210, 'Google', 'Google'),\n"," (229, 'Facebook', 'Google'),\n"," (231, 'Instagram', 'Naver'),\n"," (243, 'Instagram', 'Youtube'),\n"," (251, 'Google', 'Facebook'),\n"," (255, 'Instagram', 'Facebook'),\n"," (258, 'Facebook', 'Google'),\n"," (277, 'Naver', 'Naver'),\n"," (278, 'Organic', 'Naver'),\n"," (385, 'Organic', 'Instagram'),\n"," (409, 'Organic', 'Facebook'),\n"," (538, 'Organic', 'Youtube'),\n"," (586, 'Organic', 'Naver'),\n"," (654, 'Naver', 'Naver'),\n"," (682, 'Facebook', 'Organic'),\n"," (707, 'Facebook', 'Facebook'),\n"," (710, 'Organic', 'Youtube'),\n"," (711, 'Naver', 'Organic'),\n"," (735, 'Google', 'Organic'),\n"," (774, 'Naver', 'Facebook'),\n"," (793, 'Organic', 'Organic'),\n"," (801, 'Google', 'Facebook'),\n"," (825, 'Google', 'Naver'),\n"," (832, 'Facebook', 'Youtube'),\n"," (845, 'Facebook', 'Youtube'),\n"," (931, 'Naver', 'Youtube'),\n"," (937, 'Google', 'Instagram'),\n"," (963, 'Naver', 'Youtube'),\n"," (971, 'Facebook', 'Naver'),\n"," (975, 'Facebook', 'Youtube'),\n"," (981, 'Naver', 'Naver'),\n"," (993, 'Google', 'Naver'),\n"," (995, 'Organic', 'Organic'),\n"," (1001, 'Youtube', 'Google'),\n"," (1035, 'Instagram', 'Instagram'),\n"," (1041, 'Google', 'Organic'),\n"," (1053, 'Organic', 'Youtube'),\n"," (1055, 'Instagram', 'Google'),\n"," (1069, 'Facebook', 'Naver'),\n"," (1073, 'Youtube', 'Google'),\n"," (1079, 'Facebook', 'Naver'),\n"," (1083, 'Google', 'Naver'),\n"," (1085, 'Youtube', 'Organic'),\n"," (1095, 'Organic', 'Google'),\n"," (1103, 'Instagram', 'Google'),\n"," (1133, 'Facebook', 'Google'),\n"," (1135, 'Naver', 'Youtube'),\n"," (1139, 'Organic', 'Youtube'),\n"," (1157, 'Google', 'Google'),\n"," (1167, 'Youtube', 'Youtube'),\n"," (1175, 'Organic', 'Naver'),\n"," (1177, 'Instagram', 'Naver'),\n"," (1185, 'Instagram', 'Instagram'),\n"," (1195, 'Organic', 'Organic'),\n"," (1197, 'Google', 'Instagram'),\n"," (1203, 'Google', 'Facebook'),\n"," (1223, 'Google', 'Instagram'),\n"," (1227, 'Youtube', 'Naver'),\n"," (1231, 'Organic', 'Organic'),\n"," (1239, 'Instagram', 'Google'),\n"," (1245, 'Facebook', 'Facebook'),\n"," (1249, 'Naver', 'Organic'),\n"," (1251, 'Facebook', 'Instagram'),\n"," (1253, 'Naver', 'Google'),\n"," (1285, 'Organic', 'Youtube'),\n"," (1297, 'Facebook', 'Organic'),\n"," (1299, 'Organic', 'Youtube'),\n"," (1307, 'Naver', 'Google'),\n"," (1313, 'Naver', 'Facebook'),\n"," (1321, 'Facebook', 'Google'),\n"," (1335, 'Youtube', 'Youtube'),\n"," (1337, 'Instagram', 'Youtube'),\n"," (1363, 'Google', 'Organic'),\n"," (1369, 'Facebook', 'Instagram'),\n"," (1375, 'Google', 'Organic'),\n"," (1385, 'Google', 'Google'),\n"," (1393, 'Organic', 'Youtube'),\n"," (1401, 'Google', 'Organic'),\n"," (1409, 'Organic', 'Google'),\n"," (1415, 'Organic', 'Google'),\n"," (1421, 'Naver', 'Organic'),\n"," (1429, 'Organic', 'Organic'),\n"," (1445, 'Facebook', 'Google'),\n"," (1455, 'Organic', 'Organic'),\n"," (1497, 'Youtube', 'Facebook'),\n"," (1515, 'Instagram', 'Instagram'),\n"," (1519, 'Youtube', 'Organic'),\n"," (1535, 'Google', 'Organic'),\n"," (1539, 'Google', 'Instagram'),\n"," (1569, 'Youtube', 'Google'),\n"," (1583, 'Youtube', 'Naver'),\n"," (1595, 'Naver', 'Instagram'),\n"," (1611, 'Facebook', 'Google'),\n"," (1621, 'Facebook', 'Youtube'),\n"," (1643, 'Youtube', 'Naver'),\n"," (1649, 'Facebook', 'Instagram'),\n"," (1653, 'Youtube', 'Facebook'),\n"," (1659, 'Facebook', 'Google'),\n"," (1675, 'Naver', 'Instagram'),\n"," (1687, 'Google', 'Organic'),\n"," (1701, 'Google', 'Instagram'),\n"," (1705, 'Instagram', 'Google'),\n"," (1711, 'Facebook', 'Naver'),\n"," (1723, 'Google', 'Naver'),\n"," (1731, 'Google', 'Google'),\n"," (1733, 'Facebook', 'Youtube'),\n"," (1737, 'Google', 'Facebook'),\n"," (1743, 'Youtube', 'Facebook'),\n"," (1753, 'Organic', 'Naver'),\n"," (1769, 'Google', 'Youtube'),\n"," (1771, 'Naver', 'Youtube'),\n"," (1785, 'Youtube', 'Organic'),\n"," (1787, 'Organic', 'Youtube'),\n"," (1809, 'Google', 'Youtube'),\n"," (1815, 'Instagram', 'Facebook'),\n"," (1827, 'Naver', 'Youtube'),\n"," (1837, 'Instagram', 'Naver'),\n"," (1885, 'Youtube', 'Instagram'),\n"," (1901, 'Naver', 'Instagram'),\n"," (1907, 'Facebook', 'Facebook'),\n"," (1927, 'Organic', 'Google'),\n"," (1931, 'Google', 'Google'),\n"," (1943, 'Facebook', 'Organic'),\n"," (1951, 'Organic', 'Facebook'),\n"," (1977, 'Organic', 'Organic'),\n"," (1981, 'Naver', 'Facebook'),\n"," (1987, 'Facebook', 'Organic'),\n"," (1989, 'Instagram', 'Youtube'),\n"," (1999, 'Youtube', 'Google'),\n"," (2013, 'Youtube', 'Instagram'),\n"," (2037, 'Google', 'Youtube'),\n"," (2043, 'Facebook', 'Facebook'),\n"," (2047, 'Youtube', 'Facebook'),\n"," (2049, 'Organic', 'Naver'),\n"," (2069, 'Instagram', 'Organic'),\n"," (2071, 'Organic', 'Naver'),\n"," (2079, 'Youtube', 'Facebook'),\n"," (2091, 'Naver', 'Youtube'),\n"," (2097, 'Organic', 'Google'),\n"," (2111, 'Google', 'Facebook'),\n"," (2113, 'Naver', 'Organic'),\n"," (2123, 'Google', 'Naver'),\n"," (2127, 'Naver', 'Youtube'),\n"," (2147, 'Google', 'Google'),\n"," (2151, 'Facebook', 'Google'),\n"," (2159, 'Organic', 'Organic'),\n"," (2169, 'Google', 'Naver'),\n"," (2171, 'Organic', 'Organic'),\n"," (2179, 'Google', 'Organic'),\n"," (2189, 'Instagram', 'Instagram'),\n"," (2201, 'Facebook', 'Google'),\n"," (2211, 'Organic', 'Facebook'),\n"," (2217, 'Organic', 'Naver'),\n"," (2225, 'Instagram', 'Organic'),\n"," (2247, 'Facebook', 'Organic'),\n"," (2263, 'Google', 'Naver'),\n"," (2265, 'Youtube', 'Organic'),\n"," (2273, 'Google', 'Google'),\n"," (2283, 'Facebook', 'Instagram'),\n"," (2287, 'Google', 'Naver'),\n"," (2309, 'Youtube', 'Google'),\n"," (2319, 'Naver', 'Instagram'),\n"," (2357, 'Naver', 'Naver'),\n"," (2379, 'Facebook', 'Google'),\n"," (2400, 'Naver', 'Naver'),\n"," (2408, 'Facebook', 'Organic'),\n"," (2410, 'Youtube', 'Organic'),\n"," (2424, 'Naver', 'Facebook'),\n"," (2430, 'Naver', 'Instagram'),\n"," (2462, 'Organic', 'Organic'),\n"," (2474, 'Youtube', 'Naver'),\n"," (2490, 'Organic', 'Instagram'),\n"," (2504, 'Instagram', 'Facebook'),\n"," (2528, 'Instagram', 'Facebook'),\n"," (2532, 'Instagram', 'Instagram'),\n"," (2548, 'Instagram', 'Facebook'),\n"," (2556, 'Organic', 'Instagram'),\n"," (2574, 'Facebook', 'Google'),\n"," (2580, 'Organic', 'Youtube'),\n"," (2600, 'Google', 'Youtube'),\n"," (2604, 'Youtube', 'Facebook'),\n"," (2606, 'Youtube', 'Naver'),\n"," (2612, 'Facebook', 'Organic'),\n"," (2616, 'Youtube', 'Organic'),\n"," (2626, 'Facebook', 'Naver'),\n"," (2634, 'Facebook', 'Youtube'),\n"," (2638, 'Youtube', 'Instagram'),\n"," (2660, 'Organic', 'Google'),\n"," (2666, 'Organic', 'Instagram'),\n"," (2672, 'Organic', 'Youtube'),\n"," (2684, 'Naver', 'Youtube'),\n"," (2694, 'Naver', 'Youtube'),\n"," (2696, 'Organic', 'Youtube'),\n"," (2708, 'Naver', 'Naver'),\n"," (2732, 'Naver', 'Youtube'),\n"," (2744, 'Organic', 'Organic'),\n"," (2762, 'Instagram', 'Youtube'),\n"," (2766, 'Facebook', 'Naver'),\n"," (2768, 'Google', 'Organic'),\n"," (2770, 'Naver', 'Youtube'),\n"," (2790, 'Youtube', 'Organic'),\n"," (2794, 'Instagram', 'Instagram'),\n"," (3195, 'Instagram', 'Google'),\n"," (34, 'Naver', 'Youtube'),\n"," (64, 'Youtube', 'Youtube'),\n"," (65, 'Organic', 'Youtube'),\n"," (69, 'Instagram', 'Facebook'),\n"," (84, 'Youtube', 'Google'),\n"," (112, 'Youtube', 'Facebook'),\n"," (117, 'Youtube', 'Organic'),\n"," (173, 'Organic', 'Google'),\n"," (181, 'Instagram', 'Facebook'),\n"," (184, 'Youtube', 'Youtube'),\n"," (201, 'Youtube', 'Instagram'),\n"," (203, 'Facebook', 'Naver'),\n"," (222, 'Google', 'Facebook'),\n"," (226, 'Instagram', 'Organic'),\n"," (227, 'Google', 'Google'),\n"," (233, 'Organic', 'Facebook'),\n"," (240, 'Organic', 'Organic'),\n"," (246, 'Google', 'Organic'),\n"," (254, 'Facebook', 'Facebook'),\n"," (256, 'Instagram', 'Naver'),\n"," (257, 'Organic', 'Instagram'),\n"," (282, 'Facebook', 'Naver'),\n"," (301, 'Facebook', 'Naver'),\n"," (341, 'Facebook', 'Naver'),\n"," (345, 'Organic', 'Google'),\n"," (27, 'Instagram', 'Youtube'),\n"," (29, 'Naver', 'Naver'),\n"," (33, 'Youtube', 'Google'),\n"," (40, 'Google', 'Youtube'),\n"," (59, 'Instagram', 'Instagram'),\n"," (68, 'Organic', 'Youtube'),\n"," (87, 'Google', 'Youtube'),\n"," (97, 'Organic', 'Organic'),\n"," (114, 'Youtube', 'Instagram'),\n"," (187, 'Youtube', 'Organic'),\n"," (196, 'Naver', 'Facebook'),\n"," (213, 'Organic', 'Naver'),\n"," (216, 'Naver', 'Instagram'),\n"," (218, 'Youtube', 'Google'),\n"," (223, 'Facebook', 'Youtube'),\n"," (225, 'Naver', 'Facebook'),\n"," (232, 'Naver', 'Instagram'),\n"," (248, 'Instagram', 'Naver'),\n"," (253, 'Youtube', 'Facebook'),\n"," (265, 'Instagram', 'Facebook'),\n"," (266, 'Instagram', 'Google'),\n"," (267, 'Naver', 'Instagram'),\n"," (269, 'Organic', 'Facebook'),\n"," (280, 'Organic', 'Google'),\n"," (363, 'Facebook', 'Naver'),\n"," (420, 'Facebook', 'Youtube'),\n"," (465, 'Youtube', 'Organic'),\n"," (468, 'Facebook', 'Instagram'),\n"," (473, 'Naver', 'Youtube'),\n"," (533, 'Google', 'Instagram'),\n"," (626, 'Google', 'Facebook'),\n"," (645, 'Organic', 'Youtube'),\n"," (676, 'Facebook', 'Instagram'),\n"," (683, 'Youtube', 'Youtube'),\n"," (694, 'Organic', 'Google'),\n"," (698, 'Facebook', 'Organic'),\n"," (706, 'Facebook', 'Youtube'),\n"," (708, 'Instagram', 'Organic'),\n"," (757, 'Google', 'Google'),\n"," (763, 'Youtube', 'Naver'),\n"," (768, 'Youtube', 'Organic'),\n"," (780, 'Naver', 'Instagram'),\n"," (786, 'Naver', 'Youtube'),\n"," (790, 'Google', 'Facebook'),\n"," (803, 'Organic', 'Instagram'),\n"," (805, 'Facebook', 'Instagram'),\n"," (810, 'Naver', 'Instagram'),\n"," (812, 'Facebook', 'Google'),\n"," (847, 'Facebook', 'Google'),\n"," (849, 'Google', 'Facebook'),\n"," (855, 'Naver', 'Naver'),\n"," (873, 'Naver', 'Instagram'),\n"," (887, 'Facebook', 'Facebook'),\n"," (889, 'Instagram', 'Organic'),\n"," (897, 'Organic', 'Facebook'),\n"," (905, 'Instagram', 'Youtube'),\n"," (909, 'Facebook', 'Naver'),\n"," (913, 'Naver', 'Organic'),\n"," (943, 'Google', 'Naver'),\n"," (947, 'Youtube', 'Naver'),\n"," (949, 'Instagram', 'Instagram'),\n"," (955, 'Google', 'Youtube'),\n"," (979, 'Naver', 'Organic'),\n"," (983, 'Organic', 'Instagram'),\n"," (1003, 'Google', 'Instagram'),\n"," (1033, 'Instagram', 'Youtube'),\n"," (1045, 'Google', 'Youtube'),\n"," (1059, 'Facebook', 'Organic'),\n"," (1067, 'Naver', 'Google'),\n"," (1075, 'Facebook', 'Organic'),\n"," (1081, 'Youtube', 'Facebook'),\n"," (1093, 'Youtube', 'Youtube'),\n"," (1105, 'Google', 'Google'),\n"," (1111, 'Youtube', 'Facebook'),\n"," (1115, 'Google', 'Google'),\n"," (1127, 'Facebook', 'Instagram'),\n"," (1151, 'Organic', 'Google'),\n"," (1159, 'Google', 'Organic'),\n"," (1165, 'Google', 'Google'),\n"," (1169, 'Facebook', 'Naver'),\n"," (1171, 'Naver', 'Facebook'),\n"," (1189, 'Facebook', 'Facebook'),\n"," (1193, 'Facebook', 'Organic'),\n"," (1213, 'Organic', 'Naver'),\n"," (1217, 'Youtube', 'Youtube'),\n"," (1233, 'Naver', 'Facebook'),\n"," (1273, 'Google', 'Google'),\n"," (1279, 'Instagram', 'Naver'),\n"," (1291, 'Naver', 'Instagram'),\n"," (1295, 'Instagram', 'Organic'),\n"," (1301, 'Youtube', 'Organic'),\n"," (1309, 'Google', 'Naver'),\n"," (1353, 'Facebook', 'Naver'),\n"," (1361, 'Facebook', 'Google'),\n"," (1367, 'Google', 'Instagram'),\n"," (1379, 'Google', 'Organic'),\n"," (1411, 'Google', 'Instagram'),\n"," (1417, 'Naver', 'Naver'),\n"," (1419, 'Instagram', 'Facebook'),\n"," (1427, 'Youtube', 'Youtube'),\n"," (1431, 'Instagram', 'Instagram'),\n"," (1433, 'Naver', 'Instagram'),\n"," (1441, 'Google', 'Naver'),\n"," (1449, 'Organic', 'Facebook'),\n"," (1453, 'Google', 'Facebook'),\n"," (1459, 'Facebook', 'Google'),\n"," (1461, 'Youtube', 'Instagram'),\n"," (1465, 'Naver', 'Organic'),\n"," (1477, 'Google', 'Organic'),\n"," (1507, 'Youtube', 'Facebook'),\n"," (1521, 'Youtube', 'Organic'),\n"," (1533, 'Instagram', 'Instagram'),\n"," (1537, 'Organic', 'Facebook'),\n"," (1557, 'Organic', 'Naver'),\n"," (1567, 'Facebook', 'Instagram'),\n"," (1575, 'Naver', 'Organic'),\n"," (1597, 'Naver', 'Instagram'),\n"," (1599, 'Organic', 'Facebook'),\n"," (1609, 'Instagram', 'Instagram'),\n"," (1613, 'Facebook', 'Facebook'),\n"," (1615, 'Google', 'Organic'),\n"," (1617, 'Facebook', 'Facebook'),\n"," (1639, 'Organic', 'Facebook'),\n"," (1647, 'Instagram', 'Youtube'),\n"," (1657, 'Facebook', 'Google'),\n"," (1667, 'Google', 'Youtube'),\n"," (1673, 'Google', 'Instagram'),\n"," (1677, 'Instagram', 'Naver'),\n"," (1679, 'Google', 'Organic'),\n"," (1681, 'Organic', 'Naver'),\n"," (1697, 'Naver', 'Naver'),\n"," (1707, 'Google', 'Facebook'),\n"," (1709, 'Facebook', 'Instagram'),\n"," (1735, 'Google', 'Facebook'),\n"," (1755, 'Organic', 'Google'),\n"," (1759, 'Google', 'Instagram'),\n"," (1767, 'Instagram', 'Instagram'),\n"," (1791, 'Youtube', 'Naver'),\n"," (1795, 'Google', 'Google'),\n"," (1801, 'Youtube', 'Google'),\n"," (1803, 'Naver', 'Instagram'),\n"," (1817, 'Naver', 'Organic'),\n"," (1821, 'Instagram', 'Naver'),\n"," (1831, 'Naver', 'Youtube'),\n"," (1849, 'Instagram', 'Google'),\n"," (1853, 'Instagram', 'Organic'),\n"," (1871, 'Youtube', 'Facebook'),\n"," (1873, 'Google', 'Naver'),\n"," (1881, 'Organic', 'Organic'),\n"," (1891, 'Facebook', 'Naver'),\n"," (1893, 'Naver', 'Youtube'),\n"," (1897, 'Naver', 'Facebook'),\n"," (1899, 'Organic', 'Youtube'),\n"," (1917, 'Instagram', 'Instagram'),\n"," (1945, 'Organic', 'Facebook'),\n"," (1949, 'Organic', 'Youtube'),\n"," (1953, 'Facebook', 'Google'),\n"," (1963, 'Organic', 'Google'),\n"," (1971, 'Youtube', 'Instagram'),\n"," (1973, 'Organic', 'Organic'),\n"," (1979, 'Instagram', 'Instagram'),\n"," (1991, 'Organic', 'Google'),\n"," (1995, 'Instagram', 'Facebook'),\n"," (2009, 'Facebook', 'Youtube'),\n"," (2019, 'Youtube', 'Facebook'),\n"," (2035, 'Instagram', 'Instagram'),\n"," (2039, 'Youtube', 'Facebook'),\n"," (2051, 'Naver', 'Facebook'),\n"," (2055, 'Google', 'Naver'),\n"," (2061, 'Youtube', 'Organic'),\n"," (2067, 'Youtube', 'Facebook'),\n"," (2087, 'Naver', 'Facebook'),\n"," (2101, 'Naver', 'Facebook'),\n"," (2107, 'Instagram', 'Naver'),\n"," (2115, 'Facebook', 'Organic'),\n"," (2119, 'Facebook', 'Naver'),\n"," (2121, 'Youtube', 'Youtube'),\n"," (2131, 'Naver', 'Naver'),\n"," (2133, 'Naver', 'Organic'),\n"," (2161, 'Organic', 'Organic'),\n"," (2167, 'Instagram', 'Google'),\n"," (2175, 'Youtube', 'Facebook'),\n"," (2193, 'Youtube', 'Instagram'),\n"," (2197, 'Organic', 'Youtube'),\n"," (2213, 'Instagram', 'Youtube'),\n"," (2215, 'Organic', 'Youtube'),\n"," (2227, 'Instagram', 'Naver'),\n"," (2231, 'Facebook', 'Instagram'),\n"," (2241, 'Organic', 'Google'),\n"," (2257, 'Organic', 'Organic'),\n"," (2261, 'Instagram', 'Instagram'),\n"," (2267, 'Youtube', 'Google'),\n"," (2291, 'Organic', 'Google'),\n"," (2297, 'Google', 'Naver'),\n"," (2299, 'Organic', 'Instagram'),\n"," (2303, 'Naver', 'Facebook'),\n"," (2313, 'Facebook', 'Youtube'),\n"," (2323, 'Facebook', 'Google'),\n"," (2329, 'Organic', 'Google'),\n"," (2331, 'Google', 'Google'),\n"," (2335, 'Youtube', 'Google'),\n"," (2347, 'Facebook', 'Facebook'),\n"," (2349, 'Organic', 'Instagram'),\n"," (2353, 'Organic', 'Google'),\n"," (2359, 'Instagram', 'Organic'),\n"," (2363, 'Naver', 'Organic'),\n"," (2369, 'Instagram', 'Organic'),\n"," (2387, 'Instagram', 'Organic'),\n"," (2422, 'Organic', 'Youtube'),\n"," (2438, 'Naver', 'Naver'),\n"," (2448, 'Facebook', 'Facebook'),\n"," (2452, 'Google', 'Organic'),\n"," (2466, 'Google', 'Instagram'),\n"," (2472, 'Instagram', 'Facebook'),\n"," (2486, 'Instagram', 'Youtube'),\n"," (2494, 'Naver', 'Naver'),\n"," (2496, 'Instagram', 'Youtube'),\n"," (2508, 'Naver', 'Facebook'),\n"," (2538, 'Organic', 'Youtube'),\n"," (2542, 'Facebook', 'Facebook'),\n"," (2550, 'Google', 'Facebook'),\n"," (2562, 'Youtube', 'Google'),\n"," (2572, 'Google', 'Google'),\n"," (2576, 'Youtube', 'Facebook'),\n"," (2582, 'Naver', 'Youtube'),\n"," (2618, 'Instagram', 'Instagram'),\n"," (2620, 'Organic', 'Instagram'),\n"," (2622, 'Youtube', 'Google'),\n"," (2628, 'Naver', 'Organic'),\n"," (2636, 'Naver', 'Youtube'),\n"," (2658, 'Google', 'Google'),\n"," (2698, 'Facebook', 'Naver'),\n"," (355, 'Naver', 'Google'),\n"," (474, 'Naver', 'Facebook'),\n"," (494, 'Facebook', 'Youtube'),\n"," (572, 'Naver', 'Organic'),\n"," (599, 'Google', 'Organic'),\n"," (686, 'Organic', 'Instagram'),\n"," (715, 'Naver', 'Instagram'),\n"," (738, 'Google', 'Google'),\n"," (744, 'Naver', 'Facebook'),\n"," (750, 'Google', 'Facebook'),\n"," (765, 'Naver', 'Naver'),\n"," (772, 'Instagram', 'Youtube'),\n"," (778, 'Instagram', 'Instagram'),\n"," (789, 'Instagram', 'Google'),\n"," (795, 'Google', 'Google'),\n"," (808, 'Facebook', 'Organic'),\n"," (841, 'Organic', 'Naver'),\n"," (867, 'Youtube', 'Naver'),\n"," (876, 'Organic', 'Naver'),\n"," (899, 'Instagram', 'Instagram'),\n"," (907, 'Naver', 'Naver'),\n"," (911, 'Facebook', 'Google'),\n"," (919, 'Instagram', 'Naver'),\n"," (935, 'Facebook', 'Organic'),\n"," (945, 'Facebook', 'Naver'),\n"," (951, 'Google', 'Naver'),\n"," (965, 'Organic', 'Facebook'),\n"," (969, 'Organic', 'Instagram'),\n"," (973, 'Facebook', 'Organic'),\n"," (977, 'Facebook', 'Youtube'),\n"," (989, 'Naver', 'Facebook'),\n"," (997, 'Instagram', 'Google'),\n"," (1007, 'Google', 'Youtube'),\n"," (1011, 'Instagram', 'Google'),\n"," (1015, 'Naver', 'Naver'),\n"," (1023, 'Naver', 'Instagram'),\n"," (1027, 'Facebook', 'Organic'),\n"," (1029, 'Organic', 'Organic'),\n"," (1039, 'Naver', 'Organic'),\n"," (1047, 'Facebook', 'Naver'),\n"," (1051, 'Facebook', 'Naver'),\n"," (1065, 'Facebook', 'Facebook'),\n"," (1089, 'Youtube', 'Organic'),\n"," (1091, 'Instagram', 'Facebook'),\n"," (1109, 'Google', 'Google'),\n"," (1117, 'Organic', 'Instagram'),\n"," (1121, 'Google', 'Google'),\n"," (1125, 'Instagram', 'Naver'),\n"," (1137, 'Naver', 'Facebook'),\n"," (1145, 'Google', 'Youtube'),\n"," (1179, 'Google', 'Google'),\n"," (1183, 'Google', 'Facebook'),\n"," (1205, 'Instagram', 'Organic'),\n"," (1211, 'Youtube', 'Youtube'),\n"," (1219, 'Google', 'Naver'),\n"," (1221, 'Organic', 'Instagram'),\n"," (1237, 'Facebook', 'Google'),\n"," (1241, 'Organic', 'Naver'),\n"," (1243, 'Instagram', 'Instagram'),\n"," (1247, 'Naver', 'Facebook'),\n"," (1257, 'Google', 'Google'),\n"," (1261, 'Instagram', 'Instagram'),\n"," (1263, 'Facebook', 'Organic'),\n"," (1265, 'Youtube', 'Organic'),\n"," (1269, 'Organic', 'Google'),\n"," (1277, 'Youtube', 'Instagram'),\n"," (1281, 'Google', 'Youtube'),\n"," (1283, 'Youtube', 'Youtube'),\n"," (1287, 'Organic', 'Instagram'),\n"," (1303, 'Youtube', 'Naver'),\n"," (1319, 'Youtube', 'Google'),\n"," (1329, 'Naver', 'Organic'),\n"," (1331, 'Google', 'Youtube'),\n"," (1341, 'Naver', 'Facebook'),\n"," (1345, 'Organic', 'Instagram'),\n"," (1351, 'Google', 'Naver'),\n"," (1381, 'Youtube', 'Google'),\n"," (1389, 'Organic', 'Google'),\n"," (1395, 'Facebook', 'Youtube'),\n"," (1399, 'Instagram', 'Instagram'),\n"," (1425, 'Youtube', 'Facebook'),\n"," (1443, 'Google', 'Google'),\n"," (1467, 'Facebook', 'Google'),\n"," (1471, 'Youtube', 'Organic'),\n"," (1479, 'Organic', 'Youtube'),\n"," (1489, 'Organic', 'Organic'),\n"," (1493, 'Youtube', 'Youtube'),\n"," (1495, 'Instagram', 'Facebook'),\n"," (1513, 'Instagram', 'Facebook'),\n"," (1523, 'Naver', 'Facebook'),\n"," (1525, 'Youtube', 'Naver'),\n"," (1545, 'Facebook', 'Organic'),\n"," (1547, 'Naver', 'Naver'),\n"," (1555, 'Google', 'Google'),\n"," (1559, 'Facebook', 'Organic'),\n"," (1563, 'Organic', 'Google'),\n"," (1573, 'Google', 'Google'),\n"," (1577, 'Youtube', 'Instagram'),\n"," (1587, 'Naver', 'Instagram'),\n"," (1589, 'Google', 'Facebook'),\n"," (1591, 'Youtube', 'Facebook'),\n"," (1601, 'Instagram', 'Youtube'),\n"," (1603, 'Instagram', 'Google'),\n"," (1605, 'Instagram', 'Facebook'),\n"," (1619, 'Organic', 'Instagram'),\n"," (1625, 'Youtube', 'Naver'),\n"," (1627, 'Instagram', 'Google'),\n"," (1637, 'Facebook', 'Facebook'),\n"," (1661, 'Facebook', 'Naver'),\n"," (1663, 'Naver', 'Facebook'),\n"," (1665, 'Organic', 'Organic'),\n"," (1671, 'Youtube', 'Youtube'),\n"," (1693, 'Instagram', 'Instagram'),\n"," (1695, 'Youtube', 'Naver'),\n"," (1699, 'Facebook', 'Naver'),\n"," (1717, 'Google', 'Naver'),\n"," (1773, 'Google', 'Google'),\n"," (1783, 'Facebook', 'Youtube'),\n"," (1789, 'Organic', 'Facebook'),\n"," (1793, 'Youtube', 'Naver'),\n"," (1797, 'Naver', 'Organic'),\n"," (1799, 'Organic', 'Facebook'),\n"," (1825, 'Google', 'Naver'),\n"," (1855, 'Google', 'Organic'),\n"," (1877, 'Facebook', 'Naver'),\n"," (1883, 'Youtube', 'Organic'),\n"," (1889, 'Naver', 'Instagram'),\n"," (1895, 'Youtube', 'Facebook'),\n"," (1909, 'Facebook', 'Google'),\n"," (1929, 'Organic', 'Organic'),\n"," (1935, 'Naver', 'Facebook'),\n"," (1941, 'Organic', 'Facebook'),\n"," (1957, 'Organic', 'Instagram'),\n"," (1959, 'Youtube', 'Google'),\n"," (1961, 'Youtube', 'Organic'),\n"," (1983, 'Organic', 'Youtube'),\n"," (1985, 'Facebook', 'Facebook'),\n"," (1997, 'Youtube', 'Youtube'),\n"," (2011, 'Organic', 'Instagram'),\n"," (2021, 'Google', 'Youtube'),\n"," (2029, 'Naver', 'Youtube'),\n"," (2041, 'Instagram', 'Organic'),\n"," (2053, 'Organic', 'Facebook'),\n"," (2065, 'Google', 'Organic'),\n"," (2073, 'Facebook', 'Google'),\n"," (2081, 'Naver', 'Organic'),\n"," (2083, 'Organic', 'Organic'),\n"," (2085, 'Organic', 'Naver'),\n"," (2089, 'Instagram', 'Instagram'),\n"," (2093, 'Naver', 'Organic'),\n"," (2103, 'Youtube', 'Google'),\n"," (2117, 'Facebook', 'Google'),\n"," (2137, 'Google', 'Instagram'),\n"," (2143, 'Instagram', 'Instagram'),\n"," (2149, 'Naver', 'Instagram'),\n"," (2155, 'Naver', 'Naver'),\n"," (2163, 'Organic', 'Naver'),\n"," (2165, 'Instagram', 'Organic'),\n"," (2185, 'Facebook', 'Instagram'),\n"," (2199, 'Naver', 'Naver'),\n"," (2207, 'Naver', 'Naver'),\n"," (2219, 'Facebook', 'Instagram'),\n"," (2229, 'Organic', 'Youtube'),\n"," (2237, 'Google', 'Instagram'),\n"," (2245, 'Instagram', 'Organic'),\n"," (2249, 'Organic', 'Organic'),\n"," (2259, 'Naver', 'Youtube'),\n"," (2269, 'Instagram', 'Instagram'),\n"," (2271, 'Organic', 'Google'),\n"," (2275, 'Organic', 'Instagram'),\n"," (2293, 'Youtube', 'Naver'),\n"," (2307, 'Google', 'Google'),\n"," (2311, 'Facebook', 'Naver'),\n"," (2315, 'Instagram', 'Naver'),\n"," (2337, 'Organic', 'Google'),\n"," (2345, 'Instagram', 'Instagram'),\n"," (2355, 'Facebook', 'Facebook'),\n"," (2365, 'Instagram', 'Facebook'),\n"," (2377, 'Naver', 'Facebook'),\n"," (2383, 'Naver', 'Organic'),\n"," (2391, 'Naver', 'Facebook'),\n"," (2404, 'Youtube', 'Youtube'),\n"," (2412, 'Organic', 'Youtube'),\n"," (2414, 'Naver', 'Youtube'),\n"," (2418, 'Instagram', 'Instagram'),\n"," (2426, 'Google', 'Organic'),\n"," (2432, 'Youtube', 'Facebook'),\n"," (2440, 'Youtube', 'Instagram'),\n"," (2456, 'Facebook', 'Naver'),\n"," (2468, 'Organic', 'Naver'),\n"," (2478, 'Instagram', 'Facebook'),\n"," (2492, 'Instagram', 'Organic'),\n"," (2498, 'Facebook', 'Instagram'),\n"," (2502, 'Youtube', 'Google'),\n"," (2514, 'Youtube', 'Instagram'),\n"," (2516, 'Facebook', 'Instagram'),\n"," (2522, 'Organic', 'Youtube'),\n"," (2530, 'Organic', 'Instagram'),\n"," (2536, 'Youtube', 'Youtube'),\n"," (2540, 'Naver', 'Youtube'),\n"," (2544, 'Naver', 'Instagram'),\n"," (2552, 'Facebook', 'Google'),\n"," (2566, 'Instagram', 'Google'),\n"," (2578, 'Google', 'Youtube'),\n"," (2598, 'Organic', 'Google'),\n"," (2630, 'Youtube', 'Youtube'),\n"," (2642, 'Instagram', 'Organic'),\n"," (2650, 'Youtube', 'Youtube'),\n"," (2668, 'Facebook', 'Organic'),\n"," (2680, 'Instagram', 'Google'),\n"," (2682, 'Naver', 'Naver'),\n"," (2692, 'Facebook', 'Naver'),\n"," (2720, 'Google', 'Instagram'),\n"," (2752, 'Organic', 'Google'),\n"," (2754, 'Instagram', 'Youtube'),\n"," (2760, 'Organic', 'Instagram'),\n"," (2772, 'Instagram', 'Youtube'),\n"," (2778, 'Google', 'Google'),\n"," (2792, 'Google', 'Naver'),\n"," (2802, 'Naver', 'Google'),\n"," (3070, 'Youtube', 'Youtube'),\n"," (5722, 'Instagram', 'Youtube'),\n"," (2702, 'Youtube', 'Instagram'),\n"," (2726, 'Instagram', 'Facebook'),\n"," (2728, 'Naver', 'Organic'),\n"," (2730, 'Google', 'Facebook'),\n"," (2734, 'Facebook', 'Facebook'),\n"," (2738, 'Naver', 'Youtube'),\n"," (2746, 'Google', 'Organic'),\n"," (2750, 'Facebook', 'Instagram'),\n"," (2758, 'Youtube', 'Google'),\n"," (2784, 'Naver', 'Facebook'),\n"," (2788, 'Youtube', 'Youtube'),\n"," (2798, 'Instagram', 'Instagram'),\n"," (2806, 'Naver', 'Instagram'),\n"," (36, 'Youtube', 'Naver'),\n"," (41, 'Youtube', 'Facebook'),\n"," (45, 'Instagram', 'Youtube'),\n"," (80, 'Naver', 'Organic'),\n"," (192, 'Google', 'Facebook'),\n"," (193, 'Facebook', 'Google'),\n"," (198, 'Google', 'Facebook'),\n"," (199, 'Instagram', 'Naver'),\n"," (204, 'Youtube', 'Naver'),\n"," (207, 'Youtube', 'Facebook'),\n"," (230, 'Google', 'Naver'),\n"," (236, 'Youtube', 'Naver'),\n"," (237, 'Google', 'Organic'),\n"," (250, 'Facebook', 'Instagram'),\n"," (259, 'Naver', 'Google'),\n"," (260, 'Youtube', 'Naver'),\n"," (262, 'Instagram', 'Organic'),\n"," (264, 'Facebook', 'Google'),\n"," (270, 'Youtube', 'Facebook'),\n"," (272, 'Naver', 'Naver'),\n"," (329, 'Youtube', 'Naver'),\n"," (368, 'Youtube', 'Organic'),\n"," (369, 'Organic', 'Youtube'),\n"," (371, 'Google', 'Google'),\n"," (437, 'Instagram', 'Organic'),\n"," (510, 'Facebook', 'Naver'),\n"," (511, 'Google', 'Google'),\n"," (543, 'Instagram', 'Naver'),\n"," (587, 'Google', 'Youtube'),\n"," (643, 'Facebook', 'Facebook'),\n"," (656, 'Youtube', 'Google'),\n"," (661, 'Google', 'Youtube'),\n"," (699, 'Organic', 'Youtube'),\n"," (700, 'Organic', 'Instagram'),\n"," (702, 'Youtube', 'Instagram'),\n"," (712, 'Google', 'Organic'),\n"," (732, 'Facebook', 'Organic'),\n"," (752, 'Facebook', 'Organic'),\n"," (771, 'Organic', 'Facebook'),\n"," (779, 'Naver', 'Instagram'),\n"," (782, 'Google', 'Google'),\n"," (785, 'Facebook', 'Organic'),\n"," (787, 'Naver', 'Organic'),\n"," (788, 'Facebook', 'Naver'),\n"," (822, 'Organic', 'Organic'),\n"," (830, 'Instagram', 'Organic'),\n"," (836, 'Facebook', 'Instagram'),\n"," (852, 'Organic', 'Google'),\n"," (858, 'Instagram', 'Organic'),\n"," (879, 'Youtube', 'Facebook'),\n"," (881, 'Youtube', 'Youtube'),\n"," (891, 'Youtube', 'Google'),\n"," (895, 'Instagram', 'Youtube'),\n"," (901, 'Youtube', 'Youtube'),\n"," (917, 'Youtube', 'Facebook'),\n"," (921, 'Facebook', 'Organic'),\n"," (923, 'Facebook', 'Organic'),\n"," (927, 'Organic', 'Naver'),\n"," (929, 'Naver', 'Naver'),\n"," (939, 'Instagram', 'Youtube'),\n"," (953, 'Organic', 'Google'),\n"," (957, 'Youtube', 'Google'),\n"," (961, 'Youtube', 'Facebook'),\n"," (967, 'Organic', 'Facebook'),\n"," (985, 'Organic', 'Google'),\n"," (987, 'Google', 'Youtube'),\n"," (998, 'Naver', 'Naver'),\n"," (1005, 'Organic', 'Google'),\n"," (1009, 'Google', 'Youtube'),\n"," (1013, 'Youtube', 'Facebook'),\n"," (1031, 'Naver', 'Organic'),\n"," (1037, 'Google', 'Organic'),\n"," (1043, 'Instagram', 'Organic'),\n"," (1049, 'Youtube', 'Naver'),\n"," (1063, 'Instagram', 'Google'),\n"," (1087, 'Google', 'Facebook'),\n"," (1099, 'Instagram', 'Naver'),\n"," (1119, 'Instagram', 'Google'),\n"," (1141, 'Facebook', 'Google'),\n"," (1153, 'Google', 'Youtube'),\n"," (1155, 'Naver', 'Facebook'),\n"," (1163, 'Naver', 'Youtube'),\n"," (1181, 'Youtube', 'Youtube'),\n"," (1187, 'Instagram', 'Instagram'),\n"," (1191, 'Youtube', 'Organic'),\n"," (1199, 'Google', 'Naver'),\n"," (1215, 'Naver', 'Facebook'),\n"," (1229, 'Organic', 'Google'),\n"," (1259, 'Facebook', 'Facebook'),\n"," (1289, 'Naver', 'Naver'),\n"," (1293, 'Instagram', 'Google'),\n"," (1305, 'Google', 'Organic'),\n"," (1311, 'Facebook', 'Naver'),\n"," (1315, 'Google', 'Naver'),\n"," (1317, 'Organic', 'Youtube'),\n"," (1325, 'Organic', 'Organic'),\n"," (1343, 'Youtube', 'Naver'),\n"," (1349, 'Instagram', 'Organic'),\n"," (1357, 'Youtube', 'Instagram'),\n"," (1371, 'Naver', 'Naver'),\n"," (1377, 'Youtube', 'Youtube'),\n"," (1383, 'Google', 'Youtube'),\n"," (1387, 'Google', 'Google'),\n"," (1391, 'Google', 'Youtube'),\n"," (1397, 'Youtube', 'Instagram'),\n"," (1405, 'Youtube', 'Youtube'),\n"," (1435, 'Facebook', 'Youtube'),\n"," (1463, 'Instagram', 'Youtube'),\n"," (1469, 'Naver', 'Google'),\n"," (1473, 'Naver', 'Facebook'),\n"," (1475, 'Facebook', 'Google'),\n"," (1483, 'Naver', 'Facebook'),\n"," (1485, 'Facebook', 'Naver'),\n"," (1487, 'Instagram', 'Naver'),\n"," (1491, 'Facebook', 'Organic'),\n"," (1501, 'Youtube', 'Google'),\n"," (1503, 'Facebook', 'Google'),\n"," (1511, 'Instagram', 'Youtube'),\n"," (1517, 'Organic', 'Instagram'),\n"," (1529, 'Organic', 'Youtube'),\n"," (1531, 'Naver', 'Facebook'),\n"," (1541, 'Naver', 'Google'),\n"," (1543, 'Facebook', 'Instagram'),\n"," (1551, 'Instagram', 'Facebook'),\n"," (1565, 'Instagram', 'Facebook'),\n"," (1571, 'Youtube', 'Facebook'),\n"," (1607, 'Organic', 'Youtube'),\n"," (1631, 'Organic', 'Instagram'),\n"," (1635, 'Google', 'Naver'),\n"," (1641, 'Instagram', 'Google'),\n"," (1645, 'Facebook', 'Instagram'),\n"," (1651, 'Youtube', 'Google'),\n"," (1655, 'Google', 'Facebook'),\n"," (1685, 'Youtube', 'Instagram'),\n"," (1689, 'Facebook', 'Facebook'),\n"," (1703, 'Instagram', 'Naver'),\n"," (1713, 'Youtube', 'Google'),\n"," (1719, 'Youtube', 'Facebook'),\n"," (1721, 'Youtube', 'Google'),\n"," (1725, 'Organic', 'Google'),\n"," (1727, 'Facebook', 'Organic'),\n"," (1729, 'Google', 'Facebook'),\n"," (1741, 'Google', 'Organic'),\n"," (1745, 'Organic', 'Youtube'),\n"," (1749, 'Instagram', 'Naver'),\n"," (1757, 'Instagram', 'Naver'),\n"," (1761, 'Naver', 'Naver'),\n"," (1772, 'Instagram', 'Instagram'),\n"," (1775, 'Naver', 'Instagram'),\n"," (1777, 'Organic', 'Google'),\n"," (1779, 'Naver', 'Google'),\n"," (1805, 'Naver', 'Facebook'),\n"," (1807, 'Facebook', 'Naver'),\n"," (1811, 'Organic', 'Organic'),\n"," (1819, 'Youtube', 'Google'),\n"," (1823, 'Facebook', 'Google'),\n"," (1829, 'Organic', 'Naver'),\n"," (1835, 'Google', 'Organic'),\n"," (1839, 'Facebook', 'Instagram'),\n"," (1851, 'Naver', 'Facebook'),\n"," (1857, 'Organic', 'Google'),\n"," (1861, 'Naver', 'Organic'),\n"," (1875, 'Naver', 'Youtube'),\n"," (1879, 'Naver', 'Youtube'),\n"," (1887, 'Youtube', 'Organic'),\n"," (1903, 'Instagram', 'Facebook'),\n"," (1911, 'Facebook', 'Facebook'),\n"," (1915, 'Google', 'Naver'),\n"," (1919, 'Naver', 'Organic'),\n"," (1921, 'Google', 'Instagram'),\n"," (1937, 'Google', 'Google'),\n"," (1947, 'Instagram', 'Organic'),\n"," (1955, 'Organic', 'Instagram'),\n"," (1965, 'Youtube', 'Facebook'),\n"," (1967, 'Naver', 'Youtube'),\n"," (1975, 'Instagram', 'Google'),\n"," (1993, 'Google', 'Naver'),\n"," (2001, 'Instagram', 'Youtube'),\n"," (2005, 'Organic', 'Google'),\n"," (2007, 'Naver', 'Youtube'),\n"," (2017, 'Naver', 'Instagram'),\n"," (2025, 'Naver', 'Instagram'),\n"," (2027, 'Facebook', 'Youtube'),\n"," (2057, 'Facebook', 'Organic'),\n"," (2063, 'Youtube', 'Instagram'),\n"," (2125, 'Naver', 'Facebook'),\n"," (2129, 'Youtube', 'Instagram'),\n"," (2139, 'Facebook', 'Naver'),\n"," (2141, 'Facebook', 'Youtube'),\n"," (2145, 'Google', 'Instagram'),\n"," (2173, 'Instagram', 'Naver'),\n"," (2181, 'Google', 'Naver'),\n"," (2195, 'Google', 'Naver'),\n"," (2243, 'Facebook', 'Youtube'),\n"," (2253, 'Organic', 'Youtube'),\n"," (2279, 'Instagram', 'Facebook'),\n"," (2295, 'Naver', 'Google'),\n"," (2317, 'Naver', 'Naver'),\n"," (2321, 'Instagram', 'Google'),\n"," (2327, 'Organic', 'Naver'),\n"," (2339, 'Naver', 'Instagram'),\n"," (2341, 'Naver', 'Facebook'),\n"," (2361, 'Naver', 'Youtube'),\n"," (2367, 'Facebook', 'Organic'),\n"," (2385, 'Facebook', 'Instagram'),\n"," (2389, 'Organic', 'Organic'),\n"," (2420, 'Facebook', 'Instagram'),\n"," (2446, 'Naver', 'Instagram'),\n"," (2450, 'Google', 'Google'),\n"," (2470, 'Google', 'Google'),\n"," (2476, 'Google', 'Facebook'),\n"," (2510, 'Instagram', 'Organic'),\n"," (2520, 'Naver', 'Youtube'),\n"," (2524, 'Google', 'Organic'),\n"," (2526, 'Instagram', 'Google'),\n"," (2534, 'Youtube', 'Organic'),\n"," (2558, 'Youtube', 'Organic'),\n"," (2564, 'Google', 'Instagram'),\n"," (2568, 'Google', 'Naver'),\n"," (2588, 'Instagram', 'Instagram'),\n"," (2590, 'Organic', 'Facebook'),\n"," (2596, 'Youtube', 'Instagram'),\n"," (2610, 'Facebook', 'Naver'),\n"," (2614, 'Organic', 'Naver'),\n"," (2632, 'Instagram', 'Instagram'),\n"," (2640, 'Google', 'Organic'),\n"," (2644, 'Youtube', 'Instagram'),\n"," (2646, 'Instagram', 'Instagram'),\n"," (2648, 'Google', 'Google'),\n"," (2652, 'Naver', 'Google'),\n"," (2656, 'Youtube', 'Instagram'),\n"," (2662, 'Instagram', 'Google'),\n"," (2664, 'Youtube', 'Organic'),\n"," (2670, 'Instagram', 'Youtube'),\n"," (2676, 'Youtube', 'Facebook'),\n"," (2678, 'Organic', 'Organic'),\n"," (2704, 'Facebook', 'Facebook'),\n"," (2706, 'Facebook', 'Youtube'),\n"," (2710, 'Google', 'Naver'),\n"," (2712, 'Instagram', 'Facebook'),\n"," (2714, 'Google', 'Facebook'),\n"," (2716, 'Instagram', 'Youtube'),\n"," (2722, 'Youtube', 'Google'),\n"," (2724, 'Youtube', 'Youtube'),\n"," (2748, 'Facebook', 'Naver'),\n"," (2776, 'Facebook', 'Instagram'),\n"," (2780, 'Youtube', 'Google'),\n"," (2804, 'Instagram', 'Organic'),\n"," (2808, 'Naver', 'Google')]"],"text/html":["<table>\n","    <tr>\n","        <th>userid</th>\n","        <th>last_channel</th>\n","        <th>first_channel</th>\n","    </tr>\n","    <tr>\n","        <td>44</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>113</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>163</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>191</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>197</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>210</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>229</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>231</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>243</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>251</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>255</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>258</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>277</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>278</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>385</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>409</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>538</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>586</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>654</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>682</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>707</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>710</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>711</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>735</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>774</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>793</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>801</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>825</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>832</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>845</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>931</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>937</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>963</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>971</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>975</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>981</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>993</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>995</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1001</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1035</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1041</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1053</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1055</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1069</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1073</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1079</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1083</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1085</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1095</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1103</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1133</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1135</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1139</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1157</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1167</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1175</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1177</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1185</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1195</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1197</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1203</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1223</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1227</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1231</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1239</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1245</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1249</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1251</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1253</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1285</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1297</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1299</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1307</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1313</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1321</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1335</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1337</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1363</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1369</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1375</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1385</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1393</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1401</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1409</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1415</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1421</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1429</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1445</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1455</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1497</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1515</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1519</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1535</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1539</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1569</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1583</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1595</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1611</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1621</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1643</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1649</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1653</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1659</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1675</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1687</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1701</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1705</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1711</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1723</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1731</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1733</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1737</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1743</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1753</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1769</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1771</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1785</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1787</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1809</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1815</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1827</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1837</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1885</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1901</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1907</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1927</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1931</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1943</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1951</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1977</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1981</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1987</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1989</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1999</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2013</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2037</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2043</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2047</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2049</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2069</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2071</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2079</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2091</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2097</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2111</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2113</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2123</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2127</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2147</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2151</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2159</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2169</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2171</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2179</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2189</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2201</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2211</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2217</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2225</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2247</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2263</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2265</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2273</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2283</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2287</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2309</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2319</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2357</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2379</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2400</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2408</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2410</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2424</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2430</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2462</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2474</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2490</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2504</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2528</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2532</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2548</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2556</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2574</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2580</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2600</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2604</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2606</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2612</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2616</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2626</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2634</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2638</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2660</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2666</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2672</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2684</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2694</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2696</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2708</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2732</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2744</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2762</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2766</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2768</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2770</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2790</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2794</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>3195</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>34</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>64</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>65</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>69</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>84</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>112</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>117</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>173</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>181</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>184</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>201</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>203</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>222</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>226</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>227</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>233</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>240</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>246</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>254</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>256</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>257</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>282</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>301</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>341</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>345</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>27</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>29</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>33</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>40</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>59</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>68</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>87</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>97</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>114</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>187</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>196</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>213</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>216</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>218</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>223</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>225</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>232</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>248</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>253</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>265</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>266</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>267</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>269</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>280</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>363</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>420</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>465</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>468</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>473</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>533</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>626</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>645</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>676</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>683</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>694</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>698</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>706</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>708</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>757</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>763</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>768</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>780</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>786</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>790</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>803</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>805</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>810</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>812</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>847</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>849</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>855</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>873</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>887</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>889</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>897</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>905</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>909</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>913</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>943</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>947</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>949</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>955</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>979</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>983</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1003</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1033</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1045</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1059</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1067</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1075</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1081</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1093</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1105</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1111</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1115</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1127</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1151</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1159</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1165</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1169</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1171</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1189</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1193</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1213</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1217</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1233</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1273</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1279</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1291</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1295</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1301</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1309</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1353</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1361</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1367</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1379</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1411</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1417</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1419</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1427</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1431</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1433</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1441</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1449</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1453</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1459</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1461</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1465</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1477</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1507</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1521</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1533</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1537</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1557</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1567</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1575</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1597</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1599</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1609</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1613</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1615</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1617</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1639</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1647</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1657</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1667</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1673</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1677</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1679</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1681</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1697</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1707</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1709</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1735</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1755</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1759</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1767</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1791</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1795</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1801</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1803</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1817</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1821</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1831</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1849</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1853</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1871</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1873</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1881</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1891</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1893</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1897</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1899</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1917</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1945</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1949</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1953</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1963</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1971</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1973</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1979</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1991</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1995</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2009</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2019</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2035</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2039</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2051</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2055</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2061</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2067</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2087</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2101</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2107</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2115</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2119</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2121</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2131</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2133</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2161</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2167</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2175</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2193</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2197</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2213</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2215</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2227</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2231</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2241</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2257</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2261</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2267</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2291</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2297</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2299</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2303</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2313</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2323</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2329</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2331</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2335</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2347</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2349</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2353</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2359</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2363</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2369</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2387</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2422</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2438</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2448</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2452</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2466</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2472</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2486</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2494</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2496</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2508</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2538</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2542</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2550</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2562</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2572</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2576</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2582</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2618</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2620</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2622</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2628</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2636</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2658</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2698</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>355</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>474</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>494</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>572</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>599</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>686</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>715</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>738</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>744</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>750</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>765</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>772</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>778</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>789</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>795</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>808</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>841</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>867</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>876</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>899</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>907</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>911</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>919</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>935</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>945</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>951</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>965</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>969</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>973</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>977</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>989</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>997</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1007</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1011</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1015</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1023</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1027</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1029</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1039</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1047</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1051</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1065</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1089</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1091</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1109</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1117</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1121</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1125</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1137</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1145</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1179</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1183</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1205</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1211</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1219</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1221</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1237</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1241</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1243</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1247</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1257</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1261</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1263</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1265</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1269</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1277</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1281</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1283</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1287</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1303</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1319</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1329</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1331</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1341</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1345</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1351</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1381</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1389</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1395</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1399</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1425</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1443</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1467</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1471</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1479</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1489</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1493</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1495</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1513</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1523</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1525</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1545</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1547</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1555</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1559</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1563</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1573</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1577</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1587</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1589</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1591</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1601</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1603</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1605</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1619</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1625</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1627</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1637</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1661</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1663</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1665</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1671</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1693</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1695</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1699</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1717</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1773</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1783</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1789</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1793</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1797</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1799</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1825</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1855</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1877</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1883</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1889</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1895</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1909</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1929</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1935</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1941</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1957</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1959</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1961</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1983</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1985</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1997</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2011</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2021</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2029</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2041</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2053</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2065</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2073</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2081</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2083</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2085</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2089</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2093</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2103</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2117</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2137</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2143</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2149</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2155</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2163</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2165</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2185</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2199</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2207</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2219</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2229</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2237</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2245</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2249</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2259</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2269</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2271</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2275</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2293</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2307</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2311</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2315</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2337</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2345</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2355</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2365</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2377</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2383</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2391</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2404</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2412</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2414</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2418</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2426</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2432</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2440</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2456</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2468</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2478</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2492</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2498</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2502</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2514</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2516</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2522</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2530</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2536</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2540</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2544</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2552</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2566</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2578</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2598</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2630</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2642</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2650</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2668</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2680</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2682</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2692</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2720</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2752</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2754</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2760</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2772</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2778</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2792</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2802</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>3070</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>5722</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2702</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2726</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2728</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2730</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2734</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2738</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2746</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2750</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2758</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2784</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2788</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2798</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2806</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>36</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>41</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>45</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>80</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>192</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>193</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>198</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>199</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>204</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>207</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>230</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>236</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>237</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>250</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>259</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>260</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>262</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>264</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>270</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>272</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>329</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>368</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>369</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>371</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>437</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>510</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>511</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>543</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>587</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>643</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>656</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>661</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>699</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>700</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>702</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>712</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>732</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>752</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>771</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>779</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>782</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>785</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>787</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>788</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>822</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>830</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>836</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>852</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>858</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>879</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>881</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>891</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>895</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>901</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>917</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>921</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>923</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>927</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>929</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>939</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>953</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>957</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>961</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>967</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>985</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>987</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>998</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1005</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1009</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1013</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1031</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1037</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1043</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1049</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1063</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1087</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1099</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1119</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1141</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1153</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1155</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1163</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1181</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1187</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1191</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1199</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1215</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1229</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1259</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1289</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1293</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1305</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1311</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1315</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1317</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1325</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1343</td>\n","        <td>Youtube</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1349</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1357</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1371</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1377</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1383</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1387</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1391</td>\n","        <td>Google</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1397</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1405</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1435</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1463</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1469</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1473</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1475</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1483</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1485</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1487</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1491</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1501</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1503</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1511</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1517</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1529</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1531</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1541</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1543</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1551</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1565</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1571</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1607</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1631</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1635</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1641</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1645</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1651</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1655</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1685</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1689</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1703</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1713</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1719</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1721</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1725</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1727</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1729</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1741</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1745</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1749</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1757</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1761</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1772</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1775</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1777</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1779</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1805</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1807</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1811</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1819</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1823</td>\n","        <td>Facebook</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1829</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1835</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1839</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1851</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1857</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1861</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1875</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1879</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1887</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1903</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1911</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1915</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>1919</td>\n","        <td>Naver</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1921</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1937</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1947</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>1955</td>\n","        <td>Organic</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>1965</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>1967</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>1975</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>1993</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2001</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2005</td>\n","        <td>Organic</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2007</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2017</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2025</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2027</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2057</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2063</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2125</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2129</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2139</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2141</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2145</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2173</td>\n","        <td>Instagram</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2181</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2195</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2243</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2253</td>\n","        <td>Organic</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2279</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2295</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2317</td>\n","        <td>Naver</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2321</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2327</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2339</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2341</td>\n","        <td>Naver</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2361</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2367</td>\n","        <td>Facebook</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2385</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2389</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2420</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2446</td>\n","        <td>Naver</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2450</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2470</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2476</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2510</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2520</td>\n","        <td>Naver</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2524</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2526</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2534</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2558</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2564</td>\n","        <td>Google</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2568</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2588</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2590</td>\n","        <td>Organic</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2596</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2610</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2614</td>\n","        <td>Organic</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2632</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2640</td>\n","        <td>Google</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2644</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2646</td>\n","        <td>Instagram</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2648</td>\n","        <td>Google</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2652</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2656</td>\n","        <td>Youtube</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2662</td>\n","        <td>Instagram</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2664</td>\n","        <td>Youtube</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2670</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2676</td>\n","        <td>Youtube</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2678</td>\n","        <td>Organic</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2704</td>\n","        <td>Facebook</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2706</td>\n","        <td>Facebook</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2710</td>\n","        <td>Google</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2712</td>\n","        <td>Instagram</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2714</td>\n","        <td>Google</td>\n","        <td>Facebook</td>\n","    </tr>\n","    <tr>\n","        <td>2716</td>\n","        <td>Instagram</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2722</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2724</td>\n","        <td>Youtube</td>\n","        <td>Youtube</td>\n","    </tr>\n","    <tr>\n","        <td>2748</td>\n","        <td>Facebook</td>\n","        <td>Naver</td>\n","    </tr>\n","    <tr>\n","        <td>2776</td>\n","        <td>Facebook</td>\n","        <td>Instagram</td>\n","    </tr>\n","    <tr>\n","        <td>2780</td>\n","        <td>Youtube</td>\n","        <td>Google</td>\n","    </tr>\n","    <tr>\n","        <td>2804</td>\n","        <td>Instagram</td>\n","        <td>Organic</td>\n","    </tr>\n","    <tr>\n","        <td>2808</td>\n","        <td>Naver</td>\n","        <td>Google</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":55}]},{"cell_type":"markdown","source":["### 2) Gross Revenue가 가장 큰 UserID 10 개 찾기\n","\n","- USERID를 가지고 있는 건 USER_SESSION_CHANNEL\n","- 매출 정보를 가지고 있는 건 SESSION_TRANSACTION\n","- 두 테이블의 조인만으로도 결과 값을 얻어올 수 있다."],"metadata":{"id":"0LceNmL_DpPc"}},{"cell_type":"code","source":["%%sql\n","\n","SELECT A.USERID\n","     , SUM(B.AMOUNT)  GROSS_REVENUE\n","  FROM RAW_DATA.USER_SESSION_CHANNEL A\n","  JOIN RAW_DATA.SESSION_TRANSACTION B\n","    ON A.SESSIONID = B.SESSIONID \n","GROUP BY A.USERID\n","ORDER BY GROSS_REVENUE DESC\n","LIMIT 10; "],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":291},"id":"_aG8tDXDDsq8","executionInfo":{"status":"ok","timestamp":1683796288871,"user_tz":-540,"elapsed":817,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"e98500cc-d29e-445f-b9eb-394b0cb60ae2"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","10 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(989, 743),\n"," (772, 556),\n"," (1615, 506),\n"," (654, 488),\n"," (1651, 463),\n"," (973, 438),\n"," (262, 422),\n"," (1099, 421),\n"," (2682, 414),\n"," (891, 412)]"],"text/html":["<table>\n","    <tr>\n","        <th>userid</th>\n","        <th>gross_revenue</th>\n","    </tr>\n","    <tr>\n","        <td>989</td>\n","        <td>743</td>\n","    </tr>\n","    <tr>\n","        <td>772</td>\n","        <td>556</td>\n","    </tr>\n","    <tr>\n","        <td>1615</td>\n","        <td>506</td>\n","    </tr>\n","    <tr>\n","        <td>654</td>\n","        <td>488</td>\n","    </tr>\n","    <tr>\n","        <td>1651</td>\n","        <td>463</td>\n","    </tr>\n","    <tr>\n","        <td>973</td>\n","        <td>438</td>\n","    </tr>\n","    <tr>\n","        <td>262</td>\n","        <td>422</td>\n","    </tr>\n","    <tr>\n","        <td>1099</td>\n","        <td>421</td>\n","    </tr>\n","    <tr>\n","        <td>2682</td>\n","        <td>414</td>\n","    </tr>\n","    <tr>\n","        <td>891</td>\n","        <td>412</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":26}]},{"cell_type":"markdown","source":["### 3) raw_data.nps 테이블을 바탕으로 월별 NPS 계산\n","\n","먼저 raw_data.nps 테이블의 데이터를 보자"],"metadata":{"id":"biqWhPwXDtYq"}},{"cell_type":"code","source":["%%sql\n","\n","SELECT *\n","  FROM raw_data.nps\n","LIMIT 10;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":291},"id":"LzAqlxyYDvhI","executionInfo":{"status":"ok","timestamp":1683796721906,"user_tz":-540,"elapsed":461,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"41436af6-1e96-46fb-df9d-ee3f570e8c39"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","10 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(3, datetime.datetime(2019, 1, 2, 3, 47, 26), 9),\n"," (7, datetime.datetime(2019, 1, 4, 23, 6, 18), 2),\n"," (11, datetime.datetime(2019, 1, 6, 13, 22, 47), 10),\n"," (15, datetime.datetime(2019, 1, 6, 2, 33, 32), 2),\n"," (19, datetime.datetime(2019, 1, 7, 7, 1, 43), 1),\n"," (23, datetime.datetime(2019, 1, 8, 11, 31, 55), 10),\n"," (27, datetime.datetime(2019, 1, 8, 15, 29, 46), 8),\n"," (31, datetime.datetime(2019, 1, 10, 22, 23, 31), 10),\n"," (35, datetime.datetime(2019, 1, 11, 3, 37, 48), 10),\n"," (39, datetime.datetime(2019, 1, 12, 13, 46, 5), 0)]"],"text/html":["<table>\n","    <tr>\n","        <th>id</th>\n","        <th>created_at</th>\n","        <th>score</th>\n","    </tr>\n","    <tr>\n","        <td>3</td>\n","        <td>2019-01-02 03:47:26</td>\n","        <td>9</td>\n","    </tr>\n","    <tr>\n","        <td>7</td>\n","        <td>2019-01-04 23:06:18</td>\n","        <td>2</td>\n","    </tr>\n","    <tr>\n","        <td>11</td>\n","        <td>2019-01-06 13:22:47</td>\n","        <td>10</td>\n","    </tr>\n","    <tr>\n","        <td>15</td>\n","        <td>2019-01-06 02:33:32</td>\n","        <td>2</td>\n","    </tr>\n","    <tr>\n","        <td>19</td>\n","        <td>2019-01-07 07:01:43</td>\n","        <td>1</td>\n","    </tr>\n","    <tr>\n","        <td>23</td>\n","        <td>2019-01-08 11:31:55</td>\n","        <td>10</td>\n","    </tr>\n","    <tr>\n","        <td>27</td>\n","        <td>2019-01-08 15:29:46</td>\n","        <td>8</td>\n","    </tr>\n","    <tr>\n","        <td>31</td>\n","        <td>2019-01-10 22:23:31</td>\n","        <td>10</td>\n","    </tr>\n","    <tr>\n","        <td>35</td>\n","        <td>2019-01-11 03:37:48</td>\n","        <td>10</td>\n","    </tr>\n","    <tr>\n","        <td>39</td>\n","        <td>2019-01-12 13:46:05</td>\n","        <td>0</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":27}]},{"cell_type":"markdown","source":["raw_data.nps 구조\n","- ID \n","- CREATED_AT\n","- SCORE\n","\n","NPS를 구하기 위해서는 score 9에서 10을 준 promoter의 비율과 0에서 6을 준 detractor의 비율을 구하여야 한다.\n","\n","그 전에 ID 값이 PK의 유일성을 만족하고 있는지 확인해 보자. "],"metadata":{"id":"5keajNewG2Hp"}},{"cell_type":"code","source":["%%sql\n","\n","SELECT ID\n","     , COUNT(1) ID_CNT\n","  FROM RAW_DATA.NPS\n","GROUP BY 1\n","ORDER BY ID_CNT DESC\n","LIMIT 1;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":98},"id":"1IMmfkGPGvqn","executionInfo":{"status":"ok","timestamp":1683796898220,"user_tz":-540,"elapsed":790,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"2cc741ab-447e-4a6f-c1a1-d94c17906b77"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","1 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[(5, 1)]"],"text/html":["<table>\n","    <tr>\n","        <th>id</th>\n","        <th>id_cnt</th>\n","    </tr>\n","    <tr>\n","        <td>5</td>\n","        <td>1</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":30}]},{"cell_type":"code","source":["%%sql\n","\n","SELECT TO_CHAR(CREATED_AT, 'YYYY-MM')  \"MONTH\"\n","     , COUNT(*) TOTAL_CNT\n","     , COUNT(CASE WHEN SCORE >= 0 AND SCORE < 7\n","                  THEN ID END)         DETRACTOR_CNT\n","     , COUNT(CASE WHEN SCORE >= 9\n","                  THEN ID END)         PROMOTER_CNT\n","  FROM RAW_DATA.NPS\n","GROUP BY 1;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":333},"id":"xJC1so-3HIot","executionInfo":{"status":"ok","timestamp":1683797628561,"user_tz":-540,"elapsed":4858,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"46f9cef5-f91c-4261-d941-cfbec5014af4"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","12 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[('2019-01', 127, 61, 64),\n"," ('2019-02', 632, 188, 381),\n"," ('2019-03', 1635, 316, 1181),\n"," ('2019-04', 2870, 532, 2053),\n"," ('2019-08', 14691, 1826, 11774),\n"," ('2019-11', 28892, 4490, 22197),\n"," ('2019-12', 47744, 6500, 38007),\n"," ('2019-05', 4358, 763, 3139),\n"," ('2019-06', 6487, 894, 5112),\n"," ('2019-07', 9677, 1298, 7541),\n"," ('2019-09', 18115, 4900, 11774),\n"," ('2019-10', 22529, 4270, 16276)]"],"text/html":["<table>\n","    <tr>\n","        <th>month</th>\n","        <th>total_cnt</th>\n","        <th>detractor_cnt</th>\n","        <th>promoter_cnt</th>\n","    </tr>\n","    <tr>\n","        <td>2019-01</td>\n","        <td>127</td>\n","        <td>61</td>\n","        <td>64</td>\n","    </tr>\n","    <tr>\n","        <td>2019-02</td>\n","        <td>632</td>\n","        <td>188</td>\n","        <td>381</td>\n","    </tr>\n","    <tr>\n","        <td>2019-03</td>\n","        <td>1635</td>\n","        <td>316</td>\n","        <td>1181</td>\n","    </tr>\n","    <tr>\n","        <td>2019-04</td>\n","        <td>2870</td>\n","        <td>532</td>\n","        <td>2053</td>\n","    </tr>\n","    <tr>\n","        <td>2019-08</td>\n","        <td>14691</td>\n","        <td>1826</td>\n","        <td>11774</td>\n","    </tr>\n","    <tr>\n","        <td>2019-11</td>\n","        <td>28892</td>\n","        <td>4490</td>\n","        <td>22197</td>\n","    </tr>\n","    <tr>\n","        <td>2019-12</td>\n","        <td>47744</td>\n","        <td>6500</td>\n","        <td>38007</td>\n","    </tr>\n","    <tr>\n","        <td>2019-05</td>\n","        <td>4358</td>\n","        <td>763</td>\n","        <td>3139</td>\n","    </tr>\n","    <tr>\n","        <td>2019-06</td>\n","        <td>6487</td>\n","        <td>894</td>\n","        <td>5112</td>\n","    </tr>\n","    <tr>\n","        <td>2019-07</td>\n","        <td>9677</td>\n","        <td>1298</td>\n","        <td>7541</td>\n","    </tr>\n","    <tr>\n","        <td>2019-09</td>\n","        <td>18115</td>\n","        <td>4900</td>\n","        <td>11774</td>\n","    </tr>\n","    <tr>\n","        <td>2019-10</td>\n","        <td>22529</td>\n","        <td>4270</td>\n","        <td>16276</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":36}]},{"cell_type":"code","source":["%%sql\n","\n","SELECT TO_CHAR(CREATED_AT, 'YYYY-MM')  \"MONTH\"\n","     , COUNT(*) TOTAL_CNT\n","     , SUM(CASE WHEN SCORE >= 0 AND SCORE < 7\n","                THEN 1\n","                ELSE 0 END)         DETRACTOR_CNT\n","     , SUM(CASE WHEN SCORE >= 9\n","                THEN 1\n","                ELSE 0 END)         PROMOTER_CNT\n","  FROM RAW_DATA.NPS\n","GROUP BY 1;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":333},"id":"t6085jsaI-54","executionInfo":{"status":"ok","timestamp":1683797670989,"user_tz":-540,"elapsed":4542,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"a74fc4ee-7ba8-4f6c-91fd-93a8ef55805b"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","12 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[('2019-01', 127, 61, 64),\n"," ('2019-02', 632, 188, 381),\n"," ('2019-03', 1635, 316, 1181),\n"," ('2019-04', 2870, 532, 2053),\n"," ('2019-08', 14691, 1826, 11774),\n"," ('2019-11', 28892, 4490, 22197),\n"," ('2019-12', 47744, 6500, 38007),\n"," ('2019-05', 4358, 763, 3139),\n"," ('2019-06', 6487, 894, 5112),\n"," ('2019-07', 9677, 1298, 7541),\n"," ('2019-09', 18115, 4900, 11774),\n"," ('2019-10', 22529, 4270, 16276)]"],"text/html":["<table>\n","    <tr>\n","        <th>month</th>\n","        <th>total_cnt</th>\n","        <th>detractor_cnt</th>\n","        <th>promoter_cnt</th>\n","    </tr>\n","    <tr>\n","        <td>2019-01</td>\n","        <td>127</td>\n","        <td>61</td>\n","        <td>64</td>\n","    </tr>\n","    <tr>\n","        <td>2019-02</td>\n","        <td>632</td>\n","        <td>188</td>\n","        <td>381</td>\n","    </tr>\n","    <tr>\n","        <td>2019-03</td>\n","        <td>1635</td>\n","        <td>316</td>\n","        <td>1181</td>\n","    </tr>\n","    <tr>\n","        <td>2019-04</td>\n","        <td>2870</td>\n","        <td>532</td>\n","        <td>2053</td>\n","    </tr>\n","    <tr>\n","        <td>2019-08</td>\n","        <td>14691</td>\n","        <td>1826</td>\n","        <td>11774</td>\n","    </tr>\n","    <tr>\n","        <td>2019-11</td>\n","        <td>28892</td>\n","        <td>4490</td>\n","        <td>22197</td>\n","    </tr>\n","    <tr>\n","        <td>2019-12</td>\n","        <td>47744</td>\n","        <td>6500</td>\n","        <td>38007</td>\n","    </tr>\n","    <tr>\n","        <td>2019-05</td>\n","        <td>4358</td>\n","        <td>763</td>\n","        <td>3139</td>\n","    </tr>\n","    <tr>\n","        <td>2019-06</td>\n","        <td>6487</td>\n","        <td>894</td>\n","        <td>5112</td>\n","    </tr>\n","    <tr>\n","        <td>2019-07</td>\n","        <td>9677</td>\n","        <td>1298</td>\n","        <td>7541</td>\n","    </tr>\n","    <tr>\n","        <td>2019-09</td>\n","        <td>18115</td>\n","        <td>4900</td>\n","        <td>11774</td>\n","    </tr>\n","    <tr>\n","        <td>2019-10</td>\n","        <td>22529</td>\n","        <td>4270</td>\n","        <td>16276</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":37}]},{"cell_type":"markdown","source":["WITH 절을 사용해 내가 조회한 전체 수, DETRACTOR의 수, PROMOTER의 수를 이용해 각 비율을 구하고 최종적으로 월별 NPS 값을 계산해 보자."],"metadata":{"id":"lyoEvEGzJtPq"}},{"cell_type":"code","source":["%%sql\n","\n","WITH MAU \n","  AS (\n","          SELECT TO_CHAR(CREATED_AT, 'YYYY-MM')               \"MONTH\"\n","               , COUNT(*)                                     TOTAL_CNT\n","               , COUNT(CASE WHEN SCORE >= 0 AND SCORE < 7\n","                        THEN ID END)                          DETRACTOR_CNT\n","               , COUNT(CASE WHEN SCORE >= 9\n","                            THEN ID END)                      PROMOTER_CNT\n","           FROM RAW_DATA.NPS\n","          GROUP BY 1\n",")\n","SELECT MONTH\n","     , DETRACTOR_CNT::FLOAT/NULLIF(TOTAL_CNT, 0) * 100  DETRACTOR_PERCENT\n","     , PROMOTER_CNT::FLOAT/NULLIF(TOTAL_CNT, 0) * 100   PROMOTER_PERCENT\n","     , ROUND(PROMOTER_PERCENT - DETRACTOR_PERCENT, 2)   NPS\n","  FROM MAU \n","ORDER BY MONTH;"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":333},"id":"0uxAgIB7JLXR","executionInfo":{"status":"ok","timestamp":1683798721468,"user_tz":-540,"elapsed":4275,"user":{"displayName":"송지혜","userId":"10523689165883135045"}},"outputId":"46d7a590-5075-4042-f3d3-1f2797942035"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":[" * postgresql://guest:***@learnde.cduaw970ssvt.ap-northeast-2.redshift.amazonaws.com:5439/dev\n","12 rows affected.\n"]},{"output_type":"execute_result","data":{"text/plain":["[('2019-01', 48.0314960629921, 50.3937007874016, 2.36),\n"," ('2019-02', 29.746835443038, 60.2848101265823, 30.54),\n"," ('2019-03', 19.3272171253823, 72.2324159021407, 52.91),\n"," ('2019-04', 18.5365853658537, 71.5331010452962, 53.0),\n"," ('2019-05', 17.5080312069757, 72.0284534189995, 54.52),\n"," ('2019-06', 13.7814089717897, 78.8037613688916, 65.02),\n"," ('2019-07', 13.4132479074093, 77.9270435052186, 64.51),\n"," ('2019-08', 12.4293785310734, 80.1443060377102, 67.71),\n"," ('2019-09', 27.0494065691416, 64.9958597847088, 37.95),\n"," ('2019-10', 18.9533490168228, 72.2446624350837, 53.29),\n"," ('2019-11', 15.54063408556, 76.8274955004846, 61.29),\n"," ('2019-12', 13.6142761394102, 79.6058143431635, 65.99)]"],"text/html":["<table>\n","    <tr>\n","        <th>month</th>\n","        <th>detractor_percent</th>\n","        <th>promoter_percent</th>\n","        <th>nps</th>\n","    </tr>\n","    <tr>\n","        <td>2019-01</td>\n","        <td>48.0314960629921</td>\n","        <td>50.3937007874016</td>\n","        <td>2.36</td>\n","    </tr>\n","    <tr>\n","        <td>2019-02</td>\n","        <td>29.746835443038</td>\n","        <td>60.2848101265823</td>\n","        <td>30.54</td>\n","    </tr>\n","    <tr>\n","        <td>2019-03</td>\n","        <td>19.3272171253823</td>\n","        <td>72.2324159021407</td>\n","        <td>52.91</td>\n","    </tr>\n","    <tr>\n","        <td>2019-04</td>\n","        <td>18.5365853658537</td>\n","        <td>71.5331010452962</td>\n","        <td>53.0</td>\n","    </tr>\n","    <tr>\n","        <td>2019-05</td>\n","        <td>17.5080312069757</td>\n","        <td>72.0284534189995</td>\n","        <td>54.52</td>\n","    </tr>\n","    <tr>\n","        <td>2019-06</td>\n","        <td>13.7814089717897</td>\n","        <td>78.8037613688916</td>\n","        <td>65.02</td>\n","    </tr>\n","    <tr>\n","        <td>2019-07</td>\n","        <td>13.4132479074093</td>\n","        <td>77.9270435052186</td>\n","        <td>64.51</td>\n","    </tr>\n","    <tr>\n","        <td>2019-08</td>\n","        <td>12.4293785310734</td>\n","        <td>80.1443060377102</td>\n","        <td>67.71</td>\n","    </tr>\n","    <tr>\n","        <td>2019-09</td>\n","        <td>27.0494065691416</td>\n","        <td>64.9958597847088</td>\n","        <td>37.95</td>\n","    </tr>\n","    <tr>\n","        <td>2019-10</td>\n","        <td>18.9533490168228</td>\n","        <td>72.2446624350837</td>\n","        <td>53.29</td>\n","    </tr>\n","    <tr>\n","        <td>2019-11</td>\n","        <td>15.54063408556</td>\n","        <td>76.8274955004846</td>\n","        <td>61.29</td>\n","    </tr>\n","    <tr>\n","        <td>2019-12</td>\n","        <td>13.6142761394102</td>\n","        <td>79.6058143431635</td>\n","        <td>65.99</td>\n","    </tr>\n","</table>"]},"metadata":{},"execution_count":46}]},{"cell_type":"code","source":[],"metadata":{"id":"I3U4h5fjM1be"},"execution_count":null,"outputs":[]}]}