使用SUM值创建视图

I am not sure how to approach this, I want to create a viewThe columns are FullName, StudentID, HoursPassed, HoursFailed and HoursPassed+HoursFailed of students majoring in Finance. BUT my column headings need to be FullName, StudentID, HoursPassed, HoursFailed and HoursAttemptedSo far I have: CREATE VIEW A5T7 AS SELECT (firstname || ' ' || lastname) AS "FullName", StudentID, HoursPassed, HoursFailed, (HoursPassed + HoursFailed as sum) AS HoursAttempted FROM A5 GROUP BY Upper(Major1='FIN'), Upper(Major2='FIN') ORDER BY HoursAttempted;I am pretty sure my query is wrong, somewhere. I just don't know how to approach the Heading Name and the SUM value. Also my GROUP BY doesn't seem right. 解决方案 这篇关于使用SUM值创建视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！