Wise interview question

Complex SQL joins mostly, some basic coding