Suzy interview question

describe various optimizations for a SQL query