Admin/Moderator, requires your attention here please..!!
Solution uploaded as per desired result set.
However, IMO, "Min Average State Production" should be computed as the average of the 'minimum' production per state like its computed for "Max Average State Production".
However in the former, its computed as the overall average of the production per state. So the column value doesn't matches with the column header title in actual sense...!! (marked in the image)
Anyways solution provided to get the desired results.