MariaDB [aplicacion_cadena]> show databases;
+--------------------+
| Database           |
+--------------------+
| academico          |
| aplicacion_cadena  |
| comercial          |
| consulta_externa   |
| facturacion        |
| information_schema |
| institucion        |
| institucion1       |
| libreria           |
| matricula2         |
| mysql              |
| performance_schema |
| phpmyadmin         |
| secundaria         |
| test               |
| urgencias          |
+--------------------+
16 rows in set (0.14 sec)

MariaDB [aplicacion_cadena]> show tables;
+-----------------------------+
| Tables_in_aplicacion_cadena |
+-----------------------------+
| discente                    |
+-----------------------------+
1 row in set (0.00 sec)

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

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

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

MariaDB [aplicacion_cadena]> select count(*) from discente where substr(carnet,10,3) in ('075');
+----------+
| count(*) |
+----------+
|       46 |
+----------+
1 row in set (0.04 sec)

MariaDB [aplicacion_cadena]> select nombre 'Caracteres menos de 25' from discente where character_length(nombre)<25;
+--------------------------+
| Caracteres menos de 25   |
+--------------------------+
| GOMEZ GOMEZ JULIO CESAR  |
| MANYOMA GARCIA HENSLLY   |
| PEREZ  YEISON FABIAN     |
| ASPRILLA LEUDO YILMAR    |
| OROZCO CARMONA DIDIER    |
| RAMIREZ MONTOYA ANDRES   |
| MONTOYA HENAO MARCELA    |
| PEREZ  YEISON FABIAN     |
| ANGARITA TORRES IRAMA    |
| VEGA MAZO OMAIRA MARIA   |
| CASTRO NAVIA KARINA      |
| AREIZA VERA JOHN FREDY   |
| BURGOS ECHEVERRY LISBETH |
| JARAMILLO LUIS FERNANDO  |
| OSPINA DAVID DORA ALBA   |
| RIOS QUINCHIA TATIANA    |
| VELEZ DIANA MARCELA      |
| HOYOS HENAO JORGE NILTON |
| LONDO･O MU･OZ  MARISOL   |
| MAZO MARIN ANA MARIA     |
| RUIZ RIVERA ISABEL       |
| TIECK MACIAS NICOLAS     |
| YEPES HENAO MONICA       |
+--------------------------+
23 rows in set (0.05 sec)

MariaDB [aplicacion_cadena]> select count(*) from discente where substr(carnet,10,3) not in ('088');
+----------+
| count(*) |
+----------+
|       76 |
+----------+
1 row in set (0.00 sec)

MariaDB [aplicacion_cadena]> select count(*)'iniciaron en el a､o 2012' from discente where substr(carnet,1,4) in ('2012');
+--------------------------+
| iniciaron en el a､o 2012 |
+--------------------------+
|                       31 |
+--------------------------+
1 row in set (0.00 sec)

MariaDB [aplicacion_cadena]> select count(*)'Iniciaron Primer Semestre' from discente where substr(carnet,5,1) in ('1');
+---------------------------+
| Iniciaron Primer Semestre |
+---------------------------+
|                        44 |
+---------------------------+
1 row in set (0.00 sec)

MariaDB [aplicacion_cadena]> select count(*)'Matriculados antes del 2013' from discente where substr(carnet,1,4)<('2013');
+-----------------------------+
| Matriculados antes del 2013 |
+-----------------------------+
|                          65 |
+-----------------------------+
1 row in set (0.00 sec)

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

MariaDB [aplicacion_cadena]> select carnet,nombre from discente where substr(carnet,10,3) in ('075') and substr(carnet,1,4)<('2012');
+--------------+----------------------------------+
| carnet       | nombre                           |
+--------------+----------------------------------+
| 201126012075 | ALVARADO RESTREPO ESTEBAN        |
| 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN     |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER    |
| 201116027075 | CARMONA TABORDA JOHN ALEXANDER   |
| 201110016075 | GOMEZ GOMEZ JULIO CESAR          |
| 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN    |
| 201116037075 | MANYOMA GARCIA HENSLLY           |
| 201110020075 | MARTINEZ VALENCIA JHON DENNIS    |
| 201010002075 | VANEGAS AGUDELO ETHAN ARLEY      |
| 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER    |
| 201126016075 | MESA ROLDAN JAVIER ALBERTO       |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO    |
| 200820040075 | WALTON MAYA NATALIA MARIA        |
| 200920009075 | ATEHORTUA LONDO･O JUAN CAMILO    |
| 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA  |
| 201110034075 | RODRIGUEZ CARDONA YENY ANDREA    |
+--------------+----------------------------------+
17 rows in set (0.00 sec)

MariaDB [aplicacion_cadena]> select min(substr(carnet,1,12)) from discente where substr(carnet,10,3) not in ('075','088');
+--------------------------+
| min(substr(carnet,1,12)) |
+--------------------------+
| 200820036073             |
+--------------------------+
1 row in set (0.00 sec)

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

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

MariaDB [aplicacion_cadena]> select * from discente where substr(carnet,10,3) in ('075') and nombre like '%i%'; 
+--------------+-------------------------------------+
| carnet       | nombre                              |
+--------------+-------------------------------------+
| 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN        |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER       |
| 201320010075 | CORREA CORREA ANGELICA MARIA        |
| 201110016075 | GOMEZ GOMEZ JULIO CESAR             |
| 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN       |
| 201116037075 | MANYOMA GARCIA HENSLLY              |
| 201110020075 | MARTINEZ VALENCIA JHON DENNIS       |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH   |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
| 201210009075 | MOSQUERA PALACIOS NELSON JHAIR      |
| 201210007075 | OCAMPO NARANJO LUIS FELIPE          |
| 201222000075 | RAMIREZ MONTOYA ANDRES              |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER       |
| 201210030075 | CAICEDO CABEZAS JOHE ALDREITH       |
| 201126016075 | MESA ROLDAN JAVIER ALBERTO          |
| 201312004075 | MUNERA CARDENAS JOHN JAIRO          |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201313006075 | TEJADA CASTRO ANDR心 FELIPE         |
| 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH   |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO       |
| 201212003075 | ZAPATA ZU･IGA ADRIANA PATRICIA      |
| 201222005075 | ANDRADE RIVERA JOHAN ALEXIS         |
| 201310026075 | ANGARITA TORRES IRAMA               |
| 201312007075 | CARO BEDOYA WALTER DAVIDSON         |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA   |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      |
| 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201222004075 | VEGA MAZO OMAIRA MARIA              |
| 200820040075 | WALTON MAYA NATALIA MARIA           |
| 200920009075 | ATEHORTUA LONDO･O JUAN CAMILO       |
| 201220003075 | BLANDON LONDO･O CRISTIAN MAURICIO   |
| 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA     |
| 201110034075 | RODRIGUEZ CARDONA YENY ANDREA       |
| 201310016075 | VALDERRAMA MAHECHA  DIEGO ALEJANDRO |
| 201312008075 | JARAMILLO LUIS FERNANDO             |
| 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
+--------------+-------------------------------------+
37 rows in set (0.00 sec)

MariaDB [aplicacion_cadena]> exit