Please write the SQL Querie Assume territory names are uniqu

Please write the SQL Querie

Assume territory names are unique. List the IDs and Names of the salespeson who work in the central of SouthEst territores. Use the join facility to answer. DO NOT USE SUBQUERIES (SQL Teradata)

Tables

SalesPerson_T

Territory_T

Solution

Select spt.SalesPerson_ID,spt.SalesPerson_Name

from SalesPerson_T spt

inner join Territory_T tt

on tt.Territory_ID = spt.Territory_ID

where tt.Territory_Name like \'%central of SouthEst%\'