Firstsorted value acts similar to Aggregate functions, so every field which is outside of firstsorted value must go inside the group by clause.
Based on your requirement try below steps
firstsortedvalue(lender_offer_id,-lender_offer_id) as Newlender
group by user_id;
Later add other fields as required and then drop the table,
Try to use this and see if it works..