-- INCIA LA BD
USE Northwind
-- veo mis datos y categorias 
SELECT * FROM Products
--1LISTA DEL ID, NOMBRE Y PRECIO DE PRODUCTOS 
SELECT ProductID, ProductName, UnitPrice FROM Products 
--2MUESTRA COMPANY NAME COUTRY DE TODO LOS CONSTUMERS QUE SEAN DE MEXICO 
SELECT CompanyName, Country FROM Customers WHERE Country IN ('Mexico')
-- OBTEN LOS PRODEUCTOS CON PRECIO MAYOR A 30 ORDENADOS DE MAYOR A MENOR 
SELECT ProductName, UnitPrice FROM Products WHERE UnitPrice > 30 ORDER BY UnitPrice DESC
-- Muestra  FristName, LastName,Title de los employees, ordenados por los apellidos 
SELECT FirstName, LastName, Title FROM employees Order By LastName ASC
--TRAE LOS 10 PEDIDOS MAS RECINTES OrderID, CustomerID, OrderDate
SELECT TOP 10 OrderID, CustomerID, OrderDate FROM Orders ORDER BY OrderDate DESC;
-- Lita de Productos unitsstock = o
SELECT ProductName FROM Products WHERE UnitsInStock = 0
-- Muestra CompanyNAme Phone de suppliers que country sea de usa o uk
SELECT CompanyName, Phone, Country FROM Suppliers WHERE Country IN ('USA', 'UK')
-- MUESTRA OrderId, OrderDate, RequiredDate, ShippedDate de los pedidos no enviados 
SELECT OrderId, OrderDate, RequiredDate, ShippedDate FROM Orders WHERE ShippedDate IS NULL






