Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

DROP TABLE IF EXISTS Police_Stations;
DROP TABLE IF EXISTS Crime_Incidents_in_2020;
DROP TABLE IF EXISTS Neighborhood_Clusters;

CREATE TABLE Police_Stations (
geom GEOMETRY);
INSERT INTO Police_Stations VALUES
('POINT(-4.511313215966299 54.226049002815465)'),
('POINT(-4.531140105004385 54.22632496805246)');

CREATE TABLE Crime_Incidents_in_2020 (
geom GEOMETRY);
INSERT INTO Crime_Incidents_in_2020 VALUES
('POINT(-4.528951422448233 54.23435224028334)'),
('POINT(-4.5148322741938385 54.22858279615472)'),
('POINT(-4.528007284874991 54.228331932463774)'),
('POINT(-4.525561110253409 54.23317333247795)'),
('POINT(-4.515542092916038 54.35729764093922)');

CREATE TABLE Neighborhood_Clusters (
nbh_names TEXT,
geom GEOMETRY);
INSERT INTO Neighborhood_Clusters VALUES
('Injebreck','POLYGON((-4.54277885370415 54.239901195450884,-4.503983382512744 54.239901195450884,-4.503983382512744 54.22525221811109,-4.54277885370415 54.22525221811109,-4.54277885370415 54.239901195450884))'),
('Jurby','POLYGON((-4.528931680318382 54.36269901545344,-4.506615701314476 54.36269901545344,-4.506615701314476 54.35389641114523,-4.528931680318382 54.35389641114523,-4.528931680318382 54.36269901545344))');

2 rows affected

5 rows affected

2 rows affected

nbh_names	pol	cri
Injebreck	2	4
Jurby	0	1