Optimizing SQL queries

Reference notes: