select *,(`price`+`closingPrice`) / 2 AS `avgshareprice` from `tableName`