create table TBL_personnel(ID INT AUTO_INCREMENT PRIMARY KEY,FirstName VARCHAR(25),LastName VARCHAR(60),ADT CHAR(8) UNIQUE,Gender ENUM('M','F') NOT NULL,MonthlySalary DECIMAL(10,2) DEFAULT 0.00,Coordinates POINT);
insert into TBL_personnel(FirstName,LastName,ADT,Gender,MonthlySalary,Coordinates) values('George','Georgiou',11111111,'M',1111.11,ST_GeomFromText('POINT(23.4670 22.8500)')),
('Alexandra','Alexandrou',10101010,'F',10101.10,ST_GeomFromText('POINT(33.4670 22.8500)')),
('John','Johnson',22222222,'M',2222.22,ST_GeomFromText('POINT(36.4670 22.8500)')),
('Maria','Mariadou',33333333,'F',3333.33,ST_GeomFromText('POINT(36.4670 26.8500)')),
('Nick','Nickolaidis',44444444,'M',4444.44,ST_GeomFromText('POINT(36.4670 29.8500)')),
('Petra','Petridou',55555555,'F',5555.55,ST_GeomFromText('POINT(28.4670 29.8500)')),
('Spyros','Spyropoulos',66666666,'M',6666.66,ST_GeomFromText('POINT(38.4670 31.8500)')),
('Panagiota','Panagiotopoulou',77777777,'F',7777.77,ST_GeomFromText('POINT(38.7870 31.8500)')),
('Kwstas','Kwnstantinidis',88888888,'M',8888.88,ST_GeomFromText('POINT(38.4670 25.8500)')),
('Tatiana','Tatianidou',99999999,'F',9999.99,ST_GeomFromText('POINT(28.7870 31.8500)'));