-
Notifications
You must be signed in to change notification settings - Fork 2
/
user_emotion.sql
150 lines (146 loc) · 5.36 KB
/
user_emotion.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
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
use aiconcd;
insert into user_emotion values
('1234','2021-09-27','korean',0,800),
('1234','2021-09-27','korean',1,700),
('1234','2021-09-27','korean',2,500),
('1234','2021-09-27','korean',3,100),
('1234','2021-09-27','korean',4,900),
('1234','2021-09-27','korean',5,100),
('1234','2021-09-27','korean',6,130),
('1234','2021-09-27','math',0,898),
('1234','2021-09-27','math',1,393),
('1234','2021-09-27','math',2,111),
('1234','2021-09-27','math',3,222),
('1234','2021-09-27','math',4,333),
('1234','2021-09-27','math',5,444),
('1234','2021-09-27','math',6,555),
('1234','2021-09-27','english',0,250),
('1234','2021-09-27','english',1,300),
('1234','2021-09-27','english',2,450),
('1234','2021-09-27','english',3,551),
('1234','2021-09-27','english',4,100),
('1234','2021-09-27','english',5,201),
('1234','2021-09-27','english',6,501),
('1234','2021-09-27','science',0,549),
('1234','2021-09-27','science',1,49),
('1234','2021-09-27','science',2,149),
('1234','2021-09-27','science',3,751),
('1234','2021-09-27','science',4,256),
('1234','2021-09-27','science',5,157),
('1234','2021-09-27','science',6,964);
insert into user_emotion values
('1234','2021-09-28','korean',0,547),
('1234','2021-09-28','korean',1,148),
('1234','2021-09-28','korean',2,923),
('1234','2021-09-28','korean',3,456),
('1234','2021-09-28','korean',4,516),
('1234','2021-09-28','korean',5,489),
('1234','2021-09-28','korean',6,897),
('1234','2021-09-28','math',0,546),
('1234','2021-09-28','math',1,654),
('1234','2021-09-28','math',2,198),
('1234','2021-09-28','math',3,75),
('1234','2021-09-28','math',4,984),
('1234','2021-09-28','math',5,785),
('1234','2021-09-28','math',6,454),
('1234','2021-09-28','english',0,483),
('1234','2021-09-28','english',1,97),
('1234','2021-09-28','english',2,598),
('1234','2021-09-28','english',3,347),
('1234','2021-09-28','english',4,1593),
('1234','2021-09-28','english',5,80),
('1234','2021-09-28','english',6,481),
('1234','2021-09-28','science',0,985),
('1234','2021-09-28','science',1,984),
('1234','2021-09-28','science',2,354),
('1234','2021-09-28','science',3,951),
('1234','2021-09-28','science',4,741),
('1234','2021-09-28','science',5,963),
('1234','2021-09-28','science',6,854);
insert into user_emotion values
('1234','2021-09-29','korean',0,444),
('1234','2021-09-29','korean',1,497),
('1234','2021-09-29','korean',2,898),
('1234','2021-09-29','korean',3,551),
('1234','2021-09-29','korean',4,900),
('1234','2021-09-29','korean',5,156),
('1234','2021-09-29','korean',6,130),
('1234','2021-09-29','math',0,898),
('1234','2021-09-29','math',1,49),
('1234','2021-09-29','math',2,551),
('1234','2021-09-29','math',3,898),
('1234','2021-09-29','math',4,74),
('1234','2021-09-29','math',5,444),
('1234','2021-09-29','math',6,555),
('1234','2021-09-29','english',0,250),
('1234','2021-09-29','english',1,841),
('1234','2021-09-29','english',2,898),
('1234','2021-09-29','english',3,551),
('1234','2021-09-29','english',4,100),
('1234','2021-09-29','english',5,444),
('1234','2021-09-29','english',6,130),
('1234','2021-09-29','science',0,549),
('1234','2021-09-29','science',1,49),
('1234','2021-09-29','science',2,551),
('1234','2021-09-29','science',3,751),
('1234','2021-09-29','science',4,130),
('1234','2021-09-29','science',5,444),
('1234','2021-09-29','science',6,51);
insert into user_emotion values
('1234','2021-09-30','korean',0,414),
('1234','2021-09-30','korean',1,642),
('1234','2021-09-30','korean',2,349),
('1234','2021-09-30','korean',3,1530),
('1234','2021-09-30','korean',4,324),
('1234','2021-09-30','korean',5,843),
('1234','2021-09-30','korean',6,954),
('1234','2021-09-30','math',0,854),
('1234','2021-09-30','math',1,147),
('1234','2021-09-30','math',2,843),
('1234','2021-09-30','math',3,921),
('1234','2021-09-30','math',4,567),
('1234','2021-09-30','math',5,746),
('1234','2021-09-30','math',6,555),
('1234','2021-09-30','english',0,547),
('1234','2021-09-30','english',1,451),
('1234','2021-09-30','english',2,450),
('1234','2021-09-30','english',3,551),
('1234','2021-09-30','english',4,571),
('1234','2021-09-30','english',5,201),
('1234','2021-09-30','english',6,957),
('1234','2021-09-30','science',0,95),
('1234','2021-09-30','science',1,741),
('1234','2021-09-30','science',2,149),
('1234','2021-09-30','science',3,567),
('1234','2021-09-30','science',4,256),
('1234','2021-09-30','science',5,854),
('1234','2021-09-30','science',6,671);
insert into user_emotion values
('1234','2021-10-01','korean',0,101),
('1234','2021-10-01','korean',1,574),
('1234','2021-10-01','korean',2,500),
('1234','2021-10-01','korean',3,547),
('1234','2021-10-01','korean',4,900),
('1234','2021-10-01','korean',5,682),
('1234','2021-10-01','korean',6,130),
('1234','2021-10-01','math',0,898),
('1234','2021-10-01','math',1,468),
('1234','2021-10-01','math',2,111),
('1234','2021-10-01','math',3,854),
('1234','2021-10-01','math',4,333),
('1234','2021-10-01','math',5,127),
('1234','2021-10-01','math',6,654),
('1234','2021-10-01','english',0,651),
('1234','2021-10-01','english',1,300),
('1234','2021-10-01','english',2,685),
('1234','2021-10-01','english',3,154),
('1234','2021-10-01','english',4,456),
('1234','2021-10-01','english',5,201),
('1234','2021-10-01','english',6,657),
('1234','2021-10-01','science',0,549),
('1234','2021-10-01','science',1,283),
('1234','2021-10-01','science',2,674),
('1234','2021-10-01','science',3,357),
('1234','2021-10-01','science',4,694),
('1234','2021-10-01','science',5,841),
('1234','2021-10-01','science',6,534);