name varchar(10),

              zip   char(7),

insert into t1 values(2, "bbb","111-222","seoul kangdong gu");

insert into t1 values(3, "ccc","111-333","seoul kangseo gu");

insert into t1 values(4, "ddd","222-222","daegu kangdong gu");

          2 bbb        111-222 seoul kangdong gu

          3 ccc        111-333 seoul kangseo gu

          4 ddd        222-222 daegu kangdong gu

// zip code 앞 3자리로 grouping 하여 소계를 내는 것입니다

select substr(zip,1,3), count(member_id) .

from t1

group by 1

union all

select "total", count(member_id)

from t1;

(expression)          (count)

111                         3

222                         2

total                        5