Teradata Interview Question

Mainly the SQL queries as the position is for the database