如何在MySQL查询中使用DISTINCT而不在输出中显示该字段？

I have this MySQL query:

我有这个MySQL查询:

select Region,
CONCAT('$', FORMAT(AVG(sales), 0)) as 'Average_Sales_by_Region', 
count(*) as '# of Dist in state'
from dist, Regions_US
where dist.state=Regions_US.State
group by Region ORDER BY AVG(sales) DESC;
selec