Sql查询选择每个不同的最后一行以及使用内部联接检索的其他列

I'm starting with sql language so I'll try to specify my problem at my very best. I've been reading other questions, but no one seems to fit for me. So...I'm starting with sql language so I'll try to s