I'm new in mysql. I want to ask something about get average value from one row in mysql when have a null or zeros value on them.
the image below assuming my table
And I want to get the average from each column p_01,l_01,p_02,l_01,p_03,l_03. How i can do that in mysql query..??
or how to use (count query) in one row to get the value from column p_01,l_01,p_02,l_02.... p_n,l_n. I will use that count value for division operation.
Thank You in advance. Best Regards.