Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* zadanie 5 */
- -- ilość wykonanych transakcji w poszczególnych latach
- select count(SalesOrderID) as sprzedane, zamówione, YEAR(OrderDate) as rok
- from AdventureWorks2014.Sales.SalesOrderHeader,
- (select count(PurchaseOrderID) as zamówione,
- YEAR(OrderDate) as rok
- from AdventureWorks2014.Purchasing.PurchaseOrderHeader
- group by YEAR(OrderDate)
- ) as query1
- group by YEAR(OrderDate), rok, zamówione
- having YEAR(OrderDate) = rok
- order by YEAR(OrderDate) asc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement