Gallagher Interview Question

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