-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathBasketball_details.sql
54 lines (41 loc) · 2.96 KB
/
Basketball_details.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
------------------------------------------------------------------
insert into basketball Values('07','20072101','20072102','11','12','20072102');
insert into basketball Values('08','20072103','20072104','9','12','20072104');
insert into basketball Values('09','20072101','20072104','13','14','20072104');
insert into basketball Values('10','20072102','20072103','15','12','20072102');
insert into basketball Values('11','20072101','20072103','10','15','20072103');
insert into basketball Values('12','20072102','20072104','12','17','20072104');
---------------------------------------------------------------
insert into basketball_points Values('20072101','3','0','3','0');
insert into basketball_points Values('20072102','3','2','1','+4');
insert into basketball_points Values('20072103','3','1','2','+2');
insert into basketball_points Values('20072104','3','3','0','+6');
--------------------------------------
insert into basketball_players_points Values('20072101001','3','8','3');
insert into basketball_players_points Values('20072101002','3','9','2');
insert into basketball_players_points Values('20072101003','3','9','3');
insert into basketball_players_points Values('20072101004','3','6','2');
insert into basketball_players_points Values('20072101005','2','6','3');
insert into basketball_players_points Values('20072101006','1','4','2');
insert into basketball_players_points Values('20072101007','1','0','2');
insert into basketball_players_points Values('20072102001','3','11','1');
insert into basketball_players_points Values('20072102002','3','14','4');
insert into basketball_players_points Values('20072102003','3','9','2');
insert into basketball_players_points Values('20072102004','3','7','3');
insert into basketball_players_points Values('20072102005','2','3','1');
insert into basketball_players_points Values('20072102006','1','2','1');
insert into basketball_players_points Values('20072102007','1','3','1');
insert into basketball_players_points Values('20072103001','3','13','3');
insert into basketball_players_points Values('20072103002','3','9','2');
insert into basketball_players_points Values('20072103003','3','12','4');
insert into basketball_players_points Values('20072103004','3','8','3');
insert into basketball_players_points Values('20072103005','0','0','0');
insert into basketball_players_points Values('20072103006','3','7','2');
insert into basketball_players_points Values('20072103007','0','0','0');
insert into basketball_players_points Values('20072104001','3','12','4');
insert into basketball_players_points Values('20072104002','3','15','3');
insert into basketball_players_points Values('20072104003','3','10','2');
insert into basketball_players_points Values('20072104004','3','8','3');
insert into basketball_players_points Values('20072104005','1','4','2');
insert into basketball_players_points Values('20072104006','1','2','0');
insert into basketball_players_points Values('20072104007','2','5','2');