Broadridge interview question

Basic SQL questions(using jins,group by and sub queries),previous project experience.