哪个查询在性能SQL服务器方面会更好

I have written two queries and I need help to know which one will be better in term of performance. Both do the same thing. Please also advise if you have better a way of writing the queryI have written two queries and I need help to k