Thinking about an SQL statement: Select count (*) from table where filedname0 = value group by filedname1

As shown in the following table: Table
-----------------------------------
Filed0 filed1
-----------------------------------
A 1
A 2
A 2
B 2
B 3
B 3
------------------------------------
Run: Select filed0, count (*) from table where filed1> 2 group by filed0
Expected result:
------------------------------------
B 2
------------------------------------
Run: (select filed0, count (*) from table where filed1> 2 group by filed0) Union (select filed0, 0 from table where filed0 not in (select filed0 from table where filed1> 2) group by filed0) order by filed0
Expected result:
------------------------------------
A 0
B 2
------------------------------------