--Zadanie 1
SELECT COUNT(ProductID) AS iloscProduktow
FROM AdventureWorks2014.Production.Product
SELECT COUNT(ProductCategoryID) AS iloscKategorii
FROM AdventureWorks2014.Production.ProductCategory
SELECT COUNT(ProductSubcategoryID) AS iloscPodkategorii
FROM AdventureWorks2014.Production.ProductSubcategory

--Zadanie 2
SELECT ProductID, Name
FROM AdventureWorks2014.Production.Product
WHERE Color IS NULL

--Zadanie 3
SELECT
SUM(SubTotal) AS Obrót,
YEAR(OrderDate) AS Rok
FROM AdventureWorks2014.Sales.SalesOrderHeader
GROUP BY YEAR(OrderDate)

--Zadanie 4
SELECT COUNT(CustomerID) AS iloscKlientow
FROM AdventureWorks2014.Sales.Customer
SELECT COUNT(BusinessEntityID) AS iloscPracownikow
FROM AdventureWorks2014.Sales.SalesPerson

--Zadanie 5
SELECT
COUNT(PurchaseOrderID) AS IloscTransakcji,
YEAR(OrderDate) AS Rok
FROM AdventureWorks2014.Purchasing.PurchaseOrderHeader
GROUP BY YEAR(OrderDate)

--Zadanie 6
SELECT Product.Name AS NazwaProduktu
FROM AdventureWorks2014.Production.Product
	JOIN AdventureWorks2014.Production.ProductSubcategory ON Product.ProductSubcategoryID = ProductSubcategory.ProductSubcategoryID
	WHERE ProductID NOT IN (SELECT DISTINCT ProductID FROM AdventureWorks2014.Sales.SalesOrderDetail)
GROUP BY ProductSubcategory.ProductCategoryID, Product.Name