SELECT MAX(Academic_Credentials) AS TopAcademic,Education_ID,Rc_ID FROM Rc_Education_Info WHERE Rc_ID in(SELECT Rc_ID FROM Rc_Info WHERE datediff(day,Rc_Ureg_Date,getdate())<=42) group by Education_ID,Rc_ID having MAX(Academic_Credentials)>4 order by TopAcademic desc
FROM Rc_Education_Info
WHERE Rc_ID in(SELECT Rc_ID FROM Rc_Info WHERE datediff(day,Rc_Ureg_Date,getdate())<=42)
group by Education_ID,Rc_ID
having MAX(Academic_Credentials)>4
order by TopAcademic desc