UST interview question

Teradata SQL questions on joins, indexes