擅长:python、mysql、java
<p>不如把它当作一个单选词。像这样:</p>
<pre><code>INSERT INTO temp_avgs(geoid, average)
select cb.geoid, avg(aj.alljobs)
from census_blocks cb join
accessibility_results ar
on cb.geoid = ar.geoid
WHERE ST_contains((select geom from census_cbsa WHERE cbsafp10='%s'), cb.geom) and
ar.deptime BETWEEN '%s' and '%s' AND ar.threshold='%s'
group by cb.geoid;
</code></pre>
<p>我不确定所有列的来源,所以表别名有点猜测。在</p>