hi,
I have a following table data-

city region issue value
c1 north i1 y
c1 north i2 y
c2 north i1 n
c2 north i2 y
c3 south i1 y
c3 south i2 n
c4 east i1 n
c4 east i2 n

This table has value for each issue in every city.
How can I create a report from this which looks like-

region issue count(yes)
north i1 2
north i2 1
south i1 1
south i2 0
east i1 0
east i2 0


Please help/ideas for sql query

select region, issue, count(*) from <table> where value = y
union
select region, issue, count(*) from <table> where value = n