有大佬会做这个面试题吗？

没什么啊 就一些约束条件啊 这个公司面试过了底薪多少啊

SELECT A.id ,
name as '用户姓名',
min(B.invest_date) as '首笔投资时间',
c.amount as '首笔投资金额',
max(B.invest_date) as '最后一笔投资时间',
d.amount as '首笔投资金额',
sum(B.amount) as '总金额'
from member A,invest B ,
(select a.* from invest a,
(SELECT uid,MIN(invest_date) as b_date from invest GROUP BY uid) b where a.invest_date=b.b_date) c,
(select a.* from invest a,
(SELECT uid,Max(invest_date) as b_date from invest GROUP BY uid) b where a.invest_date=b.b_date) d
WHERE A.id=B.uid and A.id=c.uid and A.id=d.uid GROUP BY A.name;

简单分组啊