SELECT st2.s_id,st2.s_name,c2.c_name,sc2.s_score FROM student st2
LEFT JOIN score sc2 ON sc2.s_id=st2.s_id
LEFT JOIN course c2 ON c2.c_id=sc2.c_id
WHERE st2.s_id IN(
SELECT st.s_id FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
GROUP BY st.s_id HAVING MIN(sc.s_score)>=70)
ORDER BY s_id
Processed:
0.025, SQL:
8
