1. --Zadanie 1
2. SELECT COUNT(ProductID) AS iloscProduktow
3. FROM AdventureWorks2014.Production.Product
4. SELECT COUNT(ProductCategoryID) AS iloscKategorii
5. FROM AdventureWorks2014.Production.ProductCategory
6. SELECT COUNT(ProductSubcategoryID) AS iloscPodkategorii
7. FROM AdventureWorks2014.Production.ProductSubcategory
8.  
9. --Zadanie 2
10. SELECT ProductID, Name
11. FROM AdventureWorks2014.Production.Product
12. WHERE Color IS NULL
13.  
14. --Zadanie 3
15. SELECT
16. SUM(SubTotal) AS Obrót,
17. YEAR(OrderDate) AS Rok
18. FROM AdventureWorks2014.Sales.SalesOrderHeader
19. GROUP BY YEAR(OrderDate)
20.  
21. --Zadanie 4
22. SELECT COUNT(CustomerID) AS iloscKlientow
23. FROM AdventureWorks2014.Sales.Customer
24. SELECT COUNT(BusinessEntityID) AS iloscPracownikow
25. FROM AdventureWorks2014.Sales.SalesPerson
26.  
27. --Zadanie 5
28. SELECT
29. COUNT(PurchaseOrderID) AS IloscTransakcji,
30. YEAR(OrderDate) AS Rok
31. FROM AdventureWorks2014.Purchasing.PurchaseOrderHeader
32. GROUP BY YEAR(OrderDate)
33.  
34. --Zadanie 6
35. SELECT Product.Name AS NazwaProduktu
36. FROM AdventureWorks2014.Production.Product
37.         JOIN AdventureWorks2014.Production.ProductSubcategory ON Product.ProductSubcategoryID = ProductSubcategory.ProductSubcategoryID
38.         WHERE ProductID NOT IN (SELECT DISTINCT ProductID FROM AdventureWorks2014.Sales.SalesOrderDetail)
39. GROUP BY ProductSubcategory.ProductCategoryID, Product.Name