I have two columns of data containing about 5 numbers in each column. What I need to do is drop the two lowest numbers, and average the next 3 lowest numbers. Here is an example

Assignment 1 Assignment 2
10 8


9 10
5 7
9 11


So what I would need to do is somehow drop 7 and 5(2 lowest) and average 8, 9 and 9 (the next 3 lowest) using a query. Thanks