P.I. Works interview question

Indexes, join types, sql questions