SELECT pupil.id, pupil.name ,pupil.surname,mark_value.values,subject.name, teacher.fullname, class.name FROM 
pupil,mark_value,mark,subject, teacher,class,class_pupil_connection 
WHERE pupil.id=class_pupil_connection.pupil_id  AND class.name LIKE"1A" 
AND pupil.id=mark.pupil_id AND mark.mark_id=mark_value.id AND mark.subject_id=subject.id 
AND mark.TEACHER_ID = teacher.id  AND pupil.surname='Pupkin' AND pupil.name='Vasya';

SELECT pupil.name ,pupil.surname,mark_value.values FROM pupil ,mark_value ,mark  WHERE pupil.id=mark.pupil_id AND mark.mark_id=mark_value.id AND mark_value.values in ('5');