Error code: 1248 Every derived table must have its own alias, 1248 derived

Error code: 1248 Every derived table must have its own alias, 1248 derived

1. Error description

1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT stu_id, (SELECT stu_name FROM t_student_info t WHERE t. stu_id = t. stu_id) stu_name FROM (select sum (CASE course WHEN 'then .. error code: 1248 Every derived table must have its own alias execution time: 0 sec Transfer Time: 0 sec total time consumed: 0 sec

2. Error cause

SELECT stu_id, (SELECT stu_name FROM t_student_info t WHERE t. stu_id = t. stu_id) stu_name FROM (select sum (CASE course WHEN 'mate' THEN Score ELSE 0 END) mathematics, SUM (CASE course WHEN 'chine' THEN score ELSE 0 END) language, SUM (CASE course WHEN 'then score ELSE 0 END) English, stu_id FROM t_score_info group by stu_id)

3. Solution