-- create a table
CREATE TABLE clientes (
  id_RUT INTEGER PRIMARY KEY,
  nombre TEXT NOT NULL,
  apellido_P TEXT NOT NULL,
  apellido_M TEXT NOT NULL,
  sueldo INTEGER NOT NULL,
  sexo TEXT NOT NULL
);
-- insert some values
 INSERT INTO clientes VALUES (219753632, "Juan", "Fernandez","Riquelme",400000,"M");
INSERT INTO clientes VALUES (212435579, "Sofia", "Gonzalez","Faundez",750000,"F");
INSERT INTO clientes VALUES (214221347, "Agustin", "Martinez","Friz",385000,"M");
INSERT INTO clientes VALUES (219978345, "Martina", "Guerra","Balmaceda",600000,"F");
INSERT INTO clientes VALUES (217778531, "Rodrigo", "Gaete","Zepeda",435000,"M");
INSERT INTO clientes VALUES (217985710,  "Rodri","Gaël","Zepe",485100,"F");
-- fetch some valufes
SELECT nombre, apellido_P, sueldo, (sueldo*1.10) AS descuento FROM clientes;
SELECT COUNT(*) AS conteo FROM clientes;
SELECT SUM(sueldo) AS suma FROM clientes;
SELECT MAX(sueldo) AS maximo FROM clientes;
Select MIN(sueldo) AS minimo FROM clientes;
SELECT COUNT (*) AS sueldo_grande FROM clientes WHERE sueldo>450000;
SELECT * FROM clientes ORDER BY sueldo DESC;
SELECT * FROM clientes ORDER BY id_RUT DESC