Pregunta de entrevista de Wise

Complex SQL joins mostly, some basic coding