What are the key best practices for writing select statements in X++? Cover the use of field lists, firstOnly, group by, exists join, and why you must avoid method calls in the where clause and nested selects in loops.