A contact list needs email first, then name. Which details would you send, and in which order?
The list after SELECT chooses the result columns and their order. Choosing columns does not filter rows.