Gallagher interview question

1.filter mail id using sql query 2.lead and lag