There is someone in the rear seats? The rear A/C is usually off if no one is there.
And to clarify, the front seats are getting cold air, right? So I'm thinking it's not a compressor problem.
And to clarify again, this is a 6 or 7 seater I assume, since you mentioned the third row. They have, at least for my vintage, two compressors. So it could be just a rear A/C compressor problem.