Group it on the StudentId column:
CREATE VIEW A5T7 AS
SELECT (firstname || ' ' || lastname) AS FullName, StudentID, HoursPassed, HoursFailed, (HoursPassed + HoursFailed) AS HoursAttempted
FROM A5
WHERE Upper(Major1)='FIN' OR Upper(Major2)='FIN'
ORDER BY HoursAttempted;
[Edit]
In fact, since there is no join in the query to calculate the sum of values of related records, you don't even need a GROUP BY clause.
I updated the code.
[/Edit]