-- Marek Świderski, nr indeksu 17094
-- praca domowa z laboratorium 5

-- zad. 1
USE Northwind
SELECT OrderID, SUM(Quantity) AS total_quantity
FROM [Order Details]
GROUP BY OrderID

-- zad. 2 (WITH TIES nie robi różnicy)
USE Northwind
SELECT TOP 10 WITH TIES OrderID, SUM(Quantity) AS total_quantity
FROM [Order Details]
GROUP BY OrderID
ORDER BY total_quantity DESC

-- zad. 3
USE Northwind
SELECT CategoryID, COUNT(*) AS summary
FROM Products
GROUP BY CategoryID

-- zad. 4
USE Northwind
SELECT CategoryID, SUM(Quantity) AS summary
FROM Products, [Order Details]
GROUP BY CategoryID

-- zad. 5
USE Northwind
SELECT CategoryID, SUM(Quantity) AS summary
FROM Products, [Order Details]
WHERE CategoryID > 5
GROUP BY CategoryID

-- zad. 6
USE Northwind
SELECT CategoryID, COUNT(Quantity) AS summary
FROM Products, [Order Details]
GROUP BY CategoryID
HAVING COUNT(Quantity) > 1000