MariaDB [aplicacion_cadena]> create table discente(
    -> carnet BIGINT primary key,
    -> nombre VARCHAR(50) not null);
Query OK, 0 rows affected (0,018 sec)

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

MariaDB [aplicacion_cadena]> INSERT INTO discente (carnet, nombre) VALUES
    -> (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'),
    -> (201210030075, 'CAICEDO CABEZAS JOHE ALDREITH'),
    -> (201126016075, 'MESA ROLDAN JAVIER ALBERTO'),
    -> (201213000088, 'MONTOYA HENAO MARCELA'),
    -> (201312004075, 'MUNERA CARDENAS JOHN JAIRO'),
    -> (201220022088, 'RAMIREZ MESA JULIAN ALBERTO'),
    -> (201313006075, 'TEJADA CASTRO ANDRÉS FELIPE'),
    -> (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'),
    -> (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'),
    -> (201110019088, 'CASTRO NAVIA KARINA'),
    -> (201020003088, 'CEBALLOS BETANCUR DANIEL STEVEN'),
    -> (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'),
    -> (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');
Query OK, 90 rows affected (0,010 sec)
Records: 90  Duplicates: 0  Warnings: 0

MariaDB [aplicacion_cadena]> select * from discent;
ERROR 1146 (42S02): Table 'aplicacion_cadena.discent' doesn't exist
MariaDB [aplicacion_cadena]> 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     |
| 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ÉS 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 | GUTÍERREZ 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                 |
+--------------+-------------------------------------+
90 rows in set (0,001 sec)

MariaDB [aplicacion_cadena]> select carnet, nombre from discente WHERE RIGHT(carnet, 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    |
| 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ÉS FELIPE        |
| 201320010075 | CORREA CORREA ANGELICA MARIA       |
| 201320021075 | PEREZ YEISON FABIAN                |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD       |
+--------------+------------------------------------+
60 rows in set (0,003 sec)

MariaDB [aplicacion_cadena]> select COUNT(*) AS total_ingenieria FROM discente WHERE RIGHT(carnet, 3) = '075';
+------------------+
| total_ingenieria |
+------------------+
|               41 |
+------------------+
1 row in set (0,001 sec)

MariaDB [aplicacion_cadena]> select nombre from discente WHERE CHAR_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   |
| CUESTA CUERVO YURY LORENA |
| LEON ESTEVEZ DEISY YOLIMA |
| HOYOS HENAO JORGE NILTON  |
| GUTÍERREZ 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       |
+---------------------------+
29 rows in set (0,001 sec)

MariaDB [aplicacion_cadena]> sintaxis: select COUNT(*) AS total_no_tecnologia_s FROM discente WHERE RIGHT(carnet, 3) != '088';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'sintaxis: select COUNT(*) AS total_no_tecnologia_s FROM discente WHERE RIGHT(...' at line 1
MariaDB [aplicacion_cadena]> select COUNT(*) AS total_no_tecnologia_s FROM discente WHERE RIGHT(carnet, 3) != '088';
+-----------------------+
| total_no_tecnologia_s |
+-----------------------+
|                    71 |
+-----------------------+
1 row in set (0,001 sec)

MariaDB [aplicacion_cadena]> select COUNT(*) AS total_2012 from discente WHERE LEFT(canet, 4) = '2012';
ERROR 1054 (42S22): Unknown column 'canet' in 'where clause'
MariaDB [aplicacion_cadena]> select COUNT(*) AS total_2012 from discente WHERE LEFT(carnet, 4) = '2012';
+------------+
| total_2012 |
+------------+
|         28 |
+------------+
1 row in set (0,001 sec)

MariaDB [aplicacion_cadena]> select COUNT(*) AS total_2012 from discente WHERE SUBSTR(carnet, 1, 4) = '2012';
+------------+
| total_2012 |
+------------+
|         28 |
+------------+
1 row in set (0,001 sec)

MariaDB [aplicacion_cadena]> select COUNT(*) AS primer_year from discente WHERE SUBSTR(carnet,5,1)= '1';
+-------------+
| primer_year |
+-------------+
|          39 |
+-------------+
1 row in set (0,001 sec)

MariaDB [aplicacion_cadena]> select COUNT(*) AS menor_2012 from discente WHERE SUBSTR(carnet, 1, 4) <= '2012';
+------------+
| menor_2012 |
+------------+
|         59 |
+------------+
1 row in set (0,001 sec)

MariaDB [aplicacion_cadena]> SELECT carnet, nombre FROM discente ORDER BY SUBSTR(carnet, 1, 4) ASC;
+--------------+-------------------------------------+
| carnet       | nombre                              |
+--------------+-------------------------------------+
| 200820036073 | RIOS QUINCHIA TATIANA               |
| 200820040075 | WALTON MAYA NATALIA MARIA           |
| 200920013073 | SILVA ARIAS NANCY CRISTINA          |
| 200920009075 | ATEHORTUA LONDOÑO JUAN CAMILO       |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO       |
| 200910069073 | FUENTES FLOREZ JESSICA VIVIANA      |
| 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER    |
| 200910007073 | ZAPATA VALENCIA OLGA LUCIA          |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER       |
| 201020006088 | CARDONA CHICA DIEGO FERNANDO        |
| 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN     |
| 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA     |
| 201010002075 | VANEGAS AGUDELO ETHAN ARLEY         |
| 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          |
| 201116027075 | CARMONA TABORDA JOHN ALEXANDER      |
| 201110058073 | BURGOS ECHEVERRY LISBETH            |
| 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       |
| 201222000075 | RAMIREZ MONTOYA ANDRES              |
| 201220022088 | RAMIREZ MESA JULIAN ALBERTO         |
| 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER  |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA   |
| 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA     |
| 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          |
| 201220004075 | VALLEJO MAZO PAOLA ANDREA           |
| 201220003075 | BLANDON LONDOÑO CRISTIAN MAURICIO   |
| 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     |
| 201220002075 | LONDOÑO FONNEGRA JHONNY ALEXANDER   |
| 201320011059 | MUÑOZ LOPEZ JONATHATAN FELIPE       |
| 201320010075 | CORREA CORREA ANGELICA MARIA        |
| 201320009070 | MAZO MARIN ANA MARIA                |
| 201320008060 | LONDOÑO MUÑOZ MARISOL               |
| 201320008059 | RODRIGUEZ VILLA YOHAN SEBASTIAN     |
| 201320006074 | YEPES HENAO MONICA                  |
| 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                 |
| 201320006073 | RUIZ RIVERA ISABEL                  |
| 201320005086 | GUTÍERREZ SEGURO BEATRIZ            |
| 201320005073 | HOYOS HENAO JORGE NILTON            |
| 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ÉS 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          |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      |
+--------------+-------------------------------------+
90 rows in set (0,001 sec)

MariaDB [aplicacion_cadena]> SELECT carnet, nombre FROM discente WHERE RIGHT(carnet, 3) = '075' AND SUBSTR(carnet, 1, 4) < '2012' AND SUBSTR(carnet, 5, 1) = '2';
+--------------+--------------------------------+
| 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 [aplicacion_cadena]> SELECT MIN(SUBSTR(carnet, 6, 4)) AS codigo_menor FROM discente WHERE RIGHT(carnet, 3) != '075';
+--------------+
| codigo_menor |
+--------------+
| 0002         |
+--------------+
1 row in set (0,001 sec)

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

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

MariaDB [aplicacion_cadena]> SELECT carnet, nombre FROM discente WHERE RIGHT(carnet,3) = '075' AND nombre LIKE '%i%';
+--------------+------------------------------------+
| carnet       | nombre                             |
+--------------+------------------------------------+
| 200820040075 | WALTON MAYA NATALIA MARIA          |
| 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER      |
| 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO      |
| 200920009075 | ATEHORTUA LONDOÑO JUAN CAMILO      |
| 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      |
| 201116037075 | MANYOMA GARCIA HENSLLY             |
| 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  |
| 201220003075 | BLANDON LONDOÑO CRISTIAN MAURICIO  |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA  |
| 201222000075 | RAMIREZ MONTOYA ANDRES             |
| 201222004075 | VEGA MAZO OMAIRA MARIA             |
| 201222005075 | ANDRADE RIVERA JOHAN ALEXIS        |
| 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            |
| 201313006075 | TEJADA CASTRO ANDRÉS FELIPE        |
| 201320010075 | CORREA CORREA ANGELICA MARIA       |
| 201320021075 | PEREZ YEISON FABIAN                |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD       |
+--------------+------------------------------------+
32 rows in set (0,001 sec)

MariaDB [aplicacion_cadena]> notee;