-
Notifications
You must be signed in to change notification settings - Fork 0
/
finnal(1).sql
130 lines (84 loc) · 30.7 KB
/
finnal(1).sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.5.20 : Database - sleep
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`sleep` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `sleep`;
/*Table structure for table `demo1` */
DROP TABLE IF EXISTS `demo1`;
CREATE TABLE `demo1` (
`name` varchar(255) DEFAULT NULL,
`value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `demo1` */
insert into `demo1`(`name`,`value`) values ('84',389),('77',440),('84',384),('84',370),('84',360),('84',353),('84',345),('84',343),('84',336),('84',330),('84',312),('84',305),('84',302),('84',301),('85',311),('85',302),('85',328),('85',347),('85',370),('85',384),('85',395),('85',413),('85',415),('85',416),('85',428),('85',429),('85',324),('85',440),('85',441),('85',444),('85',447),('85',450),('85',451),('85',453),('85',481),('85',482),('85',484),('85',486),('85',491),('85',493),('85',501),('85',510),('85',518),('85',524),('85',537),('85',555),('85',558),('85',596),('85',307),('85',322),('85',320),('86',355),('86',387),('86',335),('86',388),('86',391),('86',398),('86',407),('86',417),('86',424),('86',425),('86',428),('86',438),('86',439),('86',448),('86',463),('86',349),('86',492),('86',493),('86',505),('86',510),('86',312),('86',538),('86',546),('86',550),('86',557),('86',559),('86',575),('87',458),('87',312),('87',320),('87',323),('87',334),('87',346),('87',348),('87',355),('87',375),('87',376),('87',379),('87',380),('87',432),('87',434),('87',437),('87',447),('87',468),('87',478),('87',483),('87',488),('87',501),('87',505),('87',532),('77',444),('77',453),('77',483),('77',488),('77',493),('77',497),('77',515),('77',516),('77',521),('77',524),('77',544),('77',548),('77',549),('77',579),('77',582),('77',583),('77',588),('77',589),('77',591),('78',303),('78',308),('78',309),('78',321),('78',334),('70',346),('78',363),('78',372),('78',394),('78',397),('78',401),('78',403),('78',420),('78',424),('78',428),('78',460),('78',463),('78',465),('78',301),('78',466),('78',467),('78',482),('78',486),('78',488),('78',491),('78',508),('78',518),('78',524),('78',542),('78',550),('78',554),('78',588),('78',600),('79',503),('79',302),('79',322),('79',334),('79',378),('79',388),('79',422),('79',427),('79',439),('79',440),('79',445),('79',448),('79',454),('79',459),('79',472),('79',481),('79',483),('79',485),('79',505),('79',524),('79',531),('79',534),('79',540),('79',551),('79',565),('79',566),('79',568),('79',569),('79',583),('79',590),('79',600),('80',305),('80',308),('80',312),('80',317),('80',326),('80',330),('80',332),('80',343),('80',344),('80',345),('80',349),('80',353),('80',362),('80',368),('80',370),('80',371),('80',392),('92',377),('87',533),('92',383),('92',407),('92',411),('92',412),('92',417),('92',418),('92',420),('92',421),('92',434),('92',454),('92',465),('92',466),('92',476),('92',515),('92',523),('92',526),('92',585),('92',586),('92',588),('93',310),('93',311),('93',321),('93',323),('93',324),('93',352),('93',353),('93',362),('93',372),('93',388),('93',400),('93',306),('93',401),('93',403),('93',410),('93',416),('93',425),('93',431),('93',452),('93',464),('93',470),('93',474),('93',475),('93',484),('93',503),('93',512),('93',536),('93',537),('93',546),('93',551),('93',564),('93',584),('93',589),('93',597),('93',599),('94',450),('94',303),('94',312),('94',336),('94',368),('94',392),('94',399),('94',402),('94',404),('94',424),('94',429),('94',433),('94',466),('94',493),('94',501),('94',511),('94',514),('94',516),('94',535),('94',543),('94',544),('94',545),('94',556),('94',565),('94',569),('94',571),('94',575),('94',587),('94',600),('95',306),('95',307),('95',309),('95',316),('95',317),('95',322),('95',324),('95',326),('95',369),('95',372),('95',380),('95',392),('95',393),('95',416),('95',419),('95',422),('87',552),('87',556),('87',563),('87',572),('87',585),('87',598),('88',303),('88',315),('88',318),('88',331),('88',336),('88',352),('88',353),('88',357),('88',363),('88',366),('88',382),('88',397),('88',399),('88',412),('88',417),('88',418),('88',423),('88',433),('88',442),('88',444),('88',483),('88',531),('88',535),('88',549),('88',554),('88',563),('88',587),('88',599),('89',315),('89',300),('89',308),('89',312),('89',319),('89',338),('89',349),('89',353),('89',370),('89',377),('89',379),('89',383),('89',392),('89',431),('89',463),('89',472),('89',482),('89',487),('89',504),('89',508),('89',509),('89',512),('89',517),('89',548),('89',562),('89',564),('89',584),('90',313),('90',323),('90',334),('90',347),('90',348),('90',376),('90',308),('90',385),('90',407),('90',415),('90',448),('90',451),('90',467),('90',476),('90',479),('90',481),('90',487),('90',488),('90',527),('90',546),('90',548),('90',552),('90',558),('90',563),('90',580),('90',584),('91',396),('91',333),('91',337),('91',347),('91',359),('91',372),('91',378),('91',397),('91',408),('91',409),('91',416),('91',418),('70',312),('70',353),('70',362),('70',372),('70',374),('70',376),('70',377),('70',381),('70',418),('70',435),('70',451),('70',460),('70',468),('70',481),('70',321),('70',335),('70',483),('70',492),('70',494),('70',498),('70',514),('70',515),('70',526),('70',528),('70',529),('70',539),('70',548),('70',568),('70',570),('70',598),('71',477),('71',303),('71',320),('71',323),('71',324),('71',344),('71',352),('71',354),('71',361),('71',362),('71',372),('71',373),('71',378),('71',452),('71',456),('71',457),('71',460),('71',480),('71',501),('71',505),('71',509),('71',514),('71',546),('71',559),('71',565),('71',574),('71',582),('72',316),('72',317),('72',322),('72',334),('72',335),('72',353),('72',365),('72',373),('72',379),('72',382),('72',383),('80',397),('72',386),('72',389),('72',397),('72',403),('72',412),('72',443),('72',463),('72',464),('72',482),('72',488),('72',497),('72',505),('72',519),('72',523),('72',529),('72',531),('72',534),('72',536),('72',543),('72',555),('72',566),('72',567),('72',568),('72',585),('72',595),('72',596),('73',497),('73',302),('73',337),('73',350),('73',369),('80',403),('80',442),('80',458),('80',462),('80',471),('80',472),('80',478),('80',479),('80',486),('80',497),('80',498),('80',526),('80',546),('80',562),('80',585),('80',590),('80',592),('81',305),('81',308),('81',316),('81',326),('81',352),('81',374),('81',388),('81',396),('81',399),('81',403),('81',406),('81',419),('81',431),('81',441),('81',444),('81',464),('81',472),('81',480),('81',481),('81',482),('81',500),('81',505),('81',511),('81',520),('81',542),('81',556),('81',575),('81',576),('81',586),('81',587),('81',590),('81',596),('82',309),('82',315),('82',319),('82',320),('82',349),('82',359),('82',361),('82',371),('82',390),('82',391),('82',404),('82',420),('82',430),('82',443),('82',450),('82',456),('82',463),('82',470),('82',473),('82',478),('82',485),('82',496),('82',498),('82',509),('82',513),('82',519),('82',523),('82',535),('82',542),('82',544),('82',557),('82',563),('82',564),('82',575),('82',582),('82',592),('83',332),('83',336),('83',341),('83',343),('83',403),('83',405),('83',408),('83',409),('83',422),('83',425),('83',427),('83',430),('83',437),('83',438),('91',420),('91',424),('91',427),('91',444),('91',447),('91',451),('91',459),('91',469),('91',476),('91',485),('91',502),('91',504),('91',507),('91',510),('91',514),('91',526),('91',535),('91',542),('91',555),('91',556),('91',559),('91',572),('91',574),('91',577),('91',593),('91',599),('92',460),('92',300),('92',306),('92',314),('92',325),('92',347),('92',355),('92',359),('92',371),('92',376),('95',444),('95',445),('95',448),('95',460),('95',512),('95',514),('95',519),('95',520),('95',523),('95',561),('95',562),('95',568),('95',586),('96',309),('96',313),('96',317),('96',322),('96',327),('96',339),('96',340),('96',359),('96',372),('96',384),('96',408),('96',409),('96',410),('96',415),('96',420),('96',440),('96',441),('96',444),('96',455),('96',465),('96',486),('96',502),('96',509),('96',514),('96',525),('96',529),('96',547),('96',549),('96',568),('96',572),('96',588),('96',597),('96',600),('97',301),('97',323),('97',338),('97',349),('97',351),('97',357),('97',358),('97',363),('97',369),('97',376),('97',388),('97',389),('97',430),('97',434),('97',439),('97',458),('97',468),('97',477),('97',495),('97',497),('97',514),('73',372),('83',443),('97',522),('97',524),('97',533),('97',534),('97',549),('97',550),('97',555),('97',556),('97',588),('97',592),('98',580),('98',585),('98',586),('98',310),('98',312),('98',314),('98',315),('98',350),('98',366),('98',381),('98',385),('98',404),('98',420),('98',427),('98',431),('98',434),('98',462),('98',473),('98',491),('98',501),('98',506),('98',532),('98',538),('73',379),('73',401),('73',405),('73',415),('73',422),('73',432),('73',439),('73',443),('73',445),('73',449),('73',485),('73',498),('73',507),('73',516),('73',519),('73',524),('73',535),('73',550),('73',556),('73',566),('73',576),('73',578),('73',598),('73',599),('74',308),('74',328),('74',346),('74',367),('74',368),('74',376),('74',388),('74',398),('74',408),('74',413),('74',416),('74',425),('74',434),('74',435),('74',444),('74',453),('74',301),('74',465),('74',468),('74',472),('74',476),('74',480),('74',494),('74',496),('74',517),('74',519),('74',523),('74',552),('74',555),('74',576),('74',584),('74',586),('74',591),('75',518),('75',307),('75',311),('75',321),('75',360),('75',384),('75',388),('75',397),('75',400),('75',404),('75',407),('75',416),('75',420),('75',442),('75',463),('75',470),('75',487),('75',554),('75',571),('75',583),('75',585),('76',310),('76',323),('76',327),('76',342),('76',355),('76',360),('76',364),('76',375),('76',384),('76',396),('76',397),('76',398),('76',405),('76',416),('76',417),('76',420),('76',425),('76',429),('76',432),('76',439),('76',442),('83',447),('83',449),('83',468),('83',473),('83',489),('83',490),('83',491),('83',496),('83',507),('83',514),('83',516),('83',522),('83',524),('83',551),('83',561),('84',451),('84',595),('84',592),('84',591),('84',573),('84',562),('84',561),('84',544),('84',518),('84',515),('84',498),('84',493),('84',492),('84',460),('84',449),('84',440),('84',407),('84',401),('84',399),('84',395),('98',541),('98',546),('98',587),('98',590),('98',593),('98',548),('98',550),('99',523),('99',538),('99',544),('99',553),('99',569),('99',591),('99',303),('99',329),('99',338),('99',343),('99',348),('99',356),('99',368),('99',375),('99',390),('99',413),('99',430),('99',436),('99',443),('99',463),('99',466),('99',468),('99',469),('99',470),('99',477),('99',480),('99',481),('99',500),('99',512),('76',448),('76',454),('76',455),('76',465),('76',471),('76',481),('76',483),('76',486),('76',487),('76',490),('76',493),('76',503),('76',510),('76',516),('76',532),('76',543),('76',552),('76',557),('76',567),('76',568),('76',574),('76',578),('76',589),('77',321),('77',301),('77',308),('77',315),('77',325),('77',334),('77',344),('77',375),('77',394),('77',398),('77',407),('77',412),('77',417),('77',437);
/*Table structure for table `demo2` */
DROP TABLE IF EXISTS `demo2`;
CREATE TABLE `demo2` (
`name` varchar(255) DEFAULT NULL,
`value` float DEFAULT NULL,
`value1` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `demo2` */
insert into `demo2`(`name`,`value`,`value1`) values ('77',0.1,0.27),('70',0.02,0.15),('77',0.11,0.07),('77',0.11,0.13),('77',0.14,0),('77',0.14,0.19),('77',0.15,0.03),('77',0.16,0),('77',0.16,0.13),('77',0.2,0.3),('77',0.21,0.1),('77',0.22,0.02),('77',0.22,0.2),('77',0.24,0.04),('77',0.24,0.09),('77',0.25,0.11),('77',0.26,0.01),('77',0.26,0.08),('77',0.26,0.11),('77',0.27,0.02),('77',0.27,0.11),('77',0.27,0.18),('77',0.28,0.24),('77',0.3,0),('78',0.02,0.11),('78',0.04,0.26),('78',0.05,0.07),('78',0.06,0.01),('78',0.06,0.12),('78',0.07,0.09),('78',0.09,0.06),('78',0.09,0.17),('78',0.11,0.01),('78',0.11,0.02),('78',0.11,0.14),('78',0.13,0.3),('78',0.15,0.01),('78',0.15,0.02),('78',0.15,0.07),('78',0.15,0.29),('78',0.17,0.19),('78',0.18,0.28),('78',0.03,0.2),('78',0.19,0.28),('78',0.21,0.22),('78',0.23,0.03),('78',0.23,0.23),('78',0.23,0.24),('78',0.25,0),('78',0.26,0.22),('78',0.27,0.18),('78',0.28,0.23),('78',0.29,0.15),('78',0.29,0.28),('78',0.3,0.1),('78',0.3,0.16),('79',0.15,0.26),('79',0,0.27),('79',0.02,0.04),('79',0.03,0.07),('79',0.04,0.07),('79',0.07,0.28),('79',0.08,0.22),('79',0.09,0.09),('79',0.09,0.17),('79',0.1,0.06),('79',0.1,0.24),('79',0.11,0.16),('79',0.12,0.06),('79',0.12,0.23),('79',0.13,0.01),('79',0.14,0.13),('79',0.14,0.22),('79',0.15,0.06),('79',0.15,0.17),('79',0.2,0.14),('79',0.21,0.04),('79',0.21,0.12),('79',0.21,0.15),('79',0.21,0.16),('79',0.22,0.22),('79',0.24,0.07),('79',0.24,0.21),('79',0.25,0.09),('79',0.26,0.21),('79',0.28,0.16),('79',0.29,0.3),('80',0.01,0.22),('80',0.02,0.13),('80',0.02,0.2),('80',0.03,0.3),('80',0.05,0.13),('80',0.06,0.04),('80',0.06,0.17),('80',0.06,0.19),('80',0.08,0.03),('80',0.08,0.25),('80',0.09,0.07),('80',0.09,0.19),('80',0.09,0.2),('80',0.12,0.04),('70',0,0.04),('70',0.03,0.04),('70',0.04,0.29),('70',0.05,0.08),('70',0.05,0.15),('70',0.11,0.02),('70',0.12,0.07),('70',0.13,0.11),('70',0.13,0.22),('70',0.13,0.3),('70',0.14,0.09),('70',0.14,0.26),('70',0.15,0.15),('70',0.15,0.29),('70',0.16,0.15),('70',0.02,0.14),('70',0.16,0.16),('70',0.16,0.21),('70',0.18,0.05),('70',0.18,0.17),('70',0.01,0.17),('70',0.18,0.28),('70',0.22,0.02),('70',0.22,0.21),('70',0.23,0.12),('70',0.25,0.09),('70',0.28,0.22),('70',0.3,0.07),('70',0.3,0.1),('70',0.3,0.28),('71',0.19,0.08),('71',0,0.3),('71',0.02,0.09),('71',0.03,0.09),('71',0.05,0.24),('71',0.06,0.17),('71',0.09,0.09),('71',0.1,0.04),('71',0.1,0.1),('71',0.12,0.18),('71',0.12,0.25),('71',0.13,0.18),('71',0.13,0.22),('71',0.15,0.07),('71',0.15,0.27),('71',0.17,0.22),('71',0.19,0.05),('71',0.19,0.23),('71',0.22,0),('71',0.24,0.15),('71',0.24,0.19),('71',0.25,0.04),('71',0.26,0.07),('71',0.26,0.22),('71',0.28,0.28),('71',0.29,0),('71',0.3,0.25),('72',0,0.03),('72',0,0.29),('72',0.01,0.08),('72',0.02,0.05),('72',0.03,0.02),('72',0.04,0.11),('72',0.04,0.21),('72',0.04,0.28),('72',0.06,0.1),('72',0.06,0.29),('72',0.07,0.04),('72',0.07,0.11),('72',0.09,0.18),('72',0.1,0.03),('72',0.1,0.27),('72',0.12,0.14),('72',0.12,0.29),('72',0.16,0.28),('72',0.17,0.21),('72',0.18,0.25),('72',0.19,0.05),('72',0.2,0.15),('72',0.2,0.2),('72',0.2,0.28),('72',0.2,0.29),('72',0.21,0.2),('72',0.21,0.22),('72',0.21,0.29),('72',0.23,0.21),('72',0.25,0.27),('72',0.26,0.25),('72',0.26,0.29),('72',0.28,0.13),('72',0.28,0.15),('72',0.29,0.13),('72',0.29,0.22),('72',0.3,0.12),('73',0.21,0.09),('73',0,0.07),('73',0.03,0.05),('73',0.03,0.24),('73',0.03,0.27),('80',0.12,0.12),('80',0.12,0.28),('80',0.13,0.06),('80',0.14,0.28),('80',0.16,0.13),('80',0.17,0.06),('80',0.17,0.28),('80',0.17,0.29),('80',0.19,0),('80',0.2,0.07),('80',0.2,0.14),('80',0.21,0.14),('80',0.23,0.27),('80',0.24,0.02),('80',0.24,0.22),('80',0.25,0.08),('80',0.26,0.11),('80',0.26,0.21),('80',0.27,0.14),('80',0.29,0.03),('80',0.29,0.14),('80',0.29,0.15),('80',0.3,0.16),('81',0.01,0.08),('81',0,0.12),('81',0.02,0.22),('81',0.03,0.16),('81',0.03,0.23),('81',0.04,0.09),('81',0.05,0.11),('81',0.08,0.24),('81',0.09,0.1),('81',0.1,0.3),('81',0.11,0.25),('81',0.12,0.1),('81',0.13,0.18),('81',0.14,0.23),('81',0.15,0),('81',0.15,0.1),('81',0.15,0.13),('81',0.17,0.03),('81',0.18,0.19),('81',0.19,0.13),('81',0.19,0.15),('81',0.19,0.26),('81',0.2,0),('81',0.22,0.24),('81',0.24,0.05),('81',0.24,0.24),('81',0.25,0.08),('81',0.25,0.17),('81',0.26,0.3),('81',0.27,0.11),('81',0.27,0.22),('81',0.29,0.26),('81',0.3,0.28),('82',0,0),('82',0.01,0.09),('82',0.03,0.05),('82',0.04,0.12),('82',0.04,0.23),('82',0.05,0.22),('82',0.07,0.14),('82',0.08,0.23),('82',0.08,0.27),('82',0.08,0.29),('82',0.09,0.3),('82',0.11,0.03),('82',0.12,0.18),('82',0.13,0.04),('82',0.14,0.28),('82',0.15,0.04),('82',0.15,0.18),('82',0.15,0.19),('82',0.15,0.23),('82',0.16,0.19),('82',0.17,0.14),('82',0.2,0.29),('82',0.21,0.01),('82',0.21,0.19),('82',0.21,0.21),('82',0.22,0.11),('82',0.22,0.15),('82',0.22,0.17),('82',0.22,0.27),('82',0.23,0.19),('82',0.25,0.21),('82',0.25,0.27),('82',0.26,0),('82',0.27,0.05),('82',0.28,0.02),('82',0.29,0.04),('82',0.29,0.27),('82',0.3,0.1),('83',0.01,0.01),('83',0.01,0.05),('83',0.01,0.07),('83',0.01,0.11),('83',0.01,0.12),('83',0.01,0.18),('73',0.04,0.29),('73',0.05,0.12),('73',0.05,0.29),('73',0.06,0.13),('73',0.08,0.04),('73',0.09,0.03),('73',0.1,0.06),('73',0.1,0.12),('73',0.12,0.27),('73',0.13,0.25),('73',0.15,0.03),('73',0.15,0.17),('73',0.16,0.11),('73',0.19,0.22),('73',0.2,0.08),('73',0.2,0.21),('73',0.21,0),('73',0.21,0.1),('73',0.21,0.24),('73',0.22,0.13),('73',0.23,0.17),('73',0.23,0.19),('73',0.23,0.26),('73',0.24,0),('73',0.26,0.27),('73',0.28,0.15),('73',0.28,0.27),('73',0.3,0),('73',0.3,0.03),('73',0.3,0.26),('74',0.02,0),('74',0.04,0.09),('74',0.05,0),('74',0.05,0.16),('74',0.07,0.21),('74',0.08,0),('74',0.08,0.21),('74',0.09,0.16),('74',0.11,0.21),('74',0.12,0),('74',0.12,0.21),('74',0.13,0.26),('74',0.14,0.07),('74',0.14,0.27),('74',0.15,0.03),('74',0.16,0.1),('74',0.19,0.21),('74',0.01,0.23),('74',0.21,0.09),('74',0.21,0.11),('74',0.22,0.03),('74',0.23,0.07),('74',0.23,0.12),('74',0.23,0.19),('74',0.24,0.03),('74',0.25,0.01),('74',0.26,0.08),('74',0.26,0.2),('74',0.26,0.26),('74',0.27,0.1),('74',0.28,0.05),('74',0.29,0.29),('74',0.3,0.17),('74',0.3,0.26),('75',0.23,0.06),('75',0.02,0.06),('75',0.02,0.07),('75',0.06,0.13),('75',0.08,0.15),('75',0.08,0.18),('75',0.1,0.08),('75',0.1,0.15),('75',0.1,0.29),('75',0.11,0.07),('75',0.13,0.26),('75',0.18,0.19),('75',0.18,0.2),('75',0.19,0.19),('75',0.21,0.2),('75',0.21,0.29),('75',0.21,0.3),('75',0.22,0.16),('75',0.24,0.01),('75',0.24,0.24),('75',0.29,0.05),('75',0.29,0.08),('76',0,0.04),('76',0,0.06),('76',0.01,0.06),('76',0.03,0.13),('76',0.03,0.27),('76',0.03,0.29),('76',0.04,0.08),('76',0.04,0.22),('76',0.05,0),('76',0.06,0.09),('76',0.06,0.11),('76',0.06,0.29),('76',0.07,0.18),('76',0.09,0.3),('76',0.1,0.01),('76',0.1,0.07),('76',0.11,0.07),('76',0.11,0.1),('76',0.12,0.02),('76',0.12,0.07),('76',0.12,0.12),('76',0.12,0.26),('76',0.12,0.3),('76',0.13,0.05),('76',0.13,0.15),('76',0.13,0.3),('76',0.15,0.1),('76',0.15,0.25),('76',0.16,0.04),('76',0.16,0.25),('76',0.16,0.28),('76',0.18,0.08),('83',0.02,0.02),('76',0.18,0.23),('76',0.19,0.27),('76',0.2,0.17),('76',0.21,0.19),('76',0.22,0.1),('76',0.23,0.05),('76',0.24,0.21),('76',0.25,0.27),('76',0.25,0.28),('76',0.27,0),('76',0.27,0.03),('76',0.28,0),('76',0.28,0.16),('76',0.29,0.01),('76',0.3,0),('77',0.02,0.25),('77',0,0.25),('77',0.01,0.01),('77',0.02,0.06),('77',0.03,0.23),('77',0.03,0.26),('77',0.04,0.2),('77',0.05,0.02),('77',0.06,0.05),('77',0.06,0.26),('77',0.07,0.05),('77',0.08,0.16),('77',0.08,0.27),('77',0.09,0.16),('83',0.03,0.14),('83',0.05,0.05),('83',0.05,0.08),('83',0.05,0.21),('83',0.05,0.28),('83',0.07,0.03),('83',0.08,0.24),('83',0.09,0.19),('83',0.09,0.25),('83',0.12,0.04),('83',0.13,0.25),('83',0.21,0.02),('83',0.21,0.21),('83',0.23,0.06),('83',0.26,0.01),('83',0.26,0.04),('83',0.26,0.15),('83',0.27,0.05),('83',0.27,0.19),('83',0.28,0.12),('83',0.29,0.05),('83',0.3,0.03),('83',0.3,0.14),('83',0.3,0.25),('84',0.17,0.12),('84',0.3,0.28),('84',0.29,0.25),('84',0.29,0.18),('84',0.27,0.1),('84',0.26,0.14),('84',0.26,0.04),('84',0.25,0.27),('84',0.25,0.19),('84',0.23,0.12),('84',0.21,0.02),('84',0.21,0),('84',0.2,0.3),('84',0.2,0.16),('84',0.16,0.25),('84',0.16,0.16),('84',0.16,0.1),('84',0.15,0.11),('84',0.14,0.02),('84',0.13,0.19),('84',0.12,0.25),('92',0.06,0.1),('92',0.07,0.08),('92',0.07,0.11),('92',0.08,0.15),('92',0.08,0.18),('92',0.1,0.12),('92',0.11,0.21),('92',0.11,0.25),('92',0.12,0.14),('92',0.13,0.07),('92',0.18,0.06),('92',0.18,0.12),('92',0.19,0.07),('92',0.19,0.29),('92',0.2,0.02),('92',0.2,0.12),('92',0.2,0.3),('92',0.21,0.09),('92',0.22,0.27),('92',0.24,0.08),('92',0.27,0.07),('92',0.29,0.19),('92',0.29,0.27),('93',0.03,0.09),('93',0.01,0.18),('93',0.03,0.18),('93',0.04,0.15),('93',0.05,0.25),('93',0.05,0.29),('93',0.09,0.27),('93',0.09,0.29),('93',0.1,0),('93',0.1,0.02),('93',0.1,0.07),('93',0.01,0.2),('93',0.1,0.24),('93',0.11,0.08),('93',0.11,0.19),('93',0.14,0.1),('93',0.14,0.26),('93',0.14,0.3),('93',0.16,0.28),('93',0.18,0),('93',0.18,0.09),('93',0.19,0.3),('93',0.2,0.06),('93',0.21,0.04),('93',0.22,0.08),('93',0.23,0.11),('93',0.23,0.14),('93',0.24,0.1),('93',0.25,0.17),('93',0.26,0.3),('93',0.27,0.09),('93',0.28,0.3),('93',0.29,0.16),('93',0.29,0.22),('93',0.3,0.03),('94',0.09,0.25),('94',0,0.26),('94',0.01,0.05),('94',0.01,0.17),('94',0.02,0.13),('94',0.03,0.3),('94',0.06,0.23),('94',0.07,0.09),('94',0.07,0.2),('94',0.08,0.2),('94',0.08,0.23),('94',0.09,0.16),('94',0.12,0.26),('94',0.13,0.01),('94',0.13,0.21),('94',0.14,0.15),('94',0.16,0.14),('94',0.17,0.1),('94',0.19,0.04),('94',0.21,0.17),('94',0.22,0),('94',0.23,0.25),('94',0.25,0.03),('94',0.25,0.1),('94',0.27,0.29),('94',0.29,0.21),('94',0.29,0.26),('94',0.29,0.28),('95',0,0.28),('95',0.01,0.24),('95',0.02,0.02),('95',0.05,0.03),('95',0.05,0.19),('95',0.09,0),('95',0.09,0.01),('95',0.09,0.19),('95',0.09,0.22),('95',0.11,0.04),('95',0.11,0.22),('95',0.13,0.06),('95',0.14,0.01),('95',0.14,0.19),('84',0.12,0.08),('84',0.11,0.02),('84',0.1,0.14),('84',0.1,0.08),('84',0.07,0.24),('84',0.07,0.09),('84',0.07,0.05),('84',0.06,0.11),('84',0.03,0.26),('84',0.02,0.15),('84',0.01,0.25),('84',0.01,0.19),('84',0,0.15),('85',0.06,0.08),('85',0.02,0.25),('85',0.02,0.13),('85',0.02,0.11),('85',0,0.29),('85',0.1,0.1),('85',0.1,0.12),('85',0.1,0.23),('85',0.12,0.12),('85',0.12,0.21),('85',0.13,0.09),('85',0.14,0.03),('85',0.14,0.06),('85',0.14,0.25),('85',0.15,0.02),('85',0.16,0.29),('85',0.16,0.3),('85',0.07,0.04),('85',0.17,0.01),('85',0.17,0.09),('85',0.17,0.15),('85',0.18,0.16),('85',0.18,0.21),('85',0.2,0.05),('85',0.2,0.19),('85',0.21,0.13),('85',0.21,0.21),('85',0.21,0.26),('85',0.23,0),('85',0.23,0.25),('85',0.25,0.18),('85',0.26,0.27),('85',0.27,0.05),('85',0.27,0.07),('85',0.27,0.11),('85',0.28,0.28),('85',0.29,0.26),('85',0.04,0.03),('86',0.04,0.3),('86',0.04,0.18),('86',0.04,0.08),('86',0.06,0.22),('86',0.08,0),('86',0.08,0.14),('86',0.09,0.06),('86',0.09,0.11),('86',0.1,0.02),('86',0.1,0.07),('86',0.1,0.15),('86',0.11,0.1),('86',0.14,0.23),('86',0.14,0.3),('86',0.18,0.03),('86',0,0.17),('86',0.18,0.2),('86',0.19,0.04),('86',0.19,0.15),('86',0.2,0.01),('86',0.22,0.19),('86',0.23,0.05),('86',0.24,0.25),('86',0.24,0.28),('86',0.25,0.11),('86',0.26,0.13),('86',0.26,0.24),('86',0.28,0.06),('86',0.3,0.1),('86',0.04,0.27),('87',0.02,0.23),('87',0,0.01),('87',0,0.19),('87',0.03,0),('87',0.03,0.04),('87',0.05,0.04),('87',0.06,0.12),('87',0.07,0.23),('87',0.07,0.26),('87',0.08,0.02),('87',0.08,0.17),('87',0.1,0.03),('87',0.1,0.06),('87',0.1,0.3),('87',0.11,0.19),('87',0.12,0.1),('87',0.13,0.22),('87',0.16,0.06),('87',0.17,0.23),('87',0.18,0.04),('87',0.18,0.22),('87',0.19,0.11),('87',0.19,0.3),('87',0.2,0.02),('87',0.23,0.09),('87',0.23,0.12),('87',0.25,0.01),('87',0.25,0.24),('87',0.27,0.05),('87',0.27,0.29),('87',0.28,0.14),('87',0.3,0.14),('88',0.3,0.14),('88',0,0.2),('88',0.02,0.29),('88',0.03,0.13),('88',0.03,0.25),('88',0.05,0.11),('88',0.06,0),('88',0.07,0.02),('88',0.09,0.14),('88',0.11,0.25),('88',0.12,0.01),('88',0.12,0.15),('88',0.13,0.05),('88',0.13,0.3),('88',0.16,0.21),('88',0.17,0.3),('88',0.18,0.09),('88',0.19,0.25),('88',0.2,0.04),('88',0.21,0.04),('88',0.21,0.21),('88',0.22,0.09),('88',0.22,0.18),('88',0.22,0.19),('88',0.23,0.04),('88',0.23,0.25),('88',0.26,0.07),('88',0.26,0.17),('88',0.26,0.2),('88',0.27,0.21),('88',0.27,0.24),('88',0.28,0.19),('88',0.28,0.22),('88',0.3,0.28),('89',0.02,0.03),('89',0.02,0.19),('89',0.03,0.03),('89',0.04,0.28),('89',0.06,0.03),('89',0.06,0.26),('89',0.07,0.09),('89',0.09,0.17),('89',0.12,0.17),('89',0.12,0.26),('89',0.12,0.3),('89',0.13,0.22),('89',0.13,0.26),('89',0.14,0.06),('89',0.15,0.03),('89',0.16,0.02),('89',0.17,0.24),('89',0.19,0.01),('89',0.01,0.29),('89',0.19,0.2),('89',0.2,0.29),('89',0.22,0.12),('89',0.23,0.17),('89',0.23,0.21),('89',0.23,0.28),('89',0.25,0.14),('89',0.26,0.08),('89',0.26,0.24),('90',0.23,0.12),('90',0,0.21),('90',0.03,0.06),('90',0.03,0.16),('90',0.05,0.06),('90',0.06,0.1),('90',0.07,0.04),('90',0.09,0.12),('90',0.13,0.06),('90',0.14,0.24),('90',0.15,0.07),('90',0.18,0.07),('90',0.19,0.11),('90',0.2,0.13),('90',0.21,0.07),('90',0.21,0.09),('90',0.21,0.16),('90',0.22,0.11),('90',0.22,0.15),('90',0.24,0.01),('90',0.26,0),('90',0.28,0.18),('90',0.28,0.22),('90',0.29,0.13),('90',0.29,0.26),('91',0.01,0.15),('91',0.01,0.2),('91',0.02,0.05),('91',0.02,0.14),('91',0.03,0.02),('91',0.03,0.1),('91',0.03,0.17),('91',0.05,0.16),('91',0.05,0.28),('91',0.06,0.06),('91',0.08,0.2),('91',0.09,0.19),('91',0.1,0.09),('91',0.1,0.25),('91',0.11,0.21),('91',0.11,0.24),('91',0.11,0.28),('91',0.11,0.29),('91',0.13,0.08),('91',0.16,0.1),('91',0.16,0.29),('91',0.17,0.07),('91',0.18,0.21),('91',0.2,0.05),('91',0.2,0.08),('91',0.2,0.13),('91',0.2,0.15),('91',0.2,0.23),('91',0.2,0.29),('91',0.21,0.06),('91',0.22,0.1),('91',0.23,0.28),('91',0.25,0.19),('91',0.25,0.3),('91',0.26,0.22),('91',0.27,0.07),('91',0.28,0.06),('91',0.28,0.09),('91',0.3,0.16),('92',0.15,0.13),('92',0.01,0.22),('92',0.02,0.12),('92',0.02,0.16),('92',0.04,0.23),('92',0.05,0.1),('92',0.06,0.02),('95',0.16,0.2),('95',0.17,0.22),('95',0.17,0.23),('95',0.18,0.02),('95',0.19,0.02),('95',0.19,0.15),('95',0.21,0.05),('95',0.21,0.19),('95',0.22,0.02),('95',0.22,0.16),('95',0.22,0.28),('95',0.26,0.03),('95',0.26,0.12),('95',0.27,0.2),('95',0.29,0.18),('95',0.3,0.04),('96',0.01,0),('96',0,0.25),('96',0,0.3),('96',0.02,0.01),('96',0.02,0.29),('96',0.03,0.07),('96',0.04,0.02),('96',0.04,0.07),('96',0.04,0.16),('96',0.06,0.12),('96',0.07,0.17),('96',0.08,0.07),('96',0.1,0.05),('96',0.13,0.03),('96',0.14,0.25),('96',0.15,0.16),('96',0.16,0.04),('96',0.17,0.12),('96',0.19,0.11),('96',0.19,0.24),('96',0.21,0.03),('96',0.21,0.08),('96',0.23,0.09),('96',0.23,0.26),('96',0.25,0.03),('96',0.25,0.08),('96',0.25,0.26),('96',0.26,0.17),('96',0.27,0.11),('96',0.27,0.26),('96',0.28,0.07),('96',0.28,0.21),('96',0.28,0.23),('96',0.29,0.14),('97',0.01,0.01),('97',0.02,0.18),('97',0.02,0.25),('97',0.03,0.16),('97',0.03,0.26),('97',0.04,0.15),('97',0.04,0.27),('97',0.06,0.27),('97',0.07,0.21),('97',0.08,0.06),('97',0.08,0.09),('97',0.08,0.17),('97',0.1,0.07),('97',0.13,0),('97',0.14,0.1),('97',0.15,0),('97',0.15,0.07),('97',0.15,0.09),('97',0.16,0),('97',0.16,0.16),('97',0.17,0),('97',0.17,0.2),('97',0.17,0.29),('97',0.18,0.11),('97',0.2,0.09),('97',0.21,0.06),('97',0.23,0.1),('97',0.23,0.28),('97',0.24,0.27),('97',0.26,0.21),('97',0.28,0.2),('97',0.3,0.07),('97',0.3,0.21),('98',0.29,0.01),('98',0.01,0.07),('98',0.01,0.26),('98',0.02,0.28),('98',0.02,0.29),('98',0.03,0.03),('98',0.04,0.11),('98',0.04,0.18),('98',0.04,0.2),('98',0.05,0.04),('98',0.05,0.13),('98',0.06,0.16),('98',0.06,0.26),('98',0.11,0.3),('98',0.12,0.2),('98',0.13,0.2),('98',0.14,0.21),('98',0.14,0.22),('98',0.15,0.13),('98',0.16,0.07),('98',0.16,0.26),('98',0.17,0.12),('98',0.19,0.16),('98',0.19,0.29),('98',0.2,0.25),('98',0.23,0.04),('98',0.24,0.25),('98',0.25,0.2),('98',0.26,0.29),('98',0.3,0.09),('98',0.28,0.16),('99',0.26,0.26),('99',0.27,0.14),('99',0.28,0.06),('99',0.28,0.27),('99',0.28,0.29),('99',0.3,0),('99',0.3,0.22),('99',0.02,0.02),('99',0.02,0.16),('99',0.04,0.15),('99',0.05,0),('99',0.05,0.23),('99',0.06,0.04),('99',0.07,0),('99',0.08,0),('99',0.1,0.24),('99',0.11,0.13),('99',0.12,0),('99',0.13,0.3),('99',0.14,0.12),('99',0.15,0.07),('99',0.16,0.03),('99',0.16,0.1),('99',0.16,0.14),('99',0.16,0.16),('99',0.17,0.06),('99',0.19,0.05),('99',0.19,0.09),('99',0.22,0.24),('99',0.22,0.29),('99',0.23,0.11),('99',0.24,0.03);
/*Table structure for table `demo3` */
DROP TABLE IF EXISTS `demo3`;
CREATE TABLE `demo3` (
`name` varchar(255) DEFAULT NULL,
`value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `demo3` */
insert into `demo3`(`name`,`value`) values ('3',448),('4',439),('1',449),('5',439),('7',458),('2',450),('6',456);
/*Table structure for table `demo4` */
DROP TABLE IF EXISTS `demo4`;
CREATE TABLE `demo4` (
`name` varchar(255) DEFAULT NULL,
`value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `demo4` */
insert into `demo4`(`name`,`value`) values ('202204',451),('202205',458),('202201',444),('202208',424),('202202',444),('202203',454),('202206',444),('202207',446);
/*Table structure for table `demo5` */
DROP TABLE IF EXISTS `demo5`;
CREATE TABLE `demo5` (
`name` varchar(255) DEFAULT NULL,
`value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `demo5` */
insert into `demo5`(`name`,`value`) values ('5',439),('6',456),('7',458),('3',448),('4',439),('1',449),('2',450);
/*Table structure for table `demo6` */
DROP TABLE IF EXISTS `demo6`;
CREATE TABLE `demo6` (
`name` varchar(255) DEFAULT NULL,
`value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `demo6` */
insert into `demo6`(`name`,`value`) values ('13',46),('0',31),('19',47),('7',38),('14',37),('1',40),('20',39),('8',44),('9',47),('10',39),('21',39),('11',39),('22',32),('12',52),('23',48),('15',35),('16',44),('17',37),('18',39),('2',41),('3',46),('4',49),('5',40),('6',51);
/*Table structure for table `demo7` */
DROP TABLE IF EXISTS `demo7`;
CREATE TABLE `demo7` (
`name` varchar(255) DEFAULT NULL,
`value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `demo7` */
insert into `demo7`(`name`,`value`) values ('14 ',36),('15 ',35),('2 ',41),('16 ',42),('17 ',42),('18 ',55),('20 ',44),('19 ',42),('21 ',32),('22 ',49),('23 ',42),('3 ',44),('0 ',35),('4 ',40),('1 ',38),('10 ',39),('11 ',60),('12 ',53),('13 ',37),('5 ',38),('6 ',41),('7 ',42),('8 ',36),('9 ',37);
/*Table structure for table `demo8` */
DROP TABLE IF EXISTS `demo8`;
CREATE TABLE `demo8` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country` varchar(255) DEFAULT NULL,
`num` int(11) DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4;
/*Data for the table `demo8` */
insert into `demo8`(`id`,`country`,`num`) values (1,'上海市',93778),(2,'云南',93575),(3,'内蒙古',93955),(4,'北京市',93881),(5,'台湾',93671),(6,'吉林',93796),(7,'四川',93444),(8,'天津市',93369),(9,'宁夏',94260),(10,'安徽',93726),(11,'山东',93379),(12,'山西',93556),(13,'广东',93276),(14,'广西',93372),(15,'新疆',93503),(16,'江苏',93219),(17,'江西',93678),(18,'河北',93406),(19,'河南',93343),(20,'浙江',93666),(21,'海南',93178),(22,'湖北',93979),(23,'湖南',93378),(24,'澳门',93544),(25,'甘肃',93460),(26,'福建',94105),(27,'西藏',93899),(28,'贵州',93551),(29,'辽宁',93688),(30,'重庆市',93341),(31,'陕西',93782),(32,'青海',93724),(33,'香港',93443),(34,'黑龙江',93336);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;