enter image description here (SQL subquery problem)

enter image description here (SQL subquery problem)

See the same result came without using the subquery. So why should I use this complicated subquery, when I can easily get the desired output using this simple query?