CREATE TABLE player_booked (match_no int,team_id INT,player_id int,booking_time int, sent_off varchar(1),play_schedule varchar(2),Play_half varchar(1)); insert into player_booked values similar to this all of themteam_id | team_group | match_played | won | draw | lost | goal_for | goal_agnst | goal_diff | points | group_position
---------+------------+--------------+-----+------+------+----------+------------+-----------+--------+----------------
    1201 | A          |            3 |   1 |    0 |    2 |        1 |          3 |        -2 |      3 |              3
    1202 | F          |            3 |   0 |    1 |    2 |        1 |          4 |        -3 |      1 |              4
    1203 | E          |            3 |   2 |    0 |    1 |        4 |          2 |         2 |      6 |              2
    1204 | D          |            3 |   2 |    1 |    0 |        5 |          3 |         2 |      7 |              1
    1205 | D          |            3 |   0 |    1 |    2 |        2 |          5 |        -3 |      1 |              4
    1206 | B          |            3 |   1 |    2 |    0 |        3 |          2 |         1 |      5 |              2
    1207 | A          |            3 |   2 |    1 |    0 |        4 |          1 |         3 |      7 |              1
    1208 | C          |            3 |   2 |    1 |    0 |        3 |          0 |         3 |      7 |              1
    1209 | F          |            3 |   1 |    2 |    0 |        6 |          4 |         2 |      5 |              1
    1210 | F          |            3 |   1 |    2 |    0 |        4 |          3 |         1 |      5 |              2
    1211 | E          |            3 |   2 |    0 |    1 |        3 |          1 |         2 |      6 |              1
    1212 | C          |            3 |   1 |    0 |    2 |        2 |          2 |         0 |      3 |              3
    1213 | C          |            3 |   2 |    1 |    0 |        2 |          0 |         2 |      7 |              2
    1214 | F          |            3 |   0 |    3 |    0 |        4 |          4 |         0 |      3 |              3
    1215 | E          |            3 |   1 |    1 |    1 |        2 |          4 |        -2 |      4 |              3
    1216 | A          |            3 |   0 |    1 |    2 |        2 |          4 |        -2 |      1 |              4
    1217 | B          |            3 |   0 |    1 |    2 |        2 |          6 |        -4 |      1 |              4
    1218 | B          |            3 |   1 |    1 |    1 |        3 |          3 |         0 |      4 |              3
    1219 | D          |            3 |   2 |    0 |    1 |        5 |          2 |         3 |      6 |              2
    1220 | E          |            3 |   0 |    1 |    2 |        1 |          3 |        -2 |      1 |              4
    1221 | A          |            3 |   1 |    2 |    0 |        2 |          1 |         1 |      5 |              2
    1222 | D          |            3 |   1 |    0 |    2 |        2 |          4 |        -2 |      3 |              3
    1223 | C          |            3 |   0 |    0 |    3 |        0 |          5 |        -5 |      0 |              4
    1224 | B          |            3 |   2 |    0 |    1 |        6 |          3 |         3 |      6 |              1       insert into player_booked values ('1',1216,'160349','32','NT',1),('1',1216,'160355','45','NT',1),(1207,160159,'69','Y','NT','2'),('1',1216,'160349','78','NT',1),('1',1216,'160355','14','NT',1),(1207,160159,'23','Y','NT','2'),('1',1216,'160349','36','NT',1),('1',1216,'160355','63','NT',1),(1207,160159,'66','Y','NT','2'),('1',1216,'160349','89','NT',1),('1',1216,'160355','93','NT',1),(1207,160159,'2','Y','NT','2'),('1',1216,'160349','31','NT',1),('1',1216,'160355','78','NT',1),(1207,160159,'80','Y','NT','2'),('1',1216,'160349','83','NT',1),('1',1216,'160355','62','NT',1),(1207,160159,'72','Y','NT','2'),('1',1216,'160349','31','NT',1),('1',1216,'160355','48','NT',1),(1207,160159,'80','Y','NT','2'),('1',1216,'160349','91','NT',1),('1',1216,'160355','65','NT',1),(1207,160159,'69','Y','NT','2'),('1',1216,'160349','89','NT',1),('1',1216,'160355','68','NT',1),(1207,160159,'61','Y','NT','2'),('1',1216,'160349','43','NT',1),('1',1216,'160355','61','NT',1),(1207,160159,'77','Y','NT','2'),('1',1216,'160349','65','NT',1),('1',1216,'160355','75','NT',1),(1207,160159,'78','Y','NT','2'),('1',1216,'160349','84','NT',1),('1',1216,'160355','93','NT',1),(1207,160159,'33','Y','NT','2'),('1',1216,'160349','66','NT',1),('1',1216,'160355','80','NT',1),(1207,160159,'2','Y','NT','2'),('1',1216,'160349','55','NT',1),('1',1216,'160355','46','NT',1),(1207,160159,'2','Y','NT','2'),('1',1216,'160349','22','NT',1),('1',1216,'160355','24','NT',1),(1207,160159,'37','Y','NT','2'),(1207,160159,'50','Y','NT','2'),('1',1216,'160349','76','NT',1),('1',1216,'160355','55','NT',1),(1207,160159,'37','Y','NT','2'),(1207,160159,'81','Y','NT','2'),('1',1216,'160349','88','NT',1),('1',1216,'160355','61','NT',1),(1207,160159,'40','Y','NT','2'),(1207,160159,'63','Y','NT','2'),('1',1216,'160349','67','NT',1),('1',1216,'160355','87','NT',1),(1207,160159,'90','Y','NT','2'),('1',1216,'160349','3','NT',1),('1',1216,'160355','3','NT',1),(1207,160159,'34','Y','NT','2'),('1',1216,'160349','45','NT',1),('1',1216,'160355','55','NT',1),(1207,160159,'67','Y','NT','2'),('1',1216,'160349','69','NT',1),('1',1216,'160355','89','NT',1),(1207,160159,'94','Y','NT','2'),('1',1216,'160349','14','NT',1),('1',1216,'160355','72','NT',1),(1207,160159,'74','Y','NT','2'),('1',1216,'160349','88','NT',1),('1',1216,'160355','2','NT',1),(1207,160159,'9','Y','NT','2'),('1',1216,'160349','41','NT',1),('1',1216,'160355','42','NT',1),(1207,160159,'49','Y','NT','2'),('1',1216,'160349','2','NT',1),('1',1216,'160355','42','NT',1),(1207,160159,'75','Y','NT','2'),('1',1216,'160349','77','NT',1),('1',1216,'160355','81','NT',1),(1207,160159,'83','Y','NT','2'),('1',1216,'160349','6','NT',1),('1',1216,'160355','31','NT',1),(1207,160159,'40','Y','NT','2'),('1',1216,'160349','47','NT',1),('1',1216,'160355','78','NT',1),(1207,160159,'86','Y','NT','2'),('1',1216,'160349','6','NT',1),('1',1216,'160355','54','NT',1),(1207,160159,'85','Y','NT','2'),('1',1216,'160349','85','NT',1),('1',1216,'160355','91','NT',1),(1207,160159,'95','Y','NT','2'),('1',1216,'160349','25','NT',1),('1',1216,'160355','83','NT',1),(1207,160159,'16','Y','NT','2'),('1',1216,'160349','64','NT',1),('1',1216,'160355','24','NT',1),(1207,160159,'52','Y','NT','2'),('1',1216,'160349','25','NT',1),('1',1216,'160355','38','NT',1),(1207,160159,'60','Y','NT','2'),(1207,160159,'35','Y','NT','2'),('1',1216,'160349','36','NT',1),('1',1216,'160355','39','NT',1),(1207,160159,'50','Y','NT','2'),(1207,160159,'87','Y','NT','2'),('1',1216,'160349','29','NT',1),('1',1216,'160355','70','NT',1),(1207,160159,'70','Y','NT','2'),(1207,160159,'88','Y','NT','2'),('1',1216,'160349','36','NT',1),('1',1216,'160355','51','NT',1),(1207,160159,'70','Y','NT','2')
go