title: closest to average value SQL
body: <p>I am looking for a query to get the closest value exists to the average of all values.
  for example,
  I have in column A the values - 1 , 2, 8
  The average is 3.667 . So i want the query to return 2 since it is the closest to the average value.</p>