Sube en este medio las evidencias del curso. Puedes subir imágenes en formato JPG o PNG no mayores a 1 MB, y videos en formato AVI o MPG
Evidencias 5o Prog Vesp Base de Datos
Sube en este medio las evidencias del curso. Puedes subir imágenes en formato JPG o PNG no mayores a 1 MB, y videos en formato AVI o MPG
desarrollo web y de software, el análisis de datos, la automatización de tareas, el desarrollo de videojuegos y la creación de aplicaciones
PHYTON puede ser utilizado en el area de desarrolo de software, desarrolo de datos, analisis, la creacionde videojuegos y automatizacion de tareas.
SELECT Nombre, Salario, COUNT(*) AS empleados FROM empleados WHERE Salario 1300 AND Sexo = ‘M’ GROUP BY Salario;
SELECT Nombre, Salario, COUNT(*) AS empleados FROM empleados WHERE Salario > 1300 AND Sexo = ‘M’ GROUP BY año;
SELECT Sexo, COUNT(*)as FROM empleados WHERE Sexo = ‘F’ AND Salario > 1300 GROUP BY Sexo;
SELECT Sexo, COUNT(*)as FROM empleados WHERE Salario 1300 GROUP BY Sexo;
SELECT YEAR(Fecha_Nacimiento) AS año, COUNT(*) as Total FROM empleados GROUP BY YEAR(fecha_nacimiento) ORDER BY Año_Nacimiento;
valeriaalday
SELECT Sexo, COUNT(*) FROM Empleados WHERE Sexo = ‘F’ AND Salario > 1300 GROUP BY Sexo;
SELECT Sexo, COUNT(*) FROM Empleados WHERE Salario 1300 GROUP BY Sexo;
SELECT YEAR(Fecha_Nacimiento) AS Año, COUNT(*) AS Total FROM Empleados GROUP BY YEAR(Fecha_Nacimiento) ORDER BY Año_Nacimiento;
SELECT Nombre, Salario, Count(*) as Empleado From empleados where Salario 1300 And Sexo =’M’ Group by Salario;
SELECT year(F_Nacimiento) as Año, count(*) as Empleado FROM empleados group by año;
SELECT nombre, salario, COUNT(*) AS empleados FROM empleados WHERE salario 1300 AND SEXO = ‘m’ GROUP BY salario;
SELECT nombre, salario, COUNT(*) AS empleados FROM empleados WHERE salario > 1300 AND SEXO = ‘m’ GROUP BY año;
SELECT Year(f_nacimiento) AS año, COUNT(*) As empleados FROM empleados GROUP BY año;
SELECT Sexo, COUNT(*) FROM Empleados WHERE Sexo = ‘F’ AND Salario > 1300 GROUP BY Sexo;
SELECT Sexo, COUNT(*) FROM Empleados WHERE Salario 1300 GROUP BY Sexo;
SELECT YEAR(Fecha_Nacimiento) AS Año, COUNT(*) AS Total FROM Empleados GROUP BY YEAR(Fecha_Nacimiento) ORDER BY Año_Nacimiento;
-SELECT Nombre, Salario, Count(*) as Empleado FROM Empleados WHERE Salario 1300 AND Sexo=’M’ GROUP BY Salario;
-SELECT Year(F_Nacimiento) AS Año, Count(*) AS Empleado FROM empleados GROUP BY Año ORDER BY Año;
SELECT Sexo, COUNT(*) FROM Empleados WHERE Sexo = ‘F’ AND Salario > 1300 GROUP BY Sexo;
SELECT Sexo, COUNT(*) FROM Empleados WHERE Salario 1300 GROUP BY Sexo;
SELECT YEAR(Fecha_Nacimiento) AS Año, COUNT(*) AS Total FROM Empleados GROUP BY YEAR(Fecha_Nacimiento) ORDER BY Año_Nacimiento;
SELECT nombre, salario FROM empleados WHERE salario 1300 AND sexo = ‘M’ group by cargo;
select year(f_nacimiento), COUNT(*) as EMPLEADOS from empleados group by year(f_nacimiento);
SELECT Sexo, COUNT(*) FROM Empleados WHERE Sexo = ‘F’ AND Salario > 1300 GROUP BY Sexo;
SELECT Sexo, COUNT(*) FROM Empleados WHERE Salario 1300 GROUP BY Sexo;
SELECT YEAR(Fecha_Nacimiento) AS Año, COUNT(*) AS Total FROM Empleados GROUP BY YEAR(Fecha_Nacimiento) ORDER BY Año_Nacimiento;
-SELECT Nombre, Salario, Count(*) as Empleado FROM Empleados WHERE Salario 1300 AND Sexo=’M’ GROUP BY Salario;
-SELECT Year(F_Nacimiento) AS Año, Count(*) AS Empleado FROM empleados GROUP BY Año ORDER BY Año;
SELECT nombre, salario FROM empleados WHERE salario 1300 AND sexo = ‘M’ group by cargo;
select year(f_nacimiento), COUNT(*) as EMPLEADOS from empleados group by year(f_nacimiento);
danielrocha
SELECT Sexo, COUNT(*) FROM Empleados WHERE Sexo = ‘F’ AND Salario > 1300 GROUP BY Sexo;
SELECT Sexo, COUNT(*) FROM Empleados WHERE Salario 1300 GROUP BY Sexo;
SELECT YEAR(Fecha_Nacimiento) AS Año, COUNT(*) AS Total FROM Empleados GROUP BY YEAR(Fecha_Nacimiento) ORDER BY Año_Nacimiento;
SELECT Nombre, Salario, Count(*) as Empleado FROM Empleados WHERE Salario 1300 AND Sexo=’M’ GROUP BY Salario;
SELECT Year(F_Nacimiento) AS Año, Count(*) AS Empleado FROM empleados GROUP BY Año ORDER BY Año;
select Nombre,Salario, count(*) as EMPLEADO from empleados where Salario 1300 AND Sexo=’M’ group by Cargo;
SELECT year(F_Nacimiento) AS Año, COUNT(*) AS empleado FROM empleados GROUP by Año;
select Nombre,Salario, count(*) as EMPLEADO from empleados where Salario 1300 AND Sexo=’M’ group by Cargo;
SELECT year(F_Nacimiento) AS Año, COUNT(*) AS empleado FROM empleados GROUP by Año;
SELECT Sexo, COUNT(*) FROM Empleados WHERE Sexo = ‘F’ AND Salario > 1300 GROUP BY Sexo;
SELECT Sexo, COUNT(*) FROM Empleados WHERE Salario 1300 GROUP BY Sexo;
SELECT YEAR(Fecha_Nacimiento) AS Año, COUNT(*) AS Total FROM Empleados GROUP BY YEAR(Fecha_Nacimiento) ORDER BY Año_Nacimiento;
SELECT nombre, salario FROM empleados WHERE salario 1300 AND sexo = ‘M’ group by cargo;
select year(f_nacimiento), COUNT(*) as EMPLEADOS from empleados group by year(f_nacimiento);
SELECT cargo,salario ,COUNT(*) AS Empleados FROM empleados WHERE salario 1300 AND sexo=’M’ GROUP BY salario;
SELECT YEAR(f_nacimiento), COUNT(*) AS año FROM empleados GROUP BY f_nacimiento ORDER BY año;
SELECT Nombre, SALARIO, COUNT(*) as Empleado FROM empleados WHERE SALARIO 1300 AND SEXO=’M’ GROUP by SALARIO;
SELECT Year(F_NACIMIENTO) As Año,COUNT(*) FROM empleados GROUP By Año ORDER BY Año;
ROGELIO DE JESUS:
SELECT Nombre,Salario, COUNT(*) AS empleados FROM empleados WHERE Salario 1300 AND Sexo=’M’ GROUP BY Cargo;
SELECT YEAR(F_Nacimiento) AS Año_Nacimiento, COUNT(*) AS Total_Empleados FROM Empleados GROUP BY YEAR(F_Nacimiento) ORDER BY Año_Nacimiento;
1-SELECT Sexo, COUNT(*) AS Empleados_Con_Bajo_Salario FROM Empleados WHERE Salario 1300 GROUP BY Sexo;
3-SELECT YEAR(Fecha_Nacimiento) AS Año_Nacimiento, COUNT(*) AS Total_Empleados FROM Empleados GROUP BY YEAR(Fecha_Nacimiento) ORDER BY Año_Nacimiento;
SELECT Sexo, COUNT(*) AS Empleados_Con_Bajo_Salario
FROM Empleados
WHERE Salario 1300
GROUP BY Sexo;
SELECT YEAR(Fecha_Nacimiento) AS Año_Nacimiento, COUNT(*) AS Total_Empleados
FROM Empleados
GROUP BY YEAR(Fecha_Nacimiento)
ORDER BY Año_Nacimiento;
SELECT Sexo, COUNT(*) AS Empleados_Mujeres_Con_Alto_Salario
FROM Empleados
WHERE Sexo = ‘F’ AND Salario > 1300
GROUP BY Sexo;
*UPDATE products SET UnitPrice=UnitPrice+(UnitPrice*0.10) WHERE CategoryID=2;
*UPDATE Orders SET Freight = 50.00 WHERE ShipCountry = “France”;
*UPDATE Suppliers SET Region = “NY” WHERE Region IS NULL;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
UPDATE products set UnitPrice= (UnitPrice * 0.10) WHERE CategoryID=’2′;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
UPDATE products SET UnitPrice=(UnitPrice*0.10) WHERE CategoryID=’2′;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET City=’NY’ WHERE City=null;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;}
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
UPDATE products SET UnitPrice=UnitPrice+(UnitPrice*0.10) WHERE CategoryID=2;
UPDATE Orders SET Freight = 50.00 WHERE ShipCountry = “France”;
UPDATE Suppliers SET Region = “NY” WHERE Region IS NULL;
ROGELIO DE JESUS
1-UPDATE Products SET UnitPrice = UnitPrice + (UnitPrice * 0.10)
WHERE CategoryID = 2;
2-UPDATE Orders
SET Freight = 50.00
WHERE ShipCountry = ‘France’;
3-:UPDATE Suppliers
SET Region = ‘NY’
WHERE Region IS NULL;
UPDATE products SET UnitPrice=UnitPrice+(UnitPrice*0.10) WHERE CategoryID=2;
UPDATE Orders SET Freight = 50.00 WHERE ShipCountry = “France”;
UPDATE Suppliers SET Region = “NY” WHERE Region IS NULL;
update products set UnitPrice= (UnitPrice * 0.10) WHERE CategoryID=’2′;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
Leonel sifuentes
UPDATE products SET UnitPrice=UnitPrice+(UnitPrice*0.10) WHERE CategoryID=2;
UPDATE Orders SET Freight = 50.00 WHERE ShipCountry = «France»;
UPDATE Suppliers SET Region = «NY» WHERE Region IS NULL;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
1. UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
2. UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
3. UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
UPDATE products SET UnitPrice = UnitPrice * 1.10 WHERE CategoryID = 2;
UPDATE orders SET Freight = 50.00 WHERE ShipCountry = ‘France’;
UPDATE suppliers SET Region = ‘NY’ WHERE Region IS NULL;
UPDATE products SET UnitPrice = UnitPrice * 1.10 WHERE CategoryID = 2;
UPDATE orders SET Freight = 50.00 WHERE ShipCountry = ‘France’;
UPDATE suppliers SET Region = ‘NY’ WHERE Region IS NULL;
1:UPDATE Products
SET UnitPrice = UnitPrice + (UnitPrice * 0.10)
WHERE CategoryID = 2; 2:UPDATE Orders
SET Freight = 50.00
WHERE ShipCountry = ‘France’; 3:UPDATE Suppliers
SET Region = ‘NY’
WHERE Region IS NULL;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;
1.-UPDATE Products
SET UnitPrice = UnitPrice * 1.10
WHERE CategoryID = 2;
2.-UPDATE Orders
SET Freight = 50.00
WHERE ShipCountry = ‘France’;
3.-UPDATE Suppliers
SET Region = ‘NY’
WHERE Region IS NULL;
1.-UPDATE Products
SET UnitPrice = UnitPrice * 1.10
WHERE CategoryID = 2;
2.-UPDATE Orders
SET Freight = 50.00
WHERE ShipCountry = ‘France’;
3.-UPDATE Suppliers
SET Region = ‘NY’
WHERE Region IS NULL;
1.-UPDATE Products
SET UnitPrice = UnitPrice * 1.10
WHERE CategoryID = 2;
2.-UPDATE Orders
SET Freight = 50.00
WHERE ShipCountry = ‘France’;
3.-UPDATE Suppliers
SET Region = ‘NY’
WHERE Region IS NULL;
1.-UPDATE Products
SET UnitPrice = UnitPrice * 1.10
WHERE CategoryID = 2;
2.-UPDATE Orders
SET Freight = 50.00
WHERE ShipCountry = ‘France’;
3.-UPDATE Suppliers
SET Region = ‘NY’
WHERE Region IS NULL;
1:UPDATE Products
SET UnitPrice = UnitPrice + (UnitPrice * 0.10)
WHERE CategoryID = 2;
2:UPDATE Orders
SET Freight = 50.00
WHERE ShipCountry = ‘France’;
3:UPDATE Suppliers
SET Region = ‘NY’
WHERE Region IS NULL;
UPDATE products SET UnitPrice=UnitPrice*.10 WHERE CategoryID=2;
UPDATE orders SET Freight=50.00 WHERE ShipCountry=’France’;
UPDATE suppliers SET Region=NULL WHERE Region=’NY’;