大家帮我看一下这段代码有啥问题,

--查询本周的上机人员的姓名,总费用,并按照姓名分组
select username、sum(fee)as 总费用 from card inner join record on card.id=record.cardid group by username where datediff(week、endtime、getdate())=0

很多中文的符号,括号
修改后的你试试


-- 查询本周的上机人员的姓名、总费用,并按照姓名分组
SELECT username, SUM(fee) AS 总费用
FROM card
INNER JOIN record ON card.id = record.cardid
WHERE DATEDIFF(WEEK, endtime, GETDATE()) = 0
GROUP BY username;