【场景】：分组求和

【分类】：分组查询

分析思路

select 查询结果 [总销售额;客单价]
from 从哪张表中查询数据[销售数据表]

求解代码

#sales_total = sum(sales_price)
select
    sum(sales_price) as sales_total,
    round(sum(sales_price)/count(distinct user_id),2) as per_trans
from sales_tb