Goldman Sachs Interview Question

They asked about SQL(joins, aggregate functions),