SELECT 
CONCAT(std.last_name_std,' ',std.first_name_std) as name_std,
CONCAT(sec.name_set,' ',lvl.name_lvl,' ',clg.name_clg) as curso,
CONCAT(grd.last_name_grd,' ',grd.first_name_grd) as grd_name
FROM student std
JOIN student_by_course stc ON std.serial_std = stc.serial_std
JOIN course crs ON stc.serial_crs = crs.serial_crs
JOIN level_section_year lsy ON lsy.serial_lvl = crs.serial_lvl AND lsy.serial_set = crs.serial_set AND lsy.serial_scy = crs.serial_scy
JOIN level lvl ON crs.serial_lvl = lvl.serial_lvl
JOIN section sec ON sec.serial_set = crs.serial_set
JOIN class_group clg ON clg.serial_clg = crs.serial_clg
JOIN student_guardian stg ON std.serial_std = stg.serial_std
JOIN guardian grd ON stg.serial_grd = grd.serial_grd
WHERE crs.serial_scy = 3
AND stc.status_stc = 'ACTIVE'
AND std.status_std = 'ACTIVE'
AND stg.status_stg = 'ACTIVE'
AND grd.status_grd = 'ACTIVE'
AND grd.alumnus_grd = 'YES'
ORDER BY lsy.order_lsy