• 尚硅谷大数据项目《在线教育之离线数仓》笔记008

    视频地址：尚硅谷大数据项目《在线教育之离线数仓》_哔哩哔哩_bilibili

    目录

    P123

    P124

    P125

    P126

    P127

    P128

    P129

    P123

    Apache Superset是一个现代的数据探索和可视化平台。它功能强大且十分易用，可对接各种数据源，包括很多现代的大数据分析引擎，拥有丰富的图表展示形式，并且支持自定义仪表盘。

    1. [atguigu@node001 ~]$ python
    2. Python 2.7.5 (default, Apr 11 2018, 07:36:10) 
    3. [GCC 4.8.5 20150623 (Red Hat 4.8.5-28)] on linux2
    4. Type "help", "copyright", "credits" or "license" for more information.
    5. >>> quit
    6. Use quit() or Ctrl-D (i.e. EOF) to exit
    7. >>> quit()
    8. [atguigu@node001 ~]$ 
    1. # To activate this environment, use
    2. #
    3. #     $ conda activate superset
    4. #
    5. # To deactivate an active environment, use
    6. #
    7. #     $ conda deactivate
    8.  
    9. (base) [atguigu@node001 miniconda3]$ conda activate superset
    10. (superset) [atguigu@node001 miniconda3]$ python
    11. Python 3.8.16 (default, Jun 12 2023, 18:09:05) 
    12. [GCC 11.2.0] :: Anaconda, Inc. on linux
    13. Type "help", "copyright", "credits" or "license" for more information.
    14. >>> quit()
    15. (superset) [atguigu@node001 miniconda3]$ python -V
    16. Python 3.8.16
    17. (superset) [atguigu@node001 miniconda3]$

    P124

    2.2 Superset部署

    P125

    2.2.6 superset启停脚本

    1. #!/bin/bash
    2.  
    3. superset_status() {
    4.     result=`ps -ef | awk '/gunicorn/ && !/awk/{print $2}' | wc -l`
    5.     if [[ $result -eq 0 ]]; then
    6.         return 0
    7.     else
    8.         return 1
    9.     fi
    10. }
    11. superset_start() {
    12.         source ~/.bashrc
    13.         superset_status >/dev/null 2>&1
    14.         if [[ $? -eq 0 ]]; then
    15.             conda activate superset ; gunicorn --workers 5 --timeout 120 --bind node001:8787 --daemon 'superset.app:create_app()'
    16.         else
    17.             echo "superset正在运行..."
    18.         fi
    19. }
    20.  
    21. superset_stop() {
    22.     superset_status >/dev/null 2>&1
    23.     if [[ $? -eq 0 ]]; then
    24.         echo "superset未在运行..."
    25.     else
    26.         ps -ef | awk '/gunicorn/ && !/awk/{print $2}' | xargs kill -9
    27.     fi
    28. }
    29.  
    30.  
    31. case $1 in
    32.     start )
    33.         echo "启动Superset..."
    34.         superset_start
    35.     ;;
    36.     stop )
    37.         echo "停止Superset..."
    38.         superset_stop
    39.     ;;
    40.     restart )
    41.         echo "重启Superset..."
    42.         superset_stop
    43.         superset_start
    44.     ;;
    45.     status )
    46.         superset_status >/dev/null 2>&1
    47.         if [[ $? -eq 0 ]]; then
    48.             echo "superset未在运行..."
    49.         else
    50.             echo "superset正在运行..."
    51.         fi
    52. esac

    P126

    1. # `edu_report`数据库、`ads_trade_order_by_province`数据表
    2.  
    3. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '26', '广东', '5', '440000', 'CN-44', 'CN-GD', 11, 11, 2600.00);
    4. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '7', '江苏', '2', '320000', 'CN-32', 'CN-JS', 17, 14, 4800.00);
    5. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '17', '辽宁', '3', '210000', 'CN-21', 'CN-LN', 90, 71, 19600.00);
    6. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '9', '安徽', '2', '340000', 'CN-34', 'CN-AH', 77, 62, 17600.00);
    7. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '11', '江西', '2', '360000', 'CN-36', 'CN-JX', 97, 82, 20600.00);
    8. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '20', '青海', '7', '630000', 'CN-63', 'CN-QH', 110, 86, 24000.00);
    9. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '15', '黑龙江', '3', '230000', 'CN-23', 'CN-HL', 110, 90, 24800.00);
    10. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '18', '陕西', '7', '610000', 'CN-61', 'CN-SN', 12, 12, 2600.00);
    11. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '29', '香港', '5', '810000', 'CN-91', 'CN-HK', 96, 78, 20800.00);
    12. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '10', '福建', '2', '350000', 'CN-35', 'CN-FJ', 11, 11, 2200.00);
    13. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '33', '云南', '6', '530000', 'CN-53', 'CN-YN', 12, 11, 3200.00);
    14. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '21', '宁夏', '7', '640000', 'CN-64', 'CN-NX', 94, 75, 20800.00);
    15. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '1', '北京', '1', '110000', 'CN-11', 'CN-BJ', 93, 73, 19600.00);
    16. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '28', '海南', '5', '460000', 'CN-46', 'CN-HI', 93, 73, 22000.00);
    17. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '8', '浙江', '2', '330000', 'CN-33', 'CN-ZJ', 16, 15, 3800.00);
    18. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '34', '西藏', '6', '540000', 'CN-54', 'CN-XZ', 20, 20, 4800.00);
    19. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '22', '新疆', '7', '650000', 'CN-65', 'CN-XJ', 18, 18, 3600.00);
    20. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '8', '浙江', '2', '330000', 'CN-33', 'CN-ZJ', 86, 76, 19400.00);
    21. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '31', '四川', '6', '510000', 'CN-51', 'CN-SC', 95, 77, 22200.00);
    22. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '33', '云南', '6', '530000', 'CN-53', 'CN-YN', 90, 72, 19800.00);
    23. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '2', '天津', '1', '120000', 'CN-12', 'CN-TJ', 13, 12, 3000.00);
    24. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '8', '浙江', '2', '330000', 'CN-33', 'CN-ZJ', 86, 76, 19400.00);
    25. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '23', '河南', '4', '410000', 'CN-41', 'CN-HA', 104, 81, 23400.00);
    26. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '27', '广西', '5', '450000', 'CN-45', 'CN-GX', 16, 16, 3600.00);
    27. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '28', '海南', '5', '460000', 'CN-46', 'CN-HI', 93, 73, 22000.00);
    28. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '23', '河南', '4', '410000', 'CN-41', 'CN-HA', 104, 81, 23400.00);
    29. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '6', '上海', '2', '310000', 'CN-31', 'CN-SH', 92, 76, 20600.00);
    30. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '9', '安徽', '2', '340000', 'CN-34', 'CN-AH', 77, 62, 17600.00);
    31. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '4', '内蒙古', '1', '150000', 'CN-15', 'CN-NM', 96, 81, 21800.00);
    32. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '25', '湖南', '4', '430000', 'CN-43', 'CN-HN', 108, 83, 25400.00);
    33. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '15', '黑龙江', '3', '230000', 'CN-23', 'CN-HL', 110, 90, 24800.00);
    34. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '29', '香港', '5', '810000', 'CN-91', 'CN-HK', 19, 19, 4000.00);
    35. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '32', '贵州', '6', '520000', 'CN-52', 'CN-GZ', 108, 86, 25400.00);
    36. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '7', '江苏', '2', '320000', 'CN-32', 'CN-JS', 80, 67, 19400.00);
    37. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '32', '贵州', '6', '520000', 'CN-52', 'CN-GZ', 15, 15, 3800.00);
    38. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '12', '山东', '2', '370000', 'CN-37', 'CN-SD', 98, 76, 21200.00);
    39. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '24', '湖北', '4', '420000', 'CN-42', 'CN-HB', 97, 82, 24800.00);
    40. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '27', '广西', '5', '450000', 'CN-45', 'CN-GX', 93, 74, 21400.00);
    41. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '13', '重庆', '6', '500000', 'CN-50', 'CN-CQ', 17, 16, 3600.00);
    42. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '16', '吉林', '3', '220000', 'CN-22', 'CN-JL', 98, 79, 22200.00);
    43. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '22', '新疆', '7', '650000', 'CN-65', 'CN-XJ', 94, 74, 20000.00);
    44. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '19', '甘肃', '7', '620000', 'CN-62', 'CN-GS', 107, 82, 25000.00);
    45. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '30', '澳门', '5', '820000', 'CN-92', 'CN-MO', 94, 74, 20000.00);
    46. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '34', '西藏', '6', '540000', 'CN-54', 'CN-XZ', 106, 81, 24600.00);
    47. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '11', '江西', '2', '360000', 'CN-36', 'CN-JX', 14, 13, 3000.00);
    48. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '33', '云南', '6', '530000', 'CN-53', 'CN-YN', 90, 72, 19800.00);
    49. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '27', '广西', '5', '450000', 'CN-45', 'CN-GX', 93, 74, 21400.00);
    50. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '24', '湖北', '4', '420000', 'CN-42', 'CN-HB', 97, 82, 24800.00);
    51. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '24', '湖北', '4', '420000', 'CN-42', 'CN-HB', 21, 21, 5000.00);
    52. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '14', '台湾', '2', '710000', 'CN-71', 'CN-TW', 88, 76, 19600.00);
    53. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '7', '江苏', '2', '320000', 'CN-32', 'CN-JS', 80, 67, 19400.00);
    54. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '25', '湖南', '4', '430000', 'CN-43', 'CN-HN', 17, 17, 4400.00);
    55. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '6', '上海', '2', '310000', 'CN-31', 'CN-SH', 92, 76, 20600.00);
    56. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '2', '天津', '1', '120000', 'CN-12', 'CN-TJ', 80, 63, 17800.00);
    57. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '5', '河北', '1', '130000', 'CN-13', 'CN-HE', 101, 75, 23400.00);
    58. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '30', '澳门', '5', '820000', 'CN-92', 'CN-MO', 94, 74, 20000.00);
    59. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '23', '河南', '4', '410000', 'CN-41', 'CN-HA', 14, 13, 3000.00);
    60. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '14', '台湾', '2', '710000', 'CN-71', 'CN-TW', 14, 13, 3600.00);
    61. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '28', '海南', '5', '460000', 'CN-46', 'CN-HI', 10, 10, 2200.00);
    62. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '3', '山西', '1', '140000', 'CN-14', 'CN-SX', 14, 14, 3200.00);
    63. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '18', '陕西', '7', '610000', 'CN-61', 'CN-SN', 87, 73, 18400.00);
    64. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '20', '青海', '7', '630000', 'CN-63', 'CN-QH', 18, 18, 3800.00);
    65. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '16', '吉林', '3', '220000', 'CN-22', 'CN-JL', 10, 10, 2200.00);
    66. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '12', '山东', '2', '370000', 'CN-37', 'CN-SD', 98, 76, 21200.00);
    67. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '1', '北京', '1', '110000', 'CN-11', 'CN-BJ', 93, 73, 19600.00);
    68. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '10', '福建', '2', '350000', 'CN-35', 'CN-FJ', 90, 68, 21000.00);
    69. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '2', '天津', '1', '120000', 'CN-12', 'CN-TJ', 80, 63, 17800.00);
    70. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '6', '上海', '2', '310000', 'CN-31', 'CN-SH', 18, 17, 4400.00);
    71. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '34', '西藏', '6', '540000', 'CN-54', 'CN-XZ', 106, 81, 24600.00);
    72. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '3', '山西', '1', '140000', 'CN-14', 'CN-SX', 91, 77, 19800.00);
    73. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '19', '甘肃', '7', '620000', 'CN-62', 'CN-GS', 107, 82, 25000.00);
    74. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '16', '吉林', '3', '220000', 'CN-22', 'CN-JL', 98, 79, 22200.00);
    75. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '32', '贵州', '6', '520000', 'CN-52', 'CN-GZ', 108, 86, 25400.00);
    76. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '25', '湖南', '4', '430000', 'CN-43', 'CN-HN', 108, 83, 25400.00);
    77. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '26', '广东', '5', '440000', 'CN-44', 'CN-GD', 95, 79, 20200.00);
    78. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '30', '澳门', '5', '820000', 'CN-92', 'CN-MO', 19, 19, 4000.00);
    79. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '5', '河北', '1', '130000', 'CN-13', 'CN-HE', 15, 14, 3400.00);
    80. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '3', '山西', '1', '140000', 'CN-14', 'CN-SX', 91, 77, 19800.00);
    81. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '11', '江西', '2', '360000', 'CN-36', 'CN-JX', 97, 82, 20600.00);
    82. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '19', '甘肃', '7', '620000', 'CN-62', 'CN-GS', 19, 19, 4000.00);
    83. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '22', '新疆', '7', '650000', 'CN-65', 'CN-XJ', 94, 74, 20000.00);
    84. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '17', '辽宁', '3', '210000', 'CN-21', 'CN-LN', 10, 10, 2000.00);
    85. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '13', '重庆', '6', '500000', 'CN-50', 'CN-CQ', 85, 72, 18600.00);
    86. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '18', '陕西', '7', '610000', 'CN-61', 'CN-SN', 87, 73, 18400.00);
    87. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '31', '四川', '6', '510000', 'CN-51', 'CN-SC', 95, 77, 22200.00);
    88. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '21', '宁夏', '7', '640000', 'CN-64', 'CN-NX', 10, 9, 2200.00);
    89. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '12', '山东', '2', '370000', 'CN-37', 'CN-SD', 20, 20, 4600.00);
    90. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '29', '香港', '5', '810000', 'CN-91', 'CN-HK', 96, 78, 20800.00);
    91. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '9', '安徽', '2', '340000', 'CN-34', 'CN-AH', 10, 10, 2000.00);
    92. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '14', '台湾', '2', '710000', 'CN-71', 'CN-TW', 88, 76, 19600.00);
    93. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '31', '四川', '6', '510000', 'CN-51', 'CN-SC', 16, 15, 3600.00);
    94. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '1', '北京', '1', '110000', 'CN-11', 'CN-BJ', 20, 19, 4000.00);
    95. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '21', '宁夏', '7', '640000', 'CN-64', 'CN-NX', 94, 75, 20800.00);
    96. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '4', '内蒙古', '1', '150000', 'CN-15', 'CN-NM', 16, 15, 3800.00);
    97. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '20', '青海', '7', '630000', 'CN-63', 'CN-QH', 110, 86, 24000.00);
    98. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '10', '福建', '2', '350000', 'CN-35', 'CN-FJ', 90, 68, 21000.00);
    99. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '26', '广东', '5', '440000', 'CN-44', 'CN-GD', 95, 79, 20200.00);
    100. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '17', '辽宁', '3', '210000', 'CN-21', 'CN-LN', 90, 71, 19600.00);
    101. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '5', '河北', '1', '130000', 'CN-13', 'CN-HE', 101, 75, 23400.00);
    102. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 30, '13', '重庆', '6', '500000', 'CN-50', 'CN-CQ', 85, 72, 18600.00);
    103. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 7, '4', '内蒙古', '1', '150000', 'CN-15', 'CN-NM', 96, 81, 21800.00);
    104. INSERT INTO ads_trade_order_by_province (dt, recent_days, province_id, province_name, region_id, area_code, iso_code, iso_code_3166_2, order_count, order_user_count, order_total_amount) VALUES ('2022-02-21', 1, '15', '黑龙江', '3', '230000', 'CN-23', 'CN-HL', 16, 16, 3200.00);

    P127

    1. # `edu_report`数据库、`ads_traffic_page_path`数据表
    2.  
    3. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-5:order', 'step-6:payment', 134);
    4. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-4:course_detail', 'step-5:course_list', 124);
    5. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-4:course_detail', 'step-5:course_list', 124);
    6. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-4:chapter_video', 'step-5:chapter_video', 238);
    7. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-4:course_detail', 'null', 5);
    8. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-5:order', 'step-6:payment', 134);
    9. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-5:cart', 'step-6:order', 137);
    10. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-5:cart', 'step-6:order', 137);
    11. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-6:order', 'step-7:payment', 137);
    12. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-2:mine', 'null', 1);
    13. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-7:payment', 'null', 137);
    14. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-4:course_detail', 'step-5:cart', 141);
    15. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-4:exam', 'null', 224);
    16. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-3:course_list', 'step-4:course_detail', 531);
    17. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-1:exam', 'null', 5);
    18. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-5:order', 'null', 127);
    19. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-6:course_detail', 'step-7:order', 121);
    20. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-6:course_detail', 'null', 3);
    21. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-1:chapter_video', 'step-2:chapter_video', 2);
    22. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-5:order', 'null', 127);
    23. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-4:course_detail', 'step-5:order', 261);
    24. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, NULL, 'null', 3640);
    25. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, NULL, 'step-2:home', 531);
    26. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-7:order', 'null', 121);
    27. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-5:course_list', 'step-6:course_detail', 124);
    28. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-2:home', 'step-3:course_list', 531);
    29. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-5:cart', 'null', 4);
    30. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-5:order', 'null', 127);
    31. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-5:chapter_video', 'null', 238);
    32. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-6:course_detail', 'step-7:order', 121);
    33. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-6:payment', 'null', 134);
    34. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, NULL, 'step-2:home', 531);
    35. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-4:chapter_video', 'step-5:chapter_video', 238);
    36. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-6:payment', 'null', 134);
    37. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-1:chapter_video', 'step-2:chapter_video', 2);
    38. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-2:mine', 'null', 1);
    39. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-3:course_detail', 'step-4:chapter_video', 238);
    40. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-2:chapter_video', 'null', 2);
    41. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-2:chapter_video', 'null', 2);
    42. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-4:chapter_video', 'step-5:chapter_video', 238);
    43. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-5:chapter_video', 'null', 238);
    44. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-2:home', 'step-3:course_list', 531);
    45. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-5:chapter_video', 'null', 238);
    46. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-4:course_detail', 'null', 5);
    47. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-7:payment', 'null', 137);
    48. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, NULL, 'null', 3640);
    49. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-3:course_detail', 'step-4:chapter_video', 238);
    50. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-7:order', 'null', 121);
    51. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-3:course_detail', 'null', 6);
    52. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, NULL, 'null', 3640);
    53. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, NULL, 'step-2:mine', 469);
    54. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-6:course_detail', 'null', 3);
    55. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-5:cart', 'step-6:order', 137);
    56. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-3:course_detail', 'null', 6);
    57. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-2:mine', 'step-3:course_detail', 468);
    58. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-4:exam', 'null', 224);
    59. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-5:cart', 'null', 4);
    60. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-6:order', 'step-7:payment', 137);
    61. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-1:exam', 'null', 5);
    62. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-7:payment', 'null', 137);
    63. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-4:course_detail', 'step-5:order', 261);
    64. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-3:course_detail', 'step-4:exam', 224);
    65. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, NULL, 'step-2:mine', 469);
    66. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-2:home', 'step-3:course_list', 531);
    67. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-6:order', 'step-7:payment', 137);
    68. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-4:course_detail', 'step-5:cart', 141);
    69. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-6:course_detail', 'step-7:order', 121);
    70. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, NULL, 'step-2:home', 531);
    71. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-5:course_list', 'step-6:course_detail', 124);
    72. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-7:order', 'null', 121);
    73. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, NULL, 'step-2:mine', 469);
    74. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-4:course_detail', 'step-5:course_list', 124);
    75. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-3:course_detail', 'step-4:exam', 224);
    76. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-6:payment', 'null', 134);
    77. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-5:order', 'step-6:payment', 134);
    78. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-1:exam', 'null', 5);
    79. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-1:chapter_video', 'step-2:chapter_video', 2);
    80. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-3:course_list', 'step-4:course_detail', 531);
    81. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-3:course_detail', 'null', 6);
    82. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-2:chapter_video', 'null', 2);
    83. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-6:course_detail', 'null', 3);
    84. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-3:course_list', 'step-4:course_detail', 531);
    85. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-2:mine', 'null', 1);
    86. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-5:course_list', 'step-6:course_detail', 124);
    87. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-3:course_detail', 'step-4:exam', 224);
    88. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-5:cart', 'null', 4);
    89. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-2:mine', 'step-3:course_detail', 468);
    90. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-4:course_detail', 'step-5:order', 261);
    91. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-4:course_detail', 'step-5:cart', 141);
    92. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-2:mine', 'step-3:course_detail', 468);
    93. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-4:exam', 'null', 224);
    94. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-4:course_detail', 'null', 5);
    95. INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-3:course_detail', 'step-4:chapter_video', 238);

    P128

    1. # `edu_report`数据库、`ads_trade_stats`数据表
    2.  
    3. INSERT INTO ads_trade_stats (dt, recent_days, order_total_amount, order_count, order_user_count) VALUES ('2022-02-21', 1, 117200.00, 518, 248);
    4. INSERT INTO ads_trade_stats (dt, recent_days, order_total_amount, order_count, order_user_count) VALUES ('2022-02-21', 30, 725200.00, 3223, 299);
    5. INSERT INTO ads_trade_stats (dt, recent_days, order_total_amount, order_count, order_user_count) VALUES ('2022-02-21', 7, 725200.00, 3223, 299);

    P129

    尚硅谷大数据项目之在线教育离线数仓（3在线教育数据仓库系统）V1.0.docx

  • 相关阅读:
    redis set zset key 常用命令
    Go结构体深度探索：从基础到应用
    含冰蓄冷空调的冷热电联供型微网多时间尺度优化调度
    手把手带你搭建第一个SpringCloud项目（二）
    Spring Mvc的相关知识
    数字IC设计全流程
    如何在long-running task中调用async方法
    sudo 问题 不是 sudoers --chatGPT
    [附源码]java毕业设计高校贫困生认定系统
    计算机毕业设计JavaH5醉美南湾湖网站设计(源码+系统+mysql数据库+lw文档）
  • 原文地址：https://blog.csdn.net/weixin_44949135/article/details/132744560