Select student s_id, student s_name, count_course, sum_score
The from student
Left the join
(select count (score. C_id) as count_course, sum (score. S_score) as sum_score from score) as a
On student. S_id=score. S_id
Group by student. Sid, student. S_name;