PCS Global Tech Interview Question

1. Joining tables 2. aggregating sql queries