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

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

目录

P123

P124

P125

P126

P127

P128

P129


P123

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

[atguigu@node001 ~]$ python
Python 2.7.5 (default, Apr 11 2018, 07:36:10) 
[GCC 4.8.5 20150623 (Red Hat 4.8.5-28)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> quit
Use quit() or Ctrl-D (i.e. EOF) to exit
>>> quit()
[atguigu@node001 ~]$ 
# To activate this environment, use
#
#     $ conda activate superset
#
# To deactivate an active environment, use
#
#     $ conda deactivate

(base) [atguigu@node001 miniconda3]$ conda activate superset
(superset) [atguigu@node001 miniconda3]$ python
Python 3.8.16 (default, Jun 12 2023, 18:09:05) 
[GCC 11.2.0] :: Anaconda, Inc. on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> quit()
(superset) [atguigu@node001 miniconda3]$ python -V
Python 3.8.16
(superset) [atguigu@node001 miniconda3]$ 

P124

2.2 Superset部署

P125

2.2.6 superset启停脚本

#!/bin/bash

superset_status() {
    result=`ps -ef | awk '/gunicorn/ && !/awk/{print $2}' | wc -l`
    if [[ $result -eq 0 ]]; then
        return 0
    else
        return 1
    fi
}
superset_start() {
        source ~/.bashrc
        superset_status >/dev/null 2>&1
        if [[ $? -eq 0 ]]; then
            conda activate superset ; gunicorn --workers 5 --timeout 120 --bind node001:8787 --daemon 'superset.app:create_app()'
        else
            echo "superset正在运行..."
        fi
}

superset_stop() {
    superset_status >/dev/null 2>&1
    if [[ $? -eq 0 ]]; then
        echo "superset未在运行..."
    else
        ps -ef | awk '/gunicorn/ && !/awk/{print $2}' | xargs kill -9
    fi
}


case $1 in
    start )
        echo "启动Superset..."
        superset_start
    ;;
    stop )
        echo "停止Superset..."
        superset_stop
    ;;
    restart )
        echo "重启Superset..."
        superset_stop
        superset_start
    ;;
    status )
        superset_status >/dev/null 2>&1
        if [[ $? -eq 0 ]]; then
            echo "superset未在运行..."
        else
            echo "superset正在运行..."
        fi
esac

P126

# `edu_report`数据库、`ads_trade_order_by_province`数据表

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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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

# `edu_report`数据库、`ads_traffic_page_path`数据表

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);
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);
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);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-4:course_detail', 'null', 5);
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);
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);
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);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-2:mine', 'null', 1);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-7:payment', 'null', 137);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-4:exam', 'null', 224);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-1:exam', 'null', 5);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-5:order', 'null', 127);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-6:course_detail', 'null', 3);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-5:order', 'null', 127);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, NULL, 'null', 3640);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, NULL, 'step-2:home', 531);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-7:order', 'null', 121);
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);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-5:cart', 'null', 4);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-5:order', 'null', 127);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-5:chapter_video', 'null', 238);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-6:payment', 'null', 134);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, NULL, 'step-2:home', 531);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-6:payment', 'null', 134);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-2:mine', 'null', 1);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-2:chapter_video', 'null', 2);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-2:chapter_video', 'null', 2);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-5:chapter_video', 'null', 238);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-5:chapter_video', 'null', 238);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-4:course_detail', 'null', 5);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-7:payment', 'null', 137);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, NULL, 'null', 3640);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-7:order', 'null', 121);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-3:course_detail', 'null', 6);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, NULL, 'null', 3640);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, NULL, 'step-2:mine', 469);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-6:course_detail', 'null', 3);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-3:course_detail', 'null', 6);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-4:exam', 'null', 224);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-5:cart', 'null', 4);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-1:exam', 'null', 5);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-7:payment', 'null', 137);
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);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, NULL, 'step-2:mine', 469);
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);
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);
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);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, NULL, 'step-2:home', 531);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-7:order', 'null', 121);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, NULL, 'step-2:mine', 469);
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);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-6:payment', 'null', 134);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-1:exam', 'null', 5);
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);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-3:course_detail', 'null', 6);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-2:chapter_video', 'null', 2);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-6:course_detail', 'null', 3);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-2:mine', 'null', 1);
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);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 1, 'step-5:cart', 'null', 4);
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);
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);
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);
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);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 30, 'step-4:exam', 'null', 224);
INSERT INTO ads_traffic_page_path (dt, recent_days, source, target, path_count) VALUES ('2022-02-21', 7, 'step-4:course_detail', 'null', 5);
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

# `edu_report`数据库、`ads_trade_stats`数据表

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);
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);
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