Bitwise interview question

Asked about SQL (from basic to Advanced concepts)