Aledade Interview Question

How would optimize a slow running SQL query?