สอบถามหน่อยครับ เรื่องการใช้ Count หลายๆครั้งใน 1 Query ครับ

select tb_main.name_re, 
COUNT(name_re) AS Cname ,
COUNT(tb_free.name_re) AS CstatusNull,
COUNT(tb_notfree.name_re) AS CstatusNotNull 
from GoodsKurupan_Data tb_main
left join (select name_re from GoodsKurupan_Data where status='ว่าง') as tb_free on tb_free.name_re = tb_main.name_re
left join (select name_re from GoodsKurupan_Data where status='ไม่ว่าง') as tb_notfree on tb_notfree.name_re = tb_main.name_re
group by tb_main.name_re

strsql = "SELECT name_re, COUNT(CASE WHEN status='เตรียม' THEN 1 ELSE 0 END ) AS หอย, COUNT(CASE WHEN status='แหก' THEN 1 ELSE 0 END ) AS งาม
FROM GoodsKurupan_Data
Group By name_re"

    <table id='fakeGridView' class='myTable' style='width: 100%;'>
        <thead>
            <tr>
                <td>#</td><td>น้ำพริก</td><td>แมงดา</td>
            </tr>
        </thead>
        <tbody>
            <%For i As Integer = 0 To 10 'RealAss Server Data%>
            <tr id='<%=i %>'>
                <% For j As Integer = 0 To 2%>
                <td id='<%=i & j%>'>
                    '<%= "แถว" & i & "สดมภ์" & j%>'
                </td>
                <%Next%>
            </tr>
            <%Next%>
        </tbody>
        <tfoot>
            <tr>
                <td>Total</td><td>สรุป (1)</td><td>สรุป (2)</td>
            </tr>
        </tfoot>
    </table>