CREATE TABLE counterstrike( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, match_scores INT(50) NOT NULL, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL ); INSERT INTO counterstrike(match_scores, first_name, last_name) VALUES ("0010201", "Kajsa", "Anka"), ("0014500", "Kalle", "Anka"), ("0022101", "Guy", "Bokull"), ("0011100", "Modesty", "Blaise"), ("0450231", "Tom","Cruise"), ("0112352", "Kenneth", "Eklund"), ("0252100", "Olle", "HerrgÄrd"), ("0572000", "Kaj", "Lindeman"), ("1250352", "Angela", "Merkel"), ("2105520", "Mimmi", "Pigg"), ("0894555", "Musse", "Pigg");