SQL Server to PostgreSQL

As this looks like an exam question, how would you approach this problem?