Broadridge Interview Question

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