数据分析面试题 求解答

Question

 

Answer 1

1.排名前30

select * from 表名 order by money desc limit 30

2.答案仅供参考，因为如果不是上面一个表的话，可能需要用到表链接

select uid,sum(money),date where count(date)>10 from 表 group by uid,date

3.对用户进行去重，即可得到新增用户

select distinct uid from 表 order by money desc