I'm trying to find all the geography points that are contained in a geography polygon, let say all the traffic lights within a given city or neighborhoods,
how can i convert this working st_intersect query to work with contained and remain with geographies not geometries
select count(*) from table1
where table1.UniqueID in (
SELECT table1.UniqueID
FROM table1 INNER JOIN table2 ON ST_Intersects(table1.point, table2.polygon)
where table2.UniqueID = 2);