高手进来，求SQL语句！

Question

SELECT 姓名,sum(金额) FROM [DATA] where 日期 between '2007-06-01' 
and '2007-06-10'

Answer 1

SELECT 姓名,sum(金额) FROM [DATA] group by 姓名 where 日期 between '2007-06-01'
and '2007-06-10'

Answer 2

SELECT 姓名,sum(金额) FROM [DATA]  where 日期 between '2007-06-01'
and '2007-06-10'
group by 姓名