xxxxxxxxxx
SELECT s_marks.studentid, p_details.pname FROM s_marks
JOIN subjects ON s_marks.subjectid = subjects.subjectid
JOIN marks_details ON subjects.total_marks = marks_details.total_marks
JOIN p_details ON p_details.pid = s_marks.professorid
WHERE marks_details.practical = '50';