Teradata SQL: The SELECT Statement, Joins, and Subqueries