I want to count distinct values in multiple column and show the results in separate rows

Question

I'm kinda new to SQL and working on a dataset where I need to count 1,0 or Y,N flags in each of the column and give a resultant count column. To give an example, here's what the data looks like:

Flag1	Flag2	Flag3	Flag4
N	Y	N	Y
Y	Y	Y	Y
N	N	N	N
Y	Y	N	N

Here's what I want:

Flag1	Flag2	Flag3	Flag4	COUNT
N				2
Y				2
	N			1
	Y			3
		N		3
		Y		1
			N	2
			Y	2

Answer 1

There is a much simpler way to calculate this using the GROUP BY GROUPING SETS function:

WITH sample_data AS (
  SELECT * 
    FROM (VALUES 
  ('N', 'Y', 'N', 'Y'),
  ('Y', 'Y', 'Y', 'Y'),
  ('N', 'N', 'N', 'N'),
  ('Y', 'Y', 'N', 'N')) T(Flag1, Flag2, Flag3, Flag4)
)
SELECT Flag1, Flag2, Flag3, Flag4, COUNT(*) AS COUNT
  FROM sample_data
 GROUP BY GROUPING SETS (Flag1, Flag2, Flag3, Flag4)
 ORDER BY Flag1, Flag2, Flag3, Flag4;

Result:

FLAG1	FLAG2	FLAG3	FLAG4	COUNT
N				2
Y				2
	N			1
	Y			3
		N		3
		Y		1
			N	2
			Y	2