MariaDB [(none)]> create database CadenaParcial1Parte1;
Query OK, 1 row affected (0.012 sec)

MariaDB [(none)]> use CadenaParical1Parte1;
ERROR 1049 (42000): Unknown database 'cadenaparical1parte1'
MariaDB [(none)]> use CadenaParcial1Parte1;
Database changed
MariaDB [CadenaParcial1Parte1]> create table Discente(Carnet varchar(12) not null primary key,
    -> nombre varchar (60) not null);
Query OK, 0 rows affected (0.086 sec)

MariaDB [CadenaParcial1Parte1]> show tables;
+--------------------------------+
| Tables_in_cadenaparcial1parte1 |
+--------------------------------+
| discente                       |
+--------------------------------+
1 row in set (0.006 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201126012075','ALVARADO RESTREPO ESTEBAN');
Query OK, 1 row affected (0.010 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201110011075','ARENAS TAMAYO JOAN SEBASTIAN');
Query OK, 1 row affected (0.030 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200910005075','BEDOYA BEDOYA DIEGO ALEXANDER');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201020006088','CARDONA CHICA DIEGO FERNANDO');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201116027075','CARMONA TABORDA JOHN ALEXANDER');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320010075','CORREA CORREA ANGELICA MARIA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201110016075','GOMEZ GOMEZ JULIO CESAR');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201110022075','HURTADO TAMAYO CARLOS ESTIBEN');
Query OK, 1 row affected (0.005 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201220002075','LONDO･O FONNEGRA JHONNY ALEXANDER');
Query OK, 1 row affected (0.010 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201116037075','MANYOMA GARCIA HENSLLY');
Query OK, 1 row affected (0.005 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201110020075','MARTINEZ VALENCIA JHON DENNIS');
Query OK, 1 row affected (0.004 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320021075','PEREZ  YEISON FABIAN');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201220004088','SALAZAR BUSTAMANTE MERY JOHANNA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201212005075','TORRES TONOCOLIA JENNIFER JULIETH');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201213002088','ZULUAGA LONDO･O ANGELA CRISTINA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201120011088','ASPRILLA LEUDO YILMAR');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201324002075','ASPRILLA MENA WALNHER YHAMYD');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201223000088','CALLE PUERTA LILIANA MARIA');
Query OK, 1 row affected (0.017 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201210009088','COLLAZO PATI･O  ALEX FERNEY');
Query OK, 1 row affected (0.007 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201224000088','GRANADA MESA VICTOR ALONSO');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201210005088','HERRERA CARDONA JUAN DANIEL');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201220016088','JARAMILLO CARDONA MARLON ALEXANDER');
Query OK, 1 row affected (0.008 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201210043088','MARTINEZ VALENCIA JHONATAN ARLEY');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201210009075','MOSQUERA PALACIOS NELSON JHAIR');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201210007075','OCAMPO NARANJO LUIS FELIPE');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201210022088','OROZCO CARMONA DIDIER');
Query OK, 1 row affected (0.008 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201222000075','RAMIREZ MONTOYA ANDRES');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201210012088','SALDARRIAGA ARAQUE ANDRES FELIPE');
Query OK, 1 row affected (0.007 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201010002075','VANEGAS AGUDELO ETHAN ARLEY');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200910012075','ALZATE CARVAJAL RAFAEL ALEXANDER');
Query OK, 1 row affected (0.006 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200910005075','BEDOYA BEDOYA DIEGO ALEXANDER');
ERROR 1062 (23000): Duplicate entry '200910005075' for key 'PRIMARY'
MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201210030075','CAICEDO CABEZAS JOHE ALDREITH');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201126016075','MESA ROLDAN JAVIER ALBERTO');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201213000088','MONTOYA HENAO MARCELA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201312004075','MUNERA CARDENAS JOHN JAIRO');
Query OK, 1 row affected (0.017 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320021075','PEREZ  YEISON FABIAN');
ERROR 1062 (23000): Duplicate entry '201320021075' for key 'PRIMARY'
MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201220022088','RAMIREZ MESA JULIAN ALBERTO');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201313006075','TEJADA CASTRO ANDR心 FELIPE');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201220004075','VALLEJO MAZO PAOLA ANDREA');
Query OK, 1 row affected (0.009 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200920001075','VARGAS ARTEAGA ALEXIS ALBERTO');
Query OK, 1 row affected (0.017 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201212003075','ZAPATA ZU･IGA ADRIANA PATRICIA');
Query OK, 1 row affected (0.017 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201222005075','ANDRADE RIVERA JOHAN ALEXIS');
Query OK, 1 row affected (0.009 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201310026075','ANGARITA TORRES IRAMA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201312007075','CARO BEDOYA WALTER DAVIDSON');
Query OK, 1 row affected (0.017 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201313001075','CUESTA CUERVO  YURY LORENA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201220006075','ECHAVARRIA RODRIGUEZ SANDRA MARIA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201310008075','GIRALDO VERGARA YOLANDA MILENA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201110017088','GRAJALES MU･OZ VICTOR CAMILO');
Query OK, 1 row affected (0.005 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201110005088','NARANJO DE LOS RIOS MONICA MARIA');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201214004075','RADA RODRIGUEZ SILVIO SEGUNDO');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201223003075','SERNA ESCOBAR JUAN CARLOS');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201222004075','VEGA MAZO OMAIRA MARIA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200820040075','WALTON MAYA NATALIA MARIA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200920009075','ATEHORTUA LONDO･O JUAN CAMILO');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201220003075','BLANDON LONDO･O CRISTIAN MAURICIO');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201010005075','CASTRO HERNANDEZ MARIA CRISTINA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201110019088','CASTRO NAVIA KARINA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201020003088','CEBALLOS BETANCUR DANIEL STEVEN');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201222003075','RESTREPO GOMEZ RUBEN FERNANDO');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201110034075','RODRIGUEZ CARDONA YENY ANDREA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201310016075','VALDERRAMA MAHECHA  DIEGO ALEJANDRO');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201222007073','AREIZA VERA JOHN FREDY');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201110058073','BURGOS ECHEVERRY LISBETH');
Query OK, 1 row affected (0.017 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201222008073','DOMINGUEZ GOMEZ LIBIA ESTELA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201314005073','DURANGO RODRIGUEZ JESUS HUMBEIRO');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200910069073','FUENTES FLOREZ JESSICA VIVIANA');
Query OK, 1 row affected (0.006 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201312008075','JARAMILLO LUIS FERNANDO');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201120004073','LOPERA GUTIERREZ ALBA MIREYLLE');
Query OK, 1 row affected (0.017 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201120036073','MENA ARTEAGA JUAN NORBERTO');
Query OK, 1 row affected (0.007 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201120028073','OSPINA DAVID DORA ALBA');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200820036073','RIOS QUINCHIA TATIANA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200920013073','SILVA ARIAS NANCY CRISTINA');
Query OK, 1 row affected (0.017 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201312001088','VARELA BEDOYA DAISSY ANDREA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201120030073','VELASQUEZ ACEVEDO BIVIANA ELIZABETH');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201324013073','VELEZ DIANA MARCELA');
Query OK, 1 row affected (0.019 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('200910007073','ZAPATA VALENCIA OLGA LUCIA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320024070','BOLA･O MADERA  MAIRA MIRITH');
Query OK, 1 row affected (0.005 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320016070','GRISALES ISAZA PAOLA ANDREA');
Query OK, 1 row affected (0.004 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320005086','GUTIERREZ SEGURO  BEATRIZ');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320005073','HOYOS HENAO JORGE NILTON');
Query OK, 1 row affected (0.009 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320002073','LEON ESTEVEZ DEISY YOLIMA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320008060','LONDO･O MU･OZ  MARISOL');
Query OK, 1 row affected (0.017 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320003072','LOPEZ BLANDON LUISA FERNANDA');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320011073','LOPEZ JIMENEZ LILLYAM DE JESUS');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320009070','MAZO MARIN ANA MARIA');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320011059','MU･OZ LOPEZ JONATHATAN FELIPE');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320013074','MURILLO MURILLO VIDAL CAMILO');
Query OK, 1 row affected (0.006 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320004072','PATI･O FLOREZ MARIA ANDREA');
Query OK, 1 row affected (0.014 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320008059','RODRIGUEZ VILLA YOHAN SEBASTIAN');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320006073','RUIZ RIVERA ISABEL');
Query OK, 1 row affected (0.029 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320003070','TEJADA AGUIRRE ZAIRA CRISTINA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320013070','TIECK MACIAS NICOLAS');
Query OK, 1 row affected (0.016 sec)

MariaDB [CadenaParcial1Parte1]> insert into discente(carnet, nombre) values('201320006074','YEPES HENAO MONICA');
Query OK, 1 row affected (0.015 sec)

MariaDB [CadenaParcial1Parte1]> select * from discente;
+--------------+-------------------------------------+
| Carnet       | nombre                              |
+--------------+-------------------------------------+
| 200820036073 | RIOS QUINCHIA TATIANA               |
| 200820040075 | WALTON MAYA NATALIA MARIA           |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER       |
| 200910007073 | ZAPATA VALENCIA OLGA LUCIA          |
| 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER    |
| 200910069073 | FUENTES FLOREZ JESSICA VIVIANA      |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO       |
| 200920009075 | ATEHORTUA LONDO･O JUAN CAMILO       |
| 200920013073 | SILVA ARIAS NANCY CRISTINA          |
| 201010002075 | VANEGAS AGUDELO ETHAN ARLEY         |
| 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA     |
| 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN     |
| 201020006088 | CARDONA CHICA DIEGO FERNANDO        |
| 201110005088 | NARANJO DE LOS RIOS MONICA MARIA    |
| 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN        |
| 201110016075 | GOMEZ GOMEZ JULIO CESAR             |
| 201110017088 | GRAJALES MU･OZ VICTOR CAMILO        |
| 201110019088 | CASTRO NAVIA KARINA                 |
| 201110020075 | MARTINEZ VALENCIA JHON DENNIS       |
| 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN       |
| 201110034075 | RODRIGUEZ CARDONA YENY ANDREA       |
| 201110058073 | BURGOS ECHEVERRY LISBETH            |
| 201116027075 | CARMONA TABORDA JOHN ALEXANDER      |
| 201116037075 | MANYOMA GARCIA HENSLLY              |
| 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE      |
| 201120011088 | ASPRILLA LEUDO YILMAR               |
| 201120028073 | OSPINA DAVID DORA ALBA              |
| 201120030073 | VELASQUEZ ACEVEDO BIVIANA ELIZABETH |
| 201120036073 | MENA ARTEAGA JUAN NORBERTO          |
| 201126012075 | ALVARADO RESTREPO ESTEBAN           |
| 201126016075 | MESA ROLDAN JAVIER ALBERTO          |
| 201210005088 | HERRERA CARDONA JUAN DANIEL         |
| 201210007075 | OCAMPO NARANJO LUIS FELIPE          |
| 201210009075 | MOSQUERA PALACIOS NELSON JHAIR      |
| 201210009088 | COLLAZO PATI･O  ALEX FERNEY         |
| 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE    |
| 201210022088 | OROZCO CARMONA DIDIER               |
| 201210030075 | CAICEDO CABEZAS JOHE ALDREITH       |
| 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY    |
| 201212003075 | ZAPATA ZU･IGA ADRIANA PATRICIA      |
| 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH   |
| 201213000088 | MONTOYA HENAO MARCELA               |
| 201213002088 | ZULUAGA LONDO･O ANGELA CRISTINA     |
| 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER   |
| 201220003075 | BLANDON LONDO･O CRISTIAN MAURICIO   |
| 201220004075 | VALLEJO MAZO PAOLA ANDREA           |
| 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA     |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA   |
| 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER  |
| 201220022088 | RAMIREZ MESA JULIAN ALBERTO         |
| 201222000075 | RAMIREZ MONTOYA ANDRES              |
| 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO       |
| 201222004075 | VEGA MAZO OMAIRA MARIA              |
| 201222005075 | ANDRADE RIVERA JOHAN ALEXIS         |
| 201222007073 | AREIZA VERA JOHN FREDY              |
| 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA        |
| 201223000088 | CALLE PUERTA LILIANA MARIA          |
| 201223003075 | SERNA ESCOBAR JUAN CARLOS           |
| 201224000088 | GRANADA MESA VICTOR ALONSO          |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      |
| 201310016075 | VALDERRAMA MAHECHA  DIEGO ALEJANDRO |
| 201310026075 | ANGARITA TORRES IRAMA               |
| 201312001088 | VARELA BEDOYA DAISSY ANDREA         |
| 201312004075 | MUNERA CARDENAS JOHN JAIRO          |
| 201312007075 | CARO BEDOYA WALTER DAVIDSON         |
| 201312008075 | JARAMILLO LUIS FERNANDO             |
| 201313001075 | CUESTA CUERVO  YURY LORENA          |
| 201313006075 | TEJADA CASTRO ANDR心 FELIPE         |
| 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO    |
| 201320002073 | LEON ESTEVEZ DEISY YOLIMA           |
| 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA       |
| 201320003072 | LOPEZ BLANDON LUISA FERNANDA        |
| 201320004072 | PATI･O FLOREZ MARIA ANDREA          |
| 201320005073 | HOYOS HENAO JORGE NILTON            |
| 201320005086 | GUTIERREZ SEGURO  BEATRIZ           |
| 201320006073 | RUIZ RIVERA ISABEL                  |
| 201320006074 | YEPES HENAO MONICA                  |
| 201320008059 | RODRIGUEZ VILLA YOHAN SEBASTIAN     |
| 201320008060 | LONDO･O MU･OZ  MARISOL              |
| 201320009070 | MAZO MARIN ANA MARIA                |
| 201320010075 | CORREA CORREA ANGELICA MARIA        |
| 201320011059 | MU･OZ LOPEZ JONATHATAN FELIPE       |
| 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS      |
| 201320013070 | TIECK MACIAS NICOLAS                |
| 201320013074 | MURILLO MURILLO VIDAL CAMILO        |
| 201320016070 | GRISALES ISAZA PAOLA ANDREA         |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201320024070 | BOLA･O MADERA  MAIRA MIRITH         |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
| 201324013073 | VELEZ DIANA MARCELA                 |
+--------------+-------------------------------------+
91 rows in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> select carnet,nombre from Discente where substr(carnet, 10,3)in ('075','088');
+--------------+-------------------------------------+
| carnet       | nombre                              |
+--------------+-------------------------------------+
| 200820040075 | WALTON MAYA NATALIA MARIA           |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER       |
| 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER    |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO       |
| 200920009075 | ATEHORTUA LONDO･O JUAN CAMILO       |
| 201010002075 | VANEGAS AGUDELO ETHAN ARLEY         |
| 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA     |
| 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN     |
| 201020006088 | CARDONA CHICA DIEGO FERNANDO        |
| 201110005088 | NARANJO DE LOS RIOS MONICA MARIA    |
| 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN        |
| 201110016075 | GOMEZ GOMEZ JULIO CESAR             |
| 201110017088 | GRAJALES MU･OZ VICTOR CAMILO        |
| 201110019088 | CASTRO NAVIA KARINA                 |
| 201110020075 | MARTINEZ VALENCIA JHON DENNIS       |
| 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN       |
| 201110034075 | RODRIGUEZ CARDONA YENY ANDREA       |
| 201116027075 | CARMONA TABORDA JOHN ALEXANDER      |
| 201116037075 | MANYOMA GARCIA HENSLLY              |
| 201120011088 | ASPRILLA LEUDO YILMAR               |
| 201126012075 | ALVARADO RESTREPO ESTEBAN           |
| 201126016075 | MESA ROLDAN JAVIER ALBERTO          |
| 201210005088 | HERRERA CARDONA JUAN DANIEL         |
| 201210007075 | OCAMPO NARANJO LUIS FELIPE          |
| 201210009075 | MOSQUERA PALACIOS NELSON JHAIR      |
| 201210009088 | COLLAZO PATI･O  ALEX FERNEY         |
| 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE    |
| 201210022088 | OROZCO CARMONA DIDIER               |
| 201210030075 | CAICEDO CABEZAS JOHE ALDREITH       |
| 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY    |
| 201212003075 | ZAPATA ZU･IGA ADRIANA PATRICIA      |
| 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH   |
| 201213000088 | MONTOYA HENAO MARCELA               |
| 201213002088 | ZULUAGA LONDO･O ANGELA CRISTINA     |
| 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER   |
| 201220003075 | BLANDON LONDO･O CRISTIAN MAURICIO   |
| 201220004075 | VALLEJO MAZO PAOLA ANDREA           |
| 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA     |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA   |
| 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER  |
| 201220022088 | RAMIREZ MESA JULIAN ALBERTO         |
| 201222000075 | RAMIREZ MONTOYA ANDRES              |
| 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO       |
| 201222004075 | VEGA MAZO OMAIRA MARIA              |
| 201222005075 | ANDRADE RIVERA JOHAN ALEXIS         |
| 201223000088 | CALLE PUERTA LILIANA MARIA          |
| 201223003075 | SERNA ESCOBAR JUAN CARLOS           |
| 201224000088 | GRANADA MESA VICTOR ALONSO          |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      |
| 201310016075 | VALDERRAMA MAHECHA  DIEGO ALEJANDRO |
| 201310026075 | ANGARITA TORRES IRAMA               |
| 201312001088 | VARELA BEDOYA DAISSY ANDREA         |
| 201312004075 | MUNERA CARDENAS JOHN JAIRO          |
| 201312007075 | CARO BEDOYA WALTER DAVIDSON         |
| 201312008075 | JARAMILLO LUIS FERNANDO             |
| 201313001075 | CUESTA CUERVO  YURY LORENA          |
| 201313006075 | TEJADA CASTRO ANDR心 FELIPE         |
| 201320010075 | CORREA CORREA ANGELICA MARIA        |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
+--------------+-------------------------------------+
61 rows in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> select carnet,nombre from Discente where substr(carnet, 10,3)in ('075');
+--------------+-------------------------------------+
| carnet       | nombre                              |
+--------------+-------------------------------------+
| 200820040075 | WALTON MAYA NATALIA MARIA           |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER       |
| 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER    |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO       |
| 200920009075 | ATEHORTUA LONDO･O JUAN CAMILO       |
| 201010002075 | VANEGAS AGUDELO ETHAN ARLEY         |
| 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA     |
| 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN        |
| 201110016075 | GOMEZ GOMEZ JULIO CESAR             |
| 201110020075 | MARTINEZ VALENCIA JHON DENNIS       |
| 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN       |
| 201110034075 | RODRIGUEZ CARDONA YENY ANDREA       |
| 201116027075 | CARMONA TABORDA JOHN ALEXANDER      |
| 201116037075 | MANYOMA GARCIA HENSLLY              |
| 201126012075 | ALVARADO RESTREPO ESTEBAN           |
| 201126016075 | MESA ROLDAN JAVIER ALBERTO          |
| 201210007075 | OCAMPO NARANJO LUIS FELIPE          |
| 201210009075 | MOSQUERA PALACIOS NELSON JHAIR      |
| 201210030075 | CAICEDO CABEZAS JOHE ALDREITH       |
| 201212003075 | ZAPATA ZU･IGA ADRIANA PATRICIA      |
| 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH   |
| 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER   |
| 201220003075 | BLANDON LONDO･O CRISTIAN MAURICIO   |
| 201220004075 | VALLEJO MAZO PAOLA ANDREA           |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA   |
| 201222000075 | RAMIREZ MONTOYA ANDRES              |
| 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO       |
| 201222004075 | VEGA MAZO OMAIRA MARIA              |
| 201222005075 | ANDRADE RIVERA JOHAN ALEXIS         |
| 201223003075 | SERNA ESCOBAR JUAN CARLOS           |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      |
| 201310016075 | VALDERRAMA MAHECHA  DIEGO ALEJANDRO |
| 201310026075 | ANGARITA TORRES IRAMA               |
| 201312004075 | MUNERA CARDENAS JOHN JAIRO          |
| 201312007075 | CARO BEDOYA WALTER DAVIDSON         |
| 201312008075 | JARAMILLO LUIS FERNANDO             |
| 201313001075 | CUESTA CUERVO  YURY LORENA          |
| 201313006075 | TEJADA CASTRO ANDR心 FELIPE         |
| 201320010075 | CORREA CORREA ANGELICA MARIA        |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
+--------------+-------------------------------------+
42 rows in set (0.002 sec)

MariaDB [CadenaParcial1Parte1]> select nombre from discente where character_length(nombre) <=25;
+---------------------------+
| nombre                    |
+---------------------------+
| RIOS QUINCHIA TATIANA     |
| WALTON MAYA NATALIA MARIA |
| GOMEZ GOMEZ JULIO CESAR   |
| CASTRO NAVIA KARINA       |
| BURGOS ECHEVERRY LISBETH  |
| MANYOMA GARCIA HENSLLY    |
| ASPRILLA LEUDO YILMAR     |
| OSPINA DAVID DORA ALBA    |
| ALVARADO RESTREPO ESTEBAN |
| OROZCO CARMONA DIDIER     |
| MONTOYA HENAO MARCELA     |
| VALLEJO MAZO PAOLA ANDREA |
| RAMIREZ MONTOYA ANDRES    |
| VEGA MAZO OMAIRA MARIA    |
| AREIZA VERA JOHN FREDY    |
| SERNA ESCOBAR JUAN CARLOS |
| ANGARITA TORRES IRAMA     |
| JARAMILLO LUIS FERNANDO   |
| LEON ESTEVEZ DEISY YOLIMA |
| HOYOS HENAO JORGE NILTON  |
| GUTIERREZ SEGURO  BEATRIZ |
| RUIZ RIVERA ISABEL        |
| YEPES HENAO MONICA        |
| LONDO･O MU･OZ  MARISOL    |
| MAZO MARIN ANA MARIA      |
| TIECK MACIAS NICOLAS      |
| PEREZ  YEISON FABIAN      |
| VELEZ DIANA MARCELA       |
+---------------------------+
28 rows in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> select count(nombre) from discente where substr(carnet,10,3) not in ('088');
+---------------+
| count(nombre) |
+---------------+
|            72 |
+---------------+
1 row in set (0.002 sec)

MariaDB [CadenaParcial1Parte1]> select count(nombre) 'Numero de discentes no matriculados en tecnolog｡a de sistemas' from discente where substr(carnet,10,3) not in ('088');
+---------------------------------------------------------------+
| Numero de discentes no matriculados en tecnolog｡a de sistemas |
+---------------------------------------------------------------+
|                                                            72 |
+---------------------------------------------------------------+
1 row in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> select count(nombre) 'Numero de discentes que iniciaron estudios en el 2012' from discente where substr(carnet,1,4) in ('2012');
+-------------------------------------------------------+
| Numero de discentes que iniciaron estudios en el 2012 |
+-------------------------------------------------------+
|                                                    29 |
+-------------------------------------------------------+
1 row in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> select count(nombre) 'Numero de discentes que iniciaron estudios primer semestre' from discente where substr(carnet,5,1) in ('1');
+------------------------------------------------------------+
| Numero de discentes que iniciaron estudios primer semestre |
+------------------------------------------------------------+
|                                                         40 |
+------------------------------------------------------------+
1 row in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> select count(nombre) 'Numero de discentes que matricularon antes del 2013' from discente where substr(carnet,1,4) < ('2013');
+-----------------------------------------------------+
| Numero de discentes que matricularon antes del 2013 |
+-----------------------------------------------------+
|                                                  60 |
+-----------------------------------------------------+
1 row in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> Select carnet,nombre from Discente order by carnet;
+--------------+-------------------------------------+
| carnet       | nombre                              |
+--------------+-------------------------------------+
| 200820036073 | RIOS QUINCHIA TATIANA               |
| 200820040075 | WALTON MAYA NATALIA MARIA           |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER       |
| 200910007073 | ZAPATA VALENCIA OLGA LUCIA          |
| 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER    |
| 200910069073 | FUENTES FLOREZ JESSICA VIVIANA      |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO       |
| 200920009075 | ATEHORTUA LONDO･O JUAN CAMILO       |
| 200920013073 | SILVA ARIAS NANCY CRISTINA          |
| 201010002075 | VANEGAS AGUDELO ETHAN ARLEY         |
| 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA     |
| 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN     |
| 201020006088 | CARDONA CHICA DIEGO FERNANDO        |
| 201110005088 | NARANJO DE LOS RIOS MONICA MARIA    |
| 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN        |
| 201110016075 | GOMEZ GOMEZ JULIO CESAR             |
| 201110017088 | GRAJALES MU･OZ VICTOR CAMILO        |
| 201110019088 | CASTRO NAVIA KARINA                 |
| 201110020075 | MARTINEZ VALENCIA JHON DENNIS       |
| 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN       |
| 201110034075 | RODRIGUEZ CARDONA YENY ANDREA       |
| 201110058073 | BURGOS ECHEVERRY LISBETH            |
| 201116027075 | CARMONA TABORDA JOHN ALEXANDER      |
| 201116037075 | MANYOMA GARCIA HENSLLY              |
| 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE      |
| 201120011088 | ASPRILLA LEUDO YILMAR               |
| 201120028073 | OSPINA DAVID DORA ALBA              |
| 201120030073 | VELASQUEZ ACEVEDO BIVIANA ELIZABETH |
| 201120036073 | MENA ARTEAGA JUAN NORBERTO          |
| 201126012075 | ALVARADO RESTREPO ESTEBAN           |
| 201126016075 | MESA ROLDAN JAVIER ALBERTO          |
| 201210005088 | HERRERA CARDONA JUAN DANIEL         |
| 201210007075 | OCAMPO NARANJO LUIS FELIPE          |
| 201210009075 | MOSQUERA PALACIOS NELSON JHAIR      |
| 201210009088 | COLLAZO PATI･O  ALEX FERNEY         |
| 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE    |
| 201210022088 | OROZCO CARMONA DIDIER               |
| 201210030075 | CAICEDO CABEZAS JOHE ALDREITH       |
| 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY    |
| 201212003075 | ZAPATA ZU･IGA ADRIANA PATRICIA      |
| 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH   |
| 201213000088 | MONTOYA HENAO MARCELA               |
| 201213002088 | ZULUAGA LONDO･O ANGELA CRISTINA     |
| 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER   |
| 201220003075 | BLANDON LONDO･O CRISTIAN MAURICIO   |
| 201220004075 | VALLEJO MAZO PAOLA ANDREA           |
| 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA     |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA   |
| 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER  |
| 201220022088 | RAMIREZ MESA JULIAN ALBERTO         |
| 201222000075 | RAMIREZ MONTOYA ANDRES              |
| 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO       |
| 201222004075 | VEGA MAZO OMAIRA MARIA              |
| 201222005075 | ANDRADE RIVERA JOHAN ALEXIS         |
| 201222007073 | AREIZA VERA JOHN FREDY              |
| 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA        |
| 201223000088 | CALLE PUERTA LILIANA MARIA          |
| 201223003075 | SERNA ESCOBAR JUAN CARLOS           |
| 201224000088 | GRANADA MESA VICTOR ALONSO          |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      |
| 201310016075 | VALDERRAMA MAHECHA  DIEGO ALEJANDRO |
| 201310026075 | ANGARITA TORRES IRAMA               |
| 201312001088 | VARELA BEDOYA DAISSY ANDREA         |
| 201312004075 | MUNERA CARDENAS JOHN JAIRO          |
| 201312007075 | CARO BEDOYA WALTER DAVIDSON         |
| 201312008075 | JARAMILLO LUIS FERNANDO             |
| 201313001075 | CUESTA CUERVO  YURY LORENA          |
| 201313006075 | TEJADA CASTRO ANDR心 FELIPE         |
| 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO    |
| 201320002073 | LEON ESTEVEZ DEISY YOLIMA           |
| 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA       |
| 201320003072 | LOPEZ BLANDON LUISA FERNANDA        |
| 201320004072 | PATI･O FLOREZ MARIA ANDREA          |
| 201320005073 | HOYOS HENAO JORGE NILTON            |
| 201320005086 | GUTIERREZ SEGURO  BEATRIZ           |
| 201320006073 | RUIZ RIVERA ISABEL                  |
| 201320006074 | YEPES HENAO MONICA                  |
| 201320008059 | RODRIGUEZ VILLA YOHAN SEBASTIAN     |
| 201320008060 | LONDO･O MU･OZ  MARISOL              |
| 201320009070 | MAZO MARIN ANA MARIA                |
| 201320010075 | CORREA CORREA ANGELICA MARIA        |
| 201320011059 | MU･OZ LOPEZ JONATHATAN FELIPE       |
| 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS      |
| 201320013070 | TIECK MACIAS NICOLAS                |
| 201320013074 | MURILLO MURILLO VIDAL CAMILO        |
| 201320016070 | GRISALES ISAZA PAOLA ANDREA         |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201320024070 | BOLA･O MADERA  MAIRA MIRITH         |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
| 201324013073 | VELEZ DIANA MARCELA                 |
+--------------+-------------------------------------+
91 rows in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> select * from discente where substr(carnet,10,3) in ('075') and substr(carnet,5,1) in ('2') and substr(carnet,1,4) < ('2012');
+--------------+-------------------------------+
| Carnet       | nombre                        |
+--------------+-------------------------------+
| 200820040075 | WALTON MAYA NATALIA MARIA     |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO |
| 200920009075 | ATEHORTUA LONDO･O JUAN CAMILO |
| 201126012075 | ALVARADO RESTREPO ESTEBAN     |
| 201126016075 | MESA ROLDAN JAVIER ALBERTO    |
+--------------+-------------------------------+
5 rows in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> select min(carnet) from discente where substr(carnet,10,3) in ('075','088');
+--------------+
| min(carnet)  |
+--------------+
| 200820040075 |
+--------------+
1 row in set (0.001 sec)

MariaDB [CadenaParcial1Parte1]> select carnet,nombre,if(carnet like'%088','05% descuento','No descuento') from discente;
+--------------+-------------------------------------+------------------------------------------------------+
| carnet       | nombre                              | if(carnet like'%088','05% descuento','No descuento') |
+--------------+-------------------------------------+------------------------------------------------------+
| 200820036073 | RIOS QUINCHIA TATIANA               | No descuento                                         |
| 200820040075 | WALTON MAYA NATALIA MARIA           | No descuento                                         |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER       | No descuento                                         |
| 200910007073 | ZAPATA VALENCIA OLGA LUCIA          | No descuento                                         |
| 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER    | No descuento                                         |
| 200910069073 | FUENTES FLOREZ JESSICA VIVIANA      | No descuento                                         |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO       | No descuento                                         |
| 200920009075 | ATEHORTUA LONDO･O JUAN CAMILO       | No descuento                                         |
| 200920013073 | SILVA ARIAS NANCY CRISTINA          | No descuento                                         |
| 201010002075 | VANEGAS AGUDELO ETHAN ARLEY         | No descuento                                         |
| 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA     | No descuento                                         |
| 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN     | 05% descuento                                        |
| 201020006088 | CARDONA CHICA DIEGO FERNANDO        | 05% descuento                                        |
| 201110005088 | NARANJO DE LOS RIOS MONICA MARIA    | 05% descuento                                        |
| 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN        | No descuento                                         |
| 201110016075 | GOMEZ GOMEZ JULIO CESAR             | No descuento                                         |
| 201110017088 | GRAJALES MU･OZ VICTOR CAMILO        | 05% descuento                                        |
| 201110019088 | CASTRO NAVIA KARINA                 | 05% descuento                                        |
| 201110020075 | MARTINEZ VALENCIA JHON DENNIS       | No descuento                                         |
| 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN       | No descuento                                         |
| 201110034075 | RODRIGUEZ CARDONA YENY ANDREA       | No descuento                                         |
| 201110058073 | BURGOS ECHEVERRY LISBETH            | No descuento                                         |
| 201116027075 | CARMONA TABORDA JOHN ALEXANDER      | No descuento                                         |
| 201116037075 | MANYOMA GARCIA HENSLLY              | No descuento                                         |
| 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE      | No descuento                                         |
| 201120011088 | ASPRILLA LEUDO YILMAR               | 05% descuento                                        |
| 201120028073 | OSPINA DAVID DORA ALBA              | No descuento                                         |
| 201120030073 | VELASQUEZ ACEVEDO BIVIANA ELIZABETH | No descuento                                         |
| 201120036073 | MENA ARTEAGA JUAN NORBERTO          | No descuento                                         |
| 201126012075 | ALVARADO RESTREPO ESTEBAN           | No descuento                                         |
| 201126016075 | MESA ROLDAN JAVIER ALBERTO          | No descuento                                         |
| 201210005088 | HERRERA CARDONA JUAN DANIEL         | 05% descuento                                        |
| 201210007075 | OCAMPO NARANJO LUIS FELIPE          | No descuento                                         |
| 201210009075 | MOSQUERA PALACIOS NELSON JHAIR      | No descuento                                         |
| 201210009088 | COLLAZO PATI･O  ALEX FERNEY         | 05% descuento                                        |
| 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE    | 05% descuento                                        |
| 201210022088 | OROZCO CARMONA DIDIER               | 05% descuento                                        |
| 201210030075 | CAICEDO CABEZAS JOHE ALDREITH       | No descuento                                         |
| 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY    | 05% descuento                                        |
| 201212003075 | ZAPATA ZU･IGA ADRIANA PATRICIA      | No descuento                                         |
| 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH   | No descuento                                         |
| 201213000088 | MONTOYA HENAO MARCELA               | 05% descuento                                        |
| 201213002088 | ZULUAGA LONDO･O ANGELA CRISTINA     | 05% descuento                                        |
| 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO       | No descuento                                         |
| 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER   | No descuento                                         |
| 201220003075 | BLANDON LONDO･O CRISTIAN MAURICIO   | No descuento                                         |
| 201220004075 | VALLEJO MAZO PAOLA ANDREA           | No descuento                                         |
| 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA     | 05% descuento                                        |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA   | No descuento                                         |
| 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER  | 05% descuento                                        |
| 201220022088 | RAMIREZ MESA JULIAN ALBERTO         | 05% descuento                                        |
| 201222000075 | RAMIREZ MONTOYA ANDRES              | No descuento                                         |
| 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO       | No descuento                                         |
| 201222004075 | VEGA MAZO OMAIRA MARIA              | No descuento                                         |
| 201222005075 | ANDRADE RIVERA JOHAN ALEXIS         | No descuento                                         |
| 201222007073 | AREIZA VERA JOHN FREDY              | No descuento                                         |
| 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA        | No descuento                                         |
| 201223000088 | CALLE PUERTA LILIANA MARIA          | 05% descuento                                        |
| 201223003075 | SERNA ESCOBAR JUAN CARLOS           | No descuento                                         |
| 201224000088 | GRANADA MESA VICTOR ALONSO          | 05% descuento                                        |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      | No descuento                                         |
| 201310016075 | VALDERRAMA MAHECHA  DIEGO ALEJANDRO | No descuento                                         |
| 201310026075 | ANGARITA TORRES IRAMA               | No descuento                                         |
| 201312001088 | VARELA BEDOYA DAISSY ANDREA         | 05% descuento                                        |
| 201312004075 | MUNERA CARDENAS JOHN JAIRO          | No descuento                                         |
| 201312007075 | CARO BEDOYA WALTER DAVIDSON         | No descuento                                         |
| 201312008075 | JARAMILLO LUIS FERNANDO             | No descuento                                         |
| 201313001075 | CUESTA CUERVO  YURY LORENA          | No descuento                                         |
| 201313006075 | TEJADA CASTRO ANDR心 FELIPE         | No descuento                                         |
| 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO    | No descuento                                         |
| 201320002073 | LEON ESTEVEZ DEISY YOLIMA           | No descuento                                         |
| 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA       | No descuento                                         |
| 201320003072 | LOPEZ BLANDON LUISA FERNANDA        | No descuento                                         |
| 201320004072 | PATI･O FLOREZ MARIA ANDREA          | No descuento                                         |
| 201320005073 | HOYOS HENAO JORGE NILTON            | No descuento                                         |
| 201320005086 | GUTIERREZ SEGURO  BEATRIZ           | No descuento                                         |
| 201320006073 | RUIZ RIVERA ISABEL                  | No descuento                                         |
| 201320006074 | YEPES HENAO MONICA                  | No descuento                                         |
| 201320008059 | RODRIGUEZ VILLA YOHAN SEBASTIAN     | No descuento                                         |
| 201320008060 | LONDO･O MU･OZ  MARISOL              | No descuento                                         |
| 201320009070 | MAZO MARIN ANA MARIA                | No descuento                                         |
| 201320010075 | CORREA CORREA ANGELICA MARIA        | No descuento                                         |
| 201320011059 | MU･OZ LOPEZ JONATHATAN FELIPE       | No descuento                                         |
| 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS      | No descuento                                         |
| 201320013070 | TIECK MACIAS NICOLAS                | No descuento                                         |
| 201320013074 | MURILLO MURILLO VIDAL CAMILO        | No descuento                                         |
| 201320016070 | GRISALES ISAZA PAOLA ANDREA         | No descuento                                         |
| 201320021075 | PEREZ  YEISON FABIAN                | No descuento                                         |
| 201320024070 | BOLA･O MADERA  MAIRA MIRITH         | No descuento                                         |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        | No descuento                                         |
| 201324013073 | VELEZ DIANA MARCELA                 | No descuento                                         |
+--------------+-------------------------------------+------------------------------------------------------+
91 rows in set (0.003 sec)

MariaDB [CadenaParcial1Parte1]> select carnet,nombre,if(carnet like'%073','Es de contaduria','Es de otra carrera') from discente;
+--------------+-------------------------------------+---------------------------------------------------------------+
| carnet       | nombre                              | if(carnet like'%073','Es de contaduria','Es de otra carrera') |
+--------------+-------------------------------------+---------------------------------------------------------------+
| 200820036073 | RIOS QUINCHIA TATIANA               | Es de contaduria                                              |
| 200820040075 | WALTON MAYA NATALIA MARIA           | Es de otra carrera                                            |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER       | Es de otra carrera                                            |
| 200910007073 | ZAPATA VALENCIA OLGA LUCIA          | Es de contaduria                                              |
| 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER    | Es de otra carrera                                            |
| 200910069073 | FUENTES FLOREZ JESSICA VIVIANA      | Es de contaduria                                              |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO       | Es de otra carrera                                            |
| 200920009075 | ATEHORTUA LONDO･O JUAN CAMILO       | Es de otra carrera                                            |
| 200920013073 | SILVA ARIAS NANCY CRISTINA          | Es de contaduria                                              |
| 201010002075 | VANEGAS AGUDELO ETHAN ARLEY         | Es de otra carrera                                            |
| 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA     | Es de otra carrera                                            |
| 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN     | Es de otra carrera                                            |
| 201020006088 | CARDONA CHICA DIEGO FERNANDO        | Es de otra carrera                                            |
| 201110005088 | NARANJO DE LOS RIOS MONICA MARIA    | Es de otra carrera                                            |
| 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN        | Es de otra carrera                                            |
| 201110016075 | GOMEZ GOMEZ JULIO CESAR             | Es de otra carrera                                            |
| 201110017088 | GRAJALES MU･OZ VICTOR CAMILO        | Es de otra carrera                                            |
| 201110019088 | CASTRO NAVIA KARINA                 | Es de otra carrera                                            |
| 201110020075 | MARTINEZ VALENCIA JHON DENNIS       | Es de otra carrera                                            |
| 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN       | Es de otra carrera                                            |
| 201110034075 | RODRIGUEZ CARDONA YENY ANDREA       | Es de otra carrera                                            |
| 201110058073 | BURGOS ECHEVERRY LISBETH            | Es de contaduria                                              |
| 201116027075 | CARMONA TABORDA JOHN ALEXANDER      | Es de otra carrera                                            |
| 201116037075 | MANYOMA GARCIA HENSLLY              | Es de otra carrera                                            |
| 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE      | Es de contaduria                                              |
| 201120011088 | ASPRILLA LEUDO YILMAR               | Es de otra carrera                                            |
| 201120028073 | OSPINA DAVID DORA ALBA              | Es de contaduria                                              |
| 201120030073 | VELASQUEZ ACEVEDO BIVIANA ELIZABETH | Es de contaduria                                              |
| 201120036073 | MENA ARTEAGA JUAN NORBERTO          | Es de contaduria                                              |
| 201126012075 | ALVARADO RESTREPO ESTEBAN           | Es de otra carrera                                            |
| 201126016075 | MESA ROLDAN JAVIER ALBERTO          | Es de otra carrera                                            |
| 201210005088 | HERRERA CARDONA JUAN DANIEL         | Es de otra carrera                                            |
| 201210007075 | OCAMPO NARANJO LUIS FELIPE          | Es de otra carrera                                            |
| 201210009075 | MOSQUERA PALACIOS NELSON JHAIR      | Es de otra carrera                                            |
| 201210009088 | COLLAZO PATI･O  ALEX FERNEY         | Es de otra carrera                                            |
| 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE    | Es de otra carrera                                            |
| 201210022088 | OROZCO CARMONA DIDIER               | Es de otra carrera                                            |
| 201210030075 | CAICEDO CABEZAS JOHE ALDREITH       | Es de otra carrera                                            |
| 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY    | Es de otra carrera                                            |
| 201212003075 | ZAPATA ZU･IGA ADRIANA PATRICIA      | Es de otra carrera                                            |
| 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH   | Es de otra carrera                                            |
| 201213000088 | MONTOYA HENAO MARCELA               | Es de otra carrera                                            |
| 201213002088 | ZULUAGA LONDO･O ANGELA CRISTINA     | Es de otra carrera                                            |
| 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO       | Es de otra carrera                                            |
| 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER   | Es de otra carrera                                            |
| 201220003075 | BLANDON LONDO･O CRISTIAN MAURICIO   | Es de otra carrera                                            |
| 201220004075 | VALLEJO MAZO PAOLA ANDREA           | Es de otra carrera                                            |
| 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA     | Es de otra carrera                                            |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA   | Es de otra carrera                                            |
| 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER  | Es de otra carrera                                            |
| 201220022088 | RAMIREZ MESA JULIAN ALBERTO         | Es de otra carrera                                            |
| 201222000075 | RAMIREZ MONTOYA ANDRES              | Es de otra carrera                                            |
| 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO       | Es de otra carrera                                            |
| 201222004075 | VEGA MAZO OMAIRA MARIA              | Es de otra carrera                                            |
| 201222005075 | ANDRADE RIVERA JOHAN ALEXIS         | Es de otra carrera                                            |
| 201222007073 | AREIZA VERA JOHN FREDY              | Es de contaduria                                              |
| 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA        | Es de contaduria                                              |
| 201223000088 | CALLE PUERTA LILIANA MARIA          | Es de otra carrera                                            |
| 201223003075 | SERNA ESCOBAR JUAN CARLOS           | Es de otra carrera                                            |
| 201224000088 | GRANADA MESA VICTOR ALONSO          | Es de otra carrera                                            |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      | Es de otra carrera                                            |
| 201310016075 | VALDERRAMA MAHECHA  DIEGO ALEJANDRO | Es de otra carrera                                            |
| 201310026075 | ANGARITA TORRES IRAMA               | Es de otra carrera                                            |
| 201312001088 | VARELA BEDOYA DAISSY ANDREA         | Es de otra carrera                                            |
| 201312004075 | MUNERA CARDENAS JOHN JAIRO          | Es de otra carrera                                            |
| 201312007075 | CARO BEDOYA WALTER DAVIDSON         | Es de otra carrera                                            |
| 201312008075 | JARAMILLO LUIS FERNANDO             | Es de otra carrera                                            |
| 201313001075 | CUESTA CUERVO  YURY LORENA          | Es de otra carrera                                            |
| 201313006075 | TEJADA CASTRO ANDR心 FELIPE         | Es de otra carrera                                            |
| 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO    | Es de contaduria                                              |
| 201320002073 | LEON ESTEVEZ DEISY YOLIMA           | Es de contaduria                                              |
| 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA       | Es de otra carrera                                            |
| 201320003072 | LOPEZ BLANDON LUISA FERNANDA        | Es de otra carrera                                            |
| 201320004072 | PATI･O FLOREZ MARIA ANDREA          | Es de otra carrera                                            |
| 201320005073 | HOYOS HENAO JORGE NILTON            | Es de contaduria                                              |
| 201320005086 | GUTIERREZ SEGURO  BEATRIZ           | Es de otra carrera                                            |
| 201320006073 | RUIZ RIVERA ISABEL                  | Es de contaduria                                              |
| 201320006074 | YEPES HENAO MONICA                  | Es de otra carrera                                            |
| 201320008059 | RODRIGUEZ VILLA YOHAN SEBASTIAN     | Es de otra carrera                                            |
| 201320008060 | LONDO･O MU･OZ  MARISOL              | Es de otra carrera                                            |
| 201320009070 | MAZO MARIN ANA MARIA                | Es de otra carrera                                            |
| 201320010075 | CORREA CORREA ANGELICA MARIA        | Es de otra carrera                                            |
| 201320011059 | MU･OZ LOPEZ JONATHATAN FELIPE       | Es de otra carrera                                            |
| 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS      | Es de contaduria                                              |
| 201320013070 | TIECK MACIAS NICOLAS                | Es de otra carrera                                            |
| 201320013074 | MURILLO MURILLO VIDAL CAMILO        | Es de otra carrera                                            |
| 201320016070 | GRISALES ISAZA PAOLA ANDREA         | Es de otra carrera                                            |
| 201320021075 | PEREZ  YEISON FABIAN                | Es de otra carrera                                            |
| 201320024070 | BOLA･O MADERA  MAIRA MIRITH         | Es de otra carrera                                            |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        | Es de otra carrera                                            |
| 201324013073 | VELEZ DIANA MARCELA                 | Es de contaduria                                              |
+--------------+-------------------------------------+---------------------------------------------------------------+
91 rows in set (0.002 sec)

MariaDB [CadenaParcial1Parte1]> select carnet,nombre from Discente where nombre like `%i%' and substr(carnet, 10,3)in ('075');
    `> select carnet,nombre from Discente where nombre like '%i%' and substr(carnet, 10,3)in ('075');
    `> ;
    `> select carnet,nombre from Discente where nombre like '%i%' and substr(carnet, 10,3)in ('075');
    `> ;
    `> );
    `> select carnet, nombre from Discente where nombre like '%i%' and substr(carnet, 10, 3) in ('075');
    `> ;
    `> ;
    `> exit
    `> exit;
    `>