SQLize Online / PHPize Online  /  SQLtest Online

INSERT INTO alumnos VALUES ('1', '12345678A', 'Ana', 'Martínez López', TO_DATE('01/01/1980', 'DD/MM/YYYY'), 'Albacete', '02001', 'ASIR1', 9, NULL); INSERT INTO alumnos VALUES ('2', '23455987B', 'Luis', 'Pérez Martínez', TO_DATE('01/11/1990', 'DD/MM/YYYY'), 'Hellín', '02001', 'ASIR1', 6, 10); INSERT INTO alumnos VALUES ('3', '23453245C', 'Juan', 'García Martínez', TO_DATE('11/06/1992', 'DD/MM/YYYY'), 'Albacete', '02001', 'ASIR1', 4, 5); INSERT INTO alumnos VALUES ('4', '12345234B', 'Sara', 'Martínez Fernández', TO_DATE('05/08/1995', 'DD/MM/YYYY'), 'Madrid', '28080', 'ASIR2', 7, NULL); INSERT INTO alumnos VALUES ('5', '76856365B', 'José', 'Gutiérrez López', TO_DATE('12/12/1995', 'DD/MM/YYYY'), 'Tobarra', '02001', 'ASIR2', 8, 20); INSERT INTO alumnos VALUES ('6', '12345621B', 'Miguel', 'Jiménez Pérez', TO_DATE('05/05/1997', 'DD/MM/YYYY'), 'Hellín', '02001', 'SMR1', 6, 25); INSERT INTO alumnos VALUES ('7', '95702435D', 'Pascual', 'García López', TO_DATE('07/09/1997', 'DD/MM/YYYY'), 'Hellín', '02001', 'SMR1', 5, 4); INSERT INTO alumnos VALUES ('8', '90243567E', 'Isabel', 'Fernández García', TO_DATE('10/03/1996', 'DD/MM/YYYY'), 'Hellín', '02001', 'SMR2', 4, 18); INSERT INTO alumnos VALUES ('9', '23495734F', 'Carlos', 'Belmonte Martínez', TO_DATE('10/04/1980', 'DD/MM/YYYY'), 'Madrid', '28085', 'SMR2', 3, 30); INSERT INTO alumnos VALUES ('10', '09824523H', 'Alfonso', 'Gutiérrez García', TO_DATE('03/10/1996', 'DD/MM/YYYY'), 'Albacete', '02003', 'ASIR1', 5, 50);