Error code: 1054 Unknown column & #39; course & #39; in & #39; field list & #39;, 1054 column

Error code: 1054 Unknown column 'Course' in 'field list', 1054 column

1. Error description

1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT stu_name, course, score FROM t_student_info s LIMIT 0, 1000 error code: 1054 Unknown column 'Course' in 'field list' execution time: 0 sec Transfer Time: 0 sec total time consumed: 0 sec

2. Error cause

SELECT stu_name, course, score FROM t_student_info s AND t_score_info SC WHERE s. stu_id = SC. stu_id GROUP BY stu_id

3. Solution