Kaiser Permanente interview question

SQL joins and other table manipulations