将查询结果翻译成英文；查询每天每人的成功数量

testcase

user

SELECT crtUser,(CASE  status 
WHEN'成功' THEN 'success' 
WHEN'失败' THEN 'failed' 
END)  'status'
FROM testCase

SELECT a.UserName, COUNT(a.UserId) AS '成功的数量', DATE_FORMAT(b.crttime, '%Y-%m-%d') AS '日期' FROMUsera RIGHT JOIN testCase b ON a.UserId = b.crtUser GROUP BY a.UserName, DATE_FORMAT(b.crttime, '%Y-%m-%d')