Teradata interview question

Interview was technical and scenario based too.