Bitwise Interview Question

Asked about SQL (from basic to Advanced concepts)