Suzy Interview Question

describe various optimizations for a SQL query