SQL Query

[mohanm]

Can anybody solve my problem
here the table contents

f1 f2 f3
-----------
1 2 4
2 4 6
3 5 7
4 3 6

i want all fields along with count of whose value > 2

result should be

f1 - 2 (it has only 2 numbers greater than 2)
f2 - 3 (it has only 3 numbers greater than 2)
f3 - 4 (it has only 4 numbers greater than 2)

i'ld appreciate very much if anybody could help me
thanks in advance.

[Traci Thomason]

((Count(tblname.F1))>2)