You can try something like following-
select cq.QuoteID, cq.LOBID, cu.UserName, q.ProcessedDate, cq.AgentStatus ,q.PolicyExpiredDate, q.Make,q.Model ,t.Remainder
from tr_CRM_QuoteInfo cq left join tr_QuoteInfo q on q.QuoteID = cq.QuoteID
left join tr_CRM_Users1 cu on cu. UserID = cq.AssignTo
left join (
select Agent_QID AS QID, Remainderdes AS Remainder, MAX(Rdate) as RemainderDate from tbl_TimeAlrets group by Agent_QID ,Remainderdes
) t on cq.QuoteID = t.QID where (q.ProcessedDate > DATEADD(dd, -1, DATEDIFF(dd, 0, GETDATE())) and q.ProcessedDate < CONVERT(date, getdate())) and (cq.AgentStatus like '%bought%' or cq.AgentStatus like '%Not Inte%')
If it doesn't help, please let me know.
Thanks