CREATE TABLE counterstrike(
   id			INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
   forename		VARCHAR(25) NOT NULL,
   surname		VARCHAR(30) NOT NULL,
   scores		INT NOT NULL
   
);

INSERT INTO counterstrike(forename, surname, scores)
VALUES
    ('Mimmi', 'Pigg',2105520),
    ('Angela', 'Merkel',1250352),
    ('Musse', 'Pigg',894555),
    ('Kaj', 'Lindeman', 572000),
    ('Olle', 'Herrgard', 252100),
    ('Kenneth', 'Eklund', 112352),
    ('Tom', 'Cruise', 450231),
    ('Guy', 'Bokull',22101),
    ('Kalle', 'Anka', 14500),
    ('Modesty', 'Blaise', 11100),
	('Kajsa', 'Anka', 10201);