How i can show all data when using count and where clause in MySql. In my case, I have master data like pict at below.
and i using this query to show count the data.
SELECT body, count(body) from tb_list_data WHERE type ="FAC" AND group by body order by body ASC
and then the result like pict at below
But i want the query result like pict in below.
how i do query to still show all data like that pict even using clause where?