Pinterest Interview Question

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