Teradata interview question

Mainly the SQL queries as the position is for the database