Type table has three columns machine, material , store
select machine, material , count(*) as Counting from Type where Store ='East' group by Material
the above query returns zero no rows , then how to return defalt row
like
Machine Material Counting
A Diode 0