1.SQL

SELECT CUS.Name,CUS.LastName,PRO.ProductName,CAT.CategoryID,CAT.CategoryName FROM Customers CUS LEFT JOIN Sales SLS ON CUS.CustomerID=SLS.CustomerID
LEFT JOIN Products PRO ON PRO.ProductID=SLS.ProductID
LEFT JOIN Categories CAT ON CAT.CategoryID=PRO.CategoryID
WHERE CUS.Discount IS NULL
GROUP BY CAT.CategoryID,PRO.ProductName,CUS.Name,CUS.LastName,CAT.CategoryNameC