Fractal interview question

SQL query for joints , limit, max min etc