create temp table from spatial join

create temp table from spatial join.sql

CREATE TEMP TABLE fracking AS
SELECT f.name, f.operator, f.status, f.type, co.county
FROM fractracker f
JOIN co_counties co
ON ST_COVEREDBY(f.geom, co.geom);

-- query on TEMP TABLE to find count per county
SELECT county, COUNT(county) well_count 
FROM fracking
GROUP BY county
ORDER BY well_count desc;