下面的sql 语句的编写

Question

题目描述

查询成交表a中的城市city的成交金额大于0的购买人数(buyer_id)和成交金额(amt)
city buyer_id order_id amt
a 1 1 100
a 1 2 100
b 2 3 100
b 3 4 20
c 4 5 0

Answer 1

select count(distinct buyer_id), sum(amt) from 表a where amt > 0 group by city