求助 SQL语句

SELECT foliono, GroupNo, COUNT(BlockNo) AS ZCOUNT, BlockNo
from GuestFolios
GROUP BY BlockNo, GroupNo, FolioNo

效果如下：
    foliono  GroupNo  ZCOUNT  BlockNo
3 0 1 0
4 0 1 0
12 0 1 0
13 13 1 4
27 13 1 26
28 13 1 26
29 13 1 26
42 0 1 41
44 0 1 43

这个不是我要的效果 ，我需要按BlockNo分组 ，如：BlockNo为26的分一组，为0的分一组，并且取出Count(BlockNo),请高手指教下。

---

SQL code:
??
SELECT BlockNo, COUNT(BlockNo) AS ZCOUNT
from GuestFolios
GROUP BY BlockNo

---

SQL code:
select
BlockNo,count(1)
from
tb
group by
BlockNo

---

給點
原始數據+結果

---

你的需求到底是什么？
SELECT BlockNo, COUNT(BlockNo) AS ZCOUNT
from GuestFolios
GROUP BY BlockNo

或者

select t1.foliono,t1.GroupNo,t2.ZCOUNT,t1.BlockNo
from
(SELECT foliono, GroupNo, COUNT(BlockNo) AS ZCOUNT, BlockNo
from GuestFolios
GROUP BY BlockNo, GroupNo, FolioNo
)as t1
join
(SELECT BlockNo, COUNT(BlockNo) AS ZCOUNT
from GuestFolios
GROUP BY BlockNo
)as t2