05. Write a query to display the order number, territory name, order date, and the quarter in which each order was placed in the following format.
select salesOrderID,'territory name'= name
OrderDate, Quarter = detepart (qq,OrderDate)
from sales.salesOrderHeader s
join sales.salesTerritory t
on s.TerritoryID =t.TeriitoryID
No comments:
Post a Comment