SELECT id_ie_, AVG(temp_game.Ein), AVG(temp_game.Eout), AVG(temp_game.res) AS result, temp_game.totgames_,  TypPlt.Name_, Vietas.Vietas_n_, vietas.Adrese_, sum(temp_game.date_res)
From temp_game INNER Join Typplt
          ON temp_game.prg_=typplt.kod_
   INNER JOIN vietas
           ON temp_game.vieta_=vietas.kod_
WHERE temp_game.vieta_=:kod_
Group By temp_game.prg_,  temp_game.totgames_,  TypPlt.Name_, Vietas.Vietas_n_, Vietas.Adrese_, id_ie_
HAVING result>=:avr
ORDER BY result DESC

AVG(temp_game.Ein)

AVG(temp_game.Ein)/sum(temp_game.date_res)