--SELECT * from world_geometry where name = 'norway'

/*DECLARE @norway geometry
SELECT @norway = geom FROM world_geometry where NAME = 'Norway'
SELECT * FROM world_geometry where geom.STTouches(@norway) = 1*/

--SELECT geom.STConvexHull() from world_geometry where name = 'norway'

/*DECLARE @norway geometry
SELECT @norway = geom FROM world_geometry where NAME = 'Norway'
select geom.STUnion(@norway) FROM world_geometry where name = 'denmark'*/

select *, kerry_PCT/100 AS FillColor from election

--SELECT geom, fillcolor=0 FROM world_geometry where geom.STContains(@king)=1
--union all
--select @king, fillcolor = 0.5


SELECT * FROM election where NAME = 'king'
DECLARE @king geometry
SELECT @king = geom FROM election2 where NAME = 'king'
--select @king




--select nor2.* from nor2
--join nor1 on nor2.geom.MakeValid().STWithin(nor1.geom.MakeValid()) = 1
--where nor1.name_1 = 'oppland'

select * from world_geometry