select *,(speed_avg+credit_avg+service_avg+ad_num_avg)/4 as all_avg from (
select A.league_name,A.league_about,avg(speed) as speed_avg,avg(credit) as credit_avg,avg(service) as service_avg,avg(ad_num) as ad_num_avg from sent_league A
inner join sent_comment B On A.id=B.league_id
group by A.league_name,A.league_about
)AA
order by all_avg desc
limit 10