jQh5snkj

1// Stworzenie tabeli 'dane_Graczy' z polami 'name', 'zabicia' i 'smierci'.
2CREATE TABLE IF NOT EXISTS `dane_graczy` (`name` VARCHAR(50) NOT NULL,  `zabicia` INT(10) NOT NULL, `smierci` INT(10) NOT NULL DEFAULT 0);
3
4// Dodanie fakeowych 100 graczy z randomowymi danymi:
5INSERT INTO `dane_graczy` VALUES ('some_name0', '173', '24');
6INSERT INTO `dane_graczy` VALUES ('some_name1', '154', '16');
7INSERT INTO `dane_graczy` VALUES ('some_name2', '144', '43');
8INSERT INTO `dane_graczy` VALUES ('some_name3', '48', '23');
9INSERT INTO `dane_graczy` VALUES ('some_name4', '80', '30');
10INSERT INTO `dane_graczy` VALUES ('some_name5', '46', '23');
11INSERT INTO `dane_graczy` VALUES ('some_name6', '297', '1');
12INSERT INTO `dane_graczy` VALUES ('some_name7', '145', '32');
13INSERT INTO `dane_graczy` VALUES ('some_name8', '105', '29');
14INSERT INTO `dane_graczy` VALUES ('some_name9', '177', '8');
15INSERT INTO `dane_graczy` VALUES ('some_name10', '157', '8');
16INSERT INTO `dane_graczy` VALUES ('some_name11', '161', '6');
17INSERT INTO `dane_graczy` VALUES ('some_name12', '174', '47');
18INSERT INTO `dane_graczy` VALUES ('some_name13', '234', '35');
19INSERT INTO `dane_graczy` VALUES ('some_name14', '245', '38');
20INSERT INTO `dane_graczy` VALUES ('some_name15', '211', '31');
21INSERT INTO `dane_graczy` VALUES ('some_name16', '24', '24');
22INSERT INTO `dane_graczy` VALUES ('some_name17', '296', '20');
23INSERT INTO `dane_graczy` VALUES ('some_name18', '220', '46');
24INSERT INTO `dane_graczy` VALUES ('some_name19', '279', '39');
25INSERT INTO `dane_graczy` VALUES ('some_name20', '231', '28');
26INSERT INTO `dane_graczy` VALUES ('some_name21', '23', '1');
27INSERT INTO `dane_graczy` VALUES ('some_name22', '35', '44');
28INSERT INTO `dane_graczy` VALUES ('some_name23', '99', '28');
29INSERT INTO `dane_graczy` VALUES ('some_name24', '165', '15');
30INSERT INTO `dane_graczy` VALUES ('some_name25', '166', '19');
31INSERT INTO `dane_graczy` VALUES ('some_name26', '43', '12');
32INSERT INTO `dane_graczy` VALUES ('some_name27', '222', '42');
33INSERT INTO `dane_graczy` VALUES ('some_name28', '237', '38');
34INSERT INTO `dane_graczy` VALUES ('some_name29', '166', '10');
35INSERT INTO `dane_graczy` VALUES ('some_name30', '277', '17');
36INSERT INTO `dane_graczy` VALUES ('some_name31', '137', '44');
37INSERT INTO `dane_graczy` VALUES ('some_name32', '195', '17');
38INSERT INTO `dane_graczy` VALUES ('some_name33', '22', '20');
39INSERT INTO `dane_graczy` VALUES ('some_name34', '44', '45');
40INSERT INTO `dane_graczy` VALUES ('some_name35', '264', '49');
41INSERT INTO `dane_graczy` VALUES ('some_name36', '245', '39');
42INSERT INTO `dane_graczy` VALUES ('some_name37', '14', '20');
43INSERT INTO `dane_graczy` VALUES ('some_name38', '256', '24');
44INSERT INTO `dane_graczy` VALUES ('some_name39', '280', '5');
45INSERT INTO `dane_graczy` VALUES ('some_name40', '281', '30');
46INSERT INTO `dane_graczy` VALUES ('some_name41', '100', '3');
47INSERT INTO `dane_graczy` VALUES ('some_name42', '120', '31');
48INSERT INTO `dane_graczy` VALUES ('some_name43', '169', '34');
49INSERT INTO `dane_graczy` VALUES ('some_name44', '30', '29');
50INSERT INTO `dane_graczy` VALUES ('some_name45', '300', '40');
51INSERT INTO `dane_graczy` VALUES ('some_name46', '241', '41');
52INSERT INTO `dane_graczy` VALUES ('some_name47', '270', '20');
53INSERT INTO `dane_graczy` VALUES ('some_name48', '103', '13');
54INSERT INTO `dane_graczy` VALUES ('some_name49', '158', '4');
55INSERT INTO `dane_graczy` VALUES ('some_name50', '6', '14');
56INSERT INTO `dane_graczy` VALUES ('some_name51', '148', '37');
57INSERT INTO `dane_graczy` VALUES ('some_name52', '179', '46');
58INSERT INTO `dane_graczy` VALUES ('some_name53', '118', '50');
59INSERT INTO `dane_graczy` VALUES ('some_name54', '3', '23');
60INSERT INTO `dane_graczy` VALUES ('some_name55', '34', '46');
61INSERT INTO `dane_graczy` VALUES ('some_name56', '223', '48');
62INSERT INTO `dane_graczy` VALUES ('some_name57', '278', '5');
63INSERT INTO `dane_graczy` VALUES ('some_name58', '24', '34');
64INSERT INTO `dane_graczy` VALUES ('some_name59', '121', '42');
65INSERT INTO `dane_graczy` VALUES ('some_name60', '217', '32');
66INSERT INTO `dane_graczy` VALUES ('some_name61', '63', '44');
67INSERT INTO `dane_graczy` VALUES ('some_name62', '129', '9');
68INSERT INTO `dane_graczy` VALUES ('some_name63', '22', '50');
69INSERT INTO `dane_graczy` VALUES ('some_name64', '176', '4');
70INSERT INTO `dane_graczy` VALUES ('some_name65', '84', '0');
71INSERT INTO `dane_graczy` VALUES ('some_name66', '249', '16');
72INSERT INTO `dane_graczy` VALUES ('some_name67', '261', '26');
73INSERT INTO `dane_graczy` VALUES ('some_name68', '80', '36');
74INSERT INTO `dane_graczy` VALUES ('some_name69', '295', '20');
75INSERT INTO `dane_graczy` VALUES ('some_name70', '203', '38');
76INSERT INTO `dane_graczy` VALUES ('some_name71', '198', '37');
77INSERT INTO `dane_graczy` VALUES ('some_name72', '198', '10');
78INSERT INTO `dane_graczy` VALUES ('some_name73', '300', '40');
79INSERT INTO `dane_graczy` VALUES ('some_name74', '158', '40');
80INSERT INTO `dane_graczy` VALUES ('some_name75', '244', '42');
81INSERT INTO `dane_graczy` VALUES ('some_name76', '254', '34');
82INSERT INTO `dane_graczy` VALUES ('some_name77', '253', '21');
83INSERT INTO `dane_graczy` VALUES ('some_name78', '203', '19');
84INSERT INTO `dane_graczy` VALUES ('some_name79', '149', '9');
85INSERT INTO `dane_graczy` VALUES ('some_name80', '222', '19');
86INSERT INTO `dane_graczy` VALUES ('some_name81', '95', '4');
87INSERT INTO `dane_graczy` VALUES ('some_name82', '51', '50');
88INSERT INTO `dane_graczy` VALUES ('some_name83', '67', '2');
89INSERT INTO `dane_graczy` VALUES ('some_name84', '67', '2');
90INSERT INTO `dane_graczy` VALUES ('some_name85', '108', '6');
91INSERT INTO `dane_graczy` VALUES ('some_name86', '174', '36');
92INSERT INTO `dane_graczy` VALUES ('some_name87', '53', '46');
93INSERT INTO `dane_graczy` VALUES ('some_name88', '15', '37');
94INSERT INTO `dane_graczy` VALUES ('some_name89', '138', '12');
95INSERT INTO `dane_graczy` VALUES ('some_name90', '281', '7');
96INSERT INTO `dane_graczy` VALUES ('some_name91', '163', '37');
97INSERT INTO `dane_graczy` VALUES ('some_name92', '126', '6');
98INSERT INTO `dane_graczy` VALUES ('some_name93', '19', '28');
99INSERT INTO `dane_graczy` VALUES ('some_name94', '119', '0');
100INSERT INTO `dane_graczy` VALUES ('some_name95', '110', '11');
101INSERT INTO `dane_graczy` VALUES ('some_name96', '221', '28');
102INSERT INTO `dane_graczy` VALUES ('some_name97', '37', '12');
103INSERT INTO `dane_graczy` VALUES ('some_name98', '98', '1');
104INSERT INTO `dane_graczy` VALUES ('some_name99', '136', '4');
105
106// Pobranie 15 nickow względem największej ilosci zabojstw
107SELECT * FROM `dane_graczy` ORDER BY `zabicia` DESC LIMIT 15