I have the following data with me
AddId Salaries
10 600
10 50
10 400
10 300
10 200
10 600
20 200
30 200
30 600
30 300
Required output should be
The average of the three highest salaries exceeds 100, only those rows should be visible...wrt each addid.
Thanks,
Ketan