Manhattan Associates Interview Question

write a Query of Self Join