ParentPay Interview Question

How do you identify and optimize slow SQL queries?