blob: 27353a90c69f373a600591e30ecd538c24300117 [file] [log] [blame]
select
name, addr, count(1)
from
table1
group by
name, addr
order by
name, addr;