Teradata interview question

Questions on SQL