-
Notifications
You must be signed in to change notification settings - Fork 0
/
TablesCreation
124 lines (118 loc) · 5.49 KB
/
TablesCreation
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
CREATE TABLE Table1
(`REG` int, `Pregnancies` int, `Glucose` int, `BloodPressure` int,
`SkinThickness` int, `Insulin` int, `BMI` int, `DiabetesPedigreeFunction` int,
`Age` int, `Outcome` int); /* 1st table created
INSERT INTO Table1
(`REG`, `Pregnancies`, `Glucose`, `BloodPressure`, `SkinThickness`, `Insulin`,
`BMI`, `DiabetesPedigreeFunction`, `Age`, `Outcome`)
VALUES
(1, 6, 148, 72, 35, 0, 33.6, 0.627, 50, 1),
(2, 1, 85, 66, 29, 0, 26.6, 0.351, 31, 0),
(3, 8, 183, 64, 0, 0, 23.3, 0.672, 32, 1),
(4, 1, 89, 66, 23, 94, 28.1, 0.167, 21, 0),
(5, 0, 137, 40, 35, 168, 43.1, 2.288, 33, 1),
(6, 5, 116, 74, 0, 0, 25.6, 0.201, 30, 0),
(7, 3, 78, 50, 32, 88, 31, 0.248, 26, 1),
(8, 10, 115, 0, 0, 0, 35.3, 0.134, 29, 0),
(9, 2, 197, 70, 45, 543, 30.5, 0.158, 53, 1),
(10, 8, 125, 96, 0, 0, 0, 0.232, 54, 1),
(11, 4, 110, 92, 0, 0, 37.6, 0.191, 30, 0),
(12, 10, 168, 74, 0, 0, 38, 0.537, 34, 1),
(13, 10, 139, 80, 0, 0, 27.1, 1.441, 57, 0),
(14, 1, 189, 60, 23, 846, 30.1, 0.398, 59, 1),
(15, 5, 166, 72, 19, 175, 25.8, 0.587, 51, 1),
(16, 7, 100, 0, 0, 0, 30, 0.484, 32, 1),
(17, 0, 118, 84, 47, 230, 45.8, 0.551, 31, 1),
(18, 7, 107, 74, 0, 0, 29.6, 0.254, 31, 1),
(19, 1, 103, 30, 38, 83, 43.3, 0.183, 33, 0),
(20, 1, 115, 70, 30, 96, 34.6, 0.529, 32, 1),
(21, 3, 126, 88, 41, 235, 39.3, 0.704, 27, 0),
(22, 8, 99, 84, 0, 0, 35.4, 0.388, 50, 0),
(23, 7, 196, 90, 0, 0, 39.8, 0.451, 41, 1),
(24, 9, 119, 80, 35, 0, 29, 0.263, 29, 1),
(25, 11, 143, 94, 33, 146, 36.6, 0.254, 51, 1),
(26, 10, 125, 70, 26, 115, 31.1, 0.205, 41, 1),
(27, 7, 147, 76, 0, 0, 39.4, 0.257, 43, 1),
(28, 1, 97, 66, 15, 140, 23.2, 0.487, 22, 0),
(29, 13, 145, 82, 19, 110, 22.2, 0.245, 57, 0),
(30, 5, 117, 92, 0, 0, 34.1, 0.337, 38, 0),
(31, 5, 109, 75, 26, 0, 36, 0.546, 60, 0),
(32, 3, 158, 76, 36, 245, 31.6, 0.851, 28, 1),
(33, 3, 88, 58, 11, 54, 24.8, 0.267, 22, 0),
(34, 6, 92, 92, 0, 0, 19.9, 0.188, 28, 0),
(35, 10, 122, 78, 31, 0, 27.6, 0.512, 45, 0),
(36, 4, 103, 60, 33, 192, 24, 0.966, 33, 0),
(37, 11, 138, 76, 0, 0, 33.2, 0.42, 35, 0),
(38, 9, 102, 76, 37, 0, 32.9, 0.665, 46, 1),
(39, 2, 90, 68, 42, 0, 38.2, 0.503, 27, 1),
(40, 4, 111, 72, 47, 207, 37.1, 1.39, 56, 1),
(41, 3, 180, 64, 25, 70, 34, 0.271, 26, 0),
(42, 7, 133, 84, 0, 0, 40.2, 0.696, 37, 0),
(43, 7, 106, 92, 18, 0, 22.7, 0.235, 48, 0),
(44, 9, 171, 110, 24, 240, 45.4, 0.721, 54, 1),
(45, 7, 159, 64, 0, 0, 27.4, 0.294, 40, 0),
(46, 0, 180, 66, 39, 0, 42, 1.893, 25, 1),
(47, 1, 146, 56, 0, 0, 29.7, 0.564, 29, 0),
(48, 2, 71, 70, 27, 0, 28, 0.586, 22, 0),
(49, 7, 103, 66, 32, 0, 39.1, 0.344, 31, 1),
(50, 7, 105, 0, 0, 0, 0, 0.305, 24, 0),
(51, 1, 103, 80, 11, 82, 19.4, 0.491, 22, 0),
(52, 1, 101, 50, 15, 36, 24.2, 0.526, 26, 0),
(53, 5, 88, 66, 21, 23, 24.4, 0.342, 30, 0),
(54, 8, 176, 90, 34, 300, 33.7, 0.467, 58, 1),
(55, 7, 150, 66, 42, 342, 34.7, 0.718, 42, 0),
(56, 1, 73, 50, 10, 0, 23, 0.248, 21, 0),
(57, 7, 187, 68, 39, 304, 37.7, 0.254, 41, 1),
(58, 0, 100, 88, 60, 110, 46.8, 0.962, 31, 0),
(59, 0, 146, 82, 0, 0, 40.5, 1.781, 44, 0),
(60, 0, 105, 64, 41, 142, 41.5, 0.173, 22, 0),
(61, 2, 84, 0, 0, 0, 0, 0.304, 21, 0),
(62, 8, 133, 72, 0, 0, 32.9, 0.27, 39, 1),
(63, 5, 44, 62, 0, 0, 25, 0.587, 36, 0),
(64, 2, 141, 58, 34, 128, 25.4, 0.699, 24, 0),
(65, 7, 114, 66, 0, 0, 32.8, 0.258, 42, 1),
(66, 5, 99, 74, 27, 0, 29, 0.203, 32, 0),
(67, 0, 109, 88, 30, 0, 32.5, 0.855, 38, 1),
(68, 2, 109, 92, 0, 0, 42.7, 0.845, 54, 0),
(69, 1, 95, 66, 13, 38, 19.6, 0.334, 25, 0),
(70, 4, 146, 85, 27, 100, 28.9, 0.189, 27, 0),
(71, 2, 100, 66, 20, 90, 32.9, 0.867, 28, 1),
(72, 5, 139, 64, 35, 140, 28.6, 0.411, 26, 0),
(73, 13, 126, 90, 0, 0, 43.4, 0.583, 42, 1),
(74, 4, 129, 86, 20, 270, 35.1, 0.231, 23, 0),
(75, 1, 79, 75, 30, 0, 32, 0.396, 22, 0),
(76, 1, 0, 48, 20, 0, 24.7, 0.14, 22, 0),
(77, 7, 62, 78, 0, 0, 32.6, 0.391, 41, 0),
(78, 5, 95, 72, 33, 0, 37.7, 0.37, 27, 0),
(79, 0, 131, 0, 0, 0, 43.2, 0.27, 26, 1),
(80, 2, 112, 66, 22, 0, 25, 0.307, 24, 0),
(81, 3, 113, 44, 13, 0, 22.4, 0.14, 22, 0),
(82, 2, 74, 0, 0, 0, 0, 0.102, 22, 0),
(83, 7, 83, 78, 26, 71, 29.3, 0.767, 36, 0),
(84, 0, 101, 65, 28, 0, 24.6, 0.237, 22, 0),
(85, 5, 137, 108, 0, 0, 48.8, 0.227, 37, 1),
(86, 2, 110, 74, 29, 125, 32.4, 0.698, 27, 0),
(87, 13, 106, 72, 54, 0, 36.6, 0.178, 45, 0),
(88, 2, 100, 68, 25, 71, 38.5, 0.324, 26, 0),
(89, 15, 136, 70, 32, 110, 37.1, 0.153, 43, 1),
(90, 1, 107, 68, 19, 0, 26.5, 0.165, 24, 0),
(91, 1, 80, 55, 0, 0, 19.1, 0.258, 21, 0),
(92, 4, 123, 80, 15, 176, 32, 0.443, 34, 0),
(93, 7, 81, 78, 40, 48, 46.7, 0.261, 42, 0),
(94, 4, 134, 72, 0, 0, 23.8, 0.277, 60, 1),
(95, 2, 142, 82, 18, 64, 24.7, 0.761, 21, 0),
(96, 6, 144, 72, 27, 228, 33.9, 0.255, 40, 0),
(97, 2, 92, 62, 28, 0, 31.6, 0.13, 24, 0),
(98, 1, 71, 48, 18, 76, 20.4, 0.323, 22, 0),
(99, 6, 93, 50, 30, 64, 28.7, 0.356, 23, 0),
(100, 1, 122, 90, 51, 220, 49.7, 0.325, 31, 1);
CREATE TABLE BMITBL(`REG_B` int NOT NULL,`BMI` float ,`BMI_RANGE` CHAR(20)); /*2nd table created from 1st table */
INSERT INTO BMITBL(`REG_B`,`BMI`,`BMI_RANGE`)
SELECT BMI,
CASE
WHEN BMI <=18.5 THEN 'Underweight'
WHEN BMI >18.5 AND BMI <=24.9 THEN 'Normal'
WHEN BMI >24.9 AND BMI <=29.9 THEN 'Overweight'
ELSE 'Obese'
END
from Table1;