i have table like this
I want to calculate the amount of data using the column, for example in the last column type "poc" totaling 3,so i want create query where result type "poc" result 3.
how to count total as type in database?
I think you want
select type, count(*) from t group by type;