Select SELECTION_ID, SELECTION, Sum(ODDS * VOLUME_MATCHED)/Sum(VOLUME_MATCHED) _
  As spalte From tabelle Group By SELECTION_ID Order By SELECTION_ID

Select ... Into tabelle1 From tabelle2

Those people who think they know everything are a great annoyance to those of us who do - Isaac Asimov