Demo entry 6691721

postgresql

   

Submitted by anonymous on Jan 13, 2018 at 08:10
Language: PostgreSQL SQL dialect. Code size: 251 Bytes.

SELECT t1.ctprvn_cd,
       t1.ctp_kor_nm,
       t2.pop15,
       t1.the_geom
FROM tl_scco_ctprvn t1,

  (SELECT sido_nm,
          sum(pop15) AS pop15
   FROM population_1960_2015_m
   GROUP BY sido_nm) t2
WHERE t1.ctp_kor_nm = t2.sido_nm;

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).