SELECT surname_students, name_students, middle_students FROM truancy, students 
WHERE date_truancy LIKE '%янв.%'
AND id_students_truancy = ( SELECT link_students_groups FROM groups WHERE name_groups = 'П1-2' 
AND year_groups = '2000/2001' 
AND speciality_number_groups = '2203' );

SELECT surname_students, name_students, middle_students FROM truancy, students 
WHERE date_truancy LIKE '%янв.%'
AND id_students_truancy =  7 

SELECT s.id_students, s.surname_students, s.name_students, s.middle_students FROM truancy s0, students s, groups g
WHERE g.name_groups = 'П1-2'
and g.year_groups = '2000/2001'
and g.speciality_number_groups = '2203'
and s0.date_truancy LIKE '%сент.%'
AND s0.id_students_truancy = s.id_students

SELECT s.id_students, s.surname_students, s.name_students, s.middle_students 
FROM truancy s0, students s, groups g
WHERE g.name_groups = 'П1-2'
and g.year_groups = '2000/2001'
and g.speciality_number_groups = '2203'
and g.link_students_groups = s.id_students
and s0.date_truancy LIKE '%сент.%'
AND s0.id_students_truancy = s.id_students