--USE Northwind
-----SOLO DATOS QUE SE ESPECIFICAN
--SELECT  EmployeeID, LastName, FirstName FROM Employees
----Trae todos los datos de la BD
--SELECT * FROM dbo.Employees
-----Solo trae los datos que se especifican en el WHERE
--SELECT  EmployeeID, LastName, FirstName 
--FROM Employees 
--WHERE EmployeeID = 2

--SELECT * FROM dbo.Orders ORDER BY ShippedDate DESC

--SELECT * FROM dbo.Orders WHERE ShippedDate IS  NULL

--SELECT * FROM dbo.Products WHERE UnitPrice > 30 ORDER BY UnitPrice DESC

--SELECT ProductID, ProductName, UnitPrice  FROM dbo.Products

--SELECT CompanyName, Country FROM dbo.Customers WHERE Country = 'Mexico'

-----------INSERT------------------
	SELECT * FROM dbo.Region


	--INSERT INTO dbo.Region
	--        ( RegionID, RegionDescription )
	--VALUES  ( 6,'Es Otra prueba' )

	INSERT INTO dbo.Estudiantes ( nombre_alumno ,edad_estudiante)
	VALUES  ( 'Luis Ignacio' , 17  )

	DELETE dbo.Estudiantes WHERE id_estudiante = 3

	----------------UPDATE-------------------------------
		
		SELECT * FROM dbo.Estudiantes
		UPDATE dbo.Estudiantes 
		SET grupo = 'A'
		WHERE nombre_alumno =  'Luis Ignacio'
		

