PCL Construction Interview Question

The most complex query I worked on and what made it so difficult?