01. Write a query to display the sales person ID, territory ID, and territory name of all the sales persons in the following format.
select 'person Id'=salesPersonID,
'territory ID'=s.TerritoryID,Name
from sales.salesperson s join
sales.salesterritory t
on s.territoryID = t.territoryID
No comments:
Post a Comment