Hi
I have a few criteria:
<tbody>[TR]
[TD]Store[/TD]
[TD]Postcode[/TD]
[TD]Age[/TD]
[/TR]
[TR]
[TD]store1[/TD]
[TD]1234[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]store1[/TD]
[TD]1234[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]store1[/TD]
[TD]1236[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]store2[/TD]
[TD]4556[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]4557[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]4558[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]
[TD]6771[/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]6772[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]6772[/TD]
[TD]39[/TD]
[/TR]
</tbody>[/TABLE]
My question is: in this case what is the average age of store1 if the postcode is 1234
I have a few criteria:
- store
- postcode
- average
<tbody>[TR]
[TD]Store[/TD]
[TD]Postcode[/TD]
[TD]Age[/TD]
[/TR]
[TR]
[TD]store1[/TD]
[TD]1234[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]store1[/TD]
[TD]1234[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]store1[/TD]
[TD]1236[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]store2[/TD]
[TD]4556[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]
store2
<strike></strike>[/TD]
[TD]4557[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]
store2
<strike></strike>[/TD]
[TD]4558[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]
store3
[/TD][TD]6771[/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]
store3
<strike></strike>[/TD]
[TD]6772[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]
store3
<strike></strike>[/TD]
[TD]6772[/TD]
[TD]39[/TD]
[/TR]
</tbody>[/TABLE]
My question is: in this case what is the average age of store1 if the postcode is 1234