Whenever you're ready, walk me through how you'd approach this.
Explain the various ways of optimizing SQL queries.