PCS Global Tech interview question

1. Joining tables 2. aggregating sql queries