WF0iKSZf

1DROP TABLE IF EXISTS Sprzedaz
2CREATE TABLE Sprzedaz
3(
4  PracID INT,
5  "Nazwisko, imie" CHAR(100),
6  ProdID INT,
7  "NazwaProduktu" NVARCHAR(50),
8  Rok INT,
9  Liczba INT
10)
11INSERT INTO Sprzedaz
12SELECT
13  soh.SalesPersonID,
14  pers.FirstName + ' ' + pers.LastName,
15  sod.ProductID,
16  prod.Name,
17  YEAR(soh.OrderDate),
18  COUNT(*)
19  FROM Sales.SalesOrderHeader soh
20  JOIN Person.Person pers ON soh.SalesPersonID  = pers.BusinessEntityID
21  JOIN Sales.SalesOrderDetail sod ON soh.SalesOrderID = sod.SalesOrderID
22  JOIN Production.Product  prod ON prod.ProductID = sod.ProductID
23WHERE soh.SalesPersonID IS NOT NULL
24GROUP BY soh.SalesPersonID, sod.ProductID, prod.Name, pers.FirstName, pers.LastName, YEAR(soh.OrderDate);