Pinterest interview question

SQL hard consisting on joining multiple tables, window function in order to calculate a metric.