Sample SQL

CREATE TABLE PROPERTIES
(
[ID] [INT] IDENTITY(1,1) NOT NULL,
TITLE VARCHAR(MAX),
POPULATION VARCHAR(MAX)
)

INSERT INTO PROPERTIES
(TITLE, POPULATION)
VALUES
('Design By George', '234000'),
('Network Depot', '546000'),
('Renaud Consulting', '898000');

CREATE TABLE AVGPOPULATION
(
[ID] [INT] IDENTITY(1,1) NOT NULL,
popradius INT,
popamount INT,
propertyfk INT
)

INSERT INTO AVGPOPULATION
(popradius, popamount, propertyfk)
SELECT '1', POPULATION, ID
FROM PROPERTIES;