SELECT * FROM Orders WHERE DATEDIFF(day, OrderDate, ShippedDate) > 7
SELECT * FROM Orders WHERE DATEDIFF(day, RequiredDate, ShippedDate) > 0
SELECT * FROM Employees WHERE HireDate>'1/07/1993'
SELECT c.OrderID FROM Employees d, Orders c WHERE DATEPART(year, d.HireDate) = 1994 AND d.EmployeeID=c.EmployeeID
SELECT year(o.OrderDate), month(o.OrderDate), sum(od.Quantity*od.UnitPrice*(1-od.Discount)) from Orders o join [Order Details] od on o.OrderID=od.OrderID GROUP BY year(o.OrderDate), month(o.OrderDate) ORDER by 1,2
SELECT * FROM Orders c, [Order Details] d, Products f WHERE DATENAME(MONTH, c.OrderDate) = 'July'
AND DATEPART(YEAR, c.OrderDate) = 1997 AND DATEDIFF(day, c.OrderDate, c.ShippedDate) > 15
AND d.OrderID=c.OrderID AND d.ProductID=f.ProductID and f.ProductName like '%g%'
SELECT SUM(c.UnitPrice) FROM Orders d, [Order Details] c ORDER BY d.OrderDate
SELECT CompanyName FROM Customers C WHERE NOT EXISTS(SELECT OrderID FROM Orders O WHERE C.CustomerID = o.CustomerID)
-- 1ERA

SELECT CompanyName FROM Customers WHERE CustomerID NOT IN(SELECT DISTINCT CustomerID FROM Orders O)
SELECT P.ProductName FROM Products P WHERE NOT EXISTS(SELECT * FROM Or
/*SELECT c.CompanyName as 'Cliente', COUNT(DISTINCT o.OrderID) as 'Cantidad',
SUM(od.Quantity*od.UnitPrice*(1-od.Discount)) as 'Suma' FROM [Order Details] od, Orders o,Customers c
WHERE od.OrderID = o.OrderID AND o.CustomerID= c.CustomerID GROUP BY c.CompanyName HAVING SUM(OD.UnitPrice*Quantity*(1-OD.Discount))>100000 order by 1
*/
--SELECT MAX(unitprice) as 'MAXIMO', MIN(unitprice) as 'MINIMA' FROM Products
--SELECT MIN(unitprice) FROM Products
-- select anidado
/*SELECT ProductName, unitprice FROM Products WHERE UnitPrice = (SELECT MAX(p.unitprice) FROM Products p)
UNION
SELECT ProductName, unitprice FROM Products WHERE UnitPrice = (SELECT MIN(p.unitprice) FROM Products p)
*/
/*SELECT s.CompanyName, p.ProductName, c.CategoryName FROM Suppliers s
JOIN Products p ON s.SupplierID=p.SupplierID
JOIN Categories c ON p.CategoryID=c.CategoryID
ORDER BY 1
*/
SELECT p.CompanyName, c.OrderID
FROM Customers p JOIN Orders c ON c.CustomerID = p.CustomerID
SELECT p.CompanyName, c.OrderID
FROM Customers p LEFT JOIN Orders c ON c.CustomerID = p.CustomerID
SELECT p.CompanyName, c.OrderID
FROM Customers p JOIN Orders c ON c.CustomerID = p.CustomerID
select c1.CompanyName FROM Customers c1 WHERE c1.CompanyName NOT IN(SELECT DISTINCT c.CompanyName FROM Customers c JOIN Orders o ON c.CustomerID = o.CustomerID)
SELECT c.CompanyName FROM Customers c LEFT JOIN Orders o ON c.CustomerID = o.CustomerID WHERE o.OrderId is NULLders O,[Order Details] OD WHERE O.OrderID=OD.OrderID AND OD.ProductID=P.ProductID AND YEAR(O.OrderDate)=1998)
SELECT ProductName FROM Products WHERE ProductName NOT IN(SELECT P.ProductName FROM Orders O, [Order Details] OD, Products P WHERE O.OrderID=OD.OrderID AND OD.ProductID=P.ProductID AND YEAR(O.OrderDate) = 1998)
SELECT * FROM Orders O where DATEPART(YEAR, O.OrderDate) <> 1998 AND NOT EXISTS(SELECT OrderID FROM [Order Details])
SELECT P.ProductName FROM Products P JOIN Categories C ON P.CategoryID=C.CategoryID WHERE P.Discontinued = 0
AND C.CategoryName = 'Seafood' AND P.ProductID not in(SELECT od.ProductID FROM Orders O, [Order Details] od WHERE O.OrderID = od.OrderID AND O.OrderDate BETWEEN '960801' AND '960815') -- 6 FILAS
-- NOT EXISTS
SELECT P.ProductName FROM Products P WHERE P.Discontinued = 0 AND P.CategoryID = 8 AND NOT EXISTS(SELECT * FROM [Order Details] OD, Orders O WHERE O.OrderID = OD.OrderID AND
OD.ProductID = P.ProductID AND O.OrderDate BETWEEN '960801' AND '960815')