I would like to get the average value of specific attributes. I have a table with columns like:
ID, P1, E1, Age1, P2, E2, Age2, P3, E3, AverageAgeP, AverageAgeE
Sometimes there is a value for P, sometimes there is value for E - otherwise it's NULL. I would like to calculate the average value...