MariaDB [fecha]> show tables;
+-----------------+
| Tables_in_fecha |
+-----------------+
| estmat          |
| materia         |
+-----------------+
2 rows in set (0.001 sec)

MariaDB [fecha]>  create table estudiante(carnet varchar(4) not null primary
    -> key,
    -> nombre varchar(20) not null,
    -> fechamatricula Date,
    -> fechanacimiento Date,
    -> sexo varchar(1) not null);
Query OK, 0 rows affected (0.024 sec)

MariaDB [fecha]> insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('001', 'maria', "2010-01-15", "1966-05-13", 'f');
Query OK, 1 row affected (0.005 sec)

MariaDB [fecha]> select * from estudiante;
+--------+--------+----------------+-----------------+------+
| carnet | nombre | fechamatricula | fechanacimiento | sexo |
+--------+--------+----------------+-----------------+------+
| 001    | maria  | 2010-01-15     | 1966-05-13      | f    |
+--------+--------+----------------+-----------------+------+
1 row in set (0.001 sec)

MariaDB [fecha]> insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('002', 'juana', "2010-06-08", "1973-01-22", 'f');
Query OK, 1 row affected (0.004 sec)

MariaDB [fecha]>  insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('003', 'carlos', "2010-06-28", "1976-03-05", 'm');
Query OK, 1 row affected (0.004 sec)

MariaDB [fecha]> insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('004', 'Maria parra', "2010-06-11", "1976-08-15", 'f');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('005', 'Pablo neruda', 2011-02-13, 1990-08-25, 'm');
Query OK, 1 row affected, 2 warnings (0.004 sec)

MariaDB [fecha]>  insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('006', 'Bladimir palacio', 2011-02-04, 1994-09-03, 'm');
Query OK, 1 row affected, 2 warnings (0.003 sec)

MariaDB [fecha]>  insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('007', 'Apolonia serrano', 2011-02-28, 1994-03-09, 'f');
Query OK, 1 row affected, 2 warnings (0.003 sec)

MariaDB [fecha]> delete from estudiante where nombre="pablo neruda";
Query OK, 1 row affected (0.004 sec)

MariaDB [fecha]> delete from estudiante where nombre="Bladimir palacio";
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> delete from estudiante where nombre="Bladimir palacio";
Query OK, 0 rows affected (0.001 sec)

MariaDB [fecha]> delete from estudiante where nombre="Apolonia serrano";
Query OK, 1 row affected (0.004 sec)

MariaDB [fecha]> insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('005', 'Pablo neruda', "2011-02-13", "1990-08-25", 'm');
Query OK, 1 row affected (0.004 sec)

MariaDB [fecha]>  insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('006', 'Bladimir palacio', "2011-02-04", "1994-09-03", 'm');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]>  insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('007', 'Apolonia serrano', "2011-02-28", "1994-03-09", 'f');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('008', 'Federico serrano', "2011-03-05", "1991-06-10", 'm');
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 'into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values...' at line 1
MariaDB [fecha]> into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('008', 'Federico serrano', "2011-03-05", "1991-06-10", 'm');
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 'into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values...' at line 1
MariaDB [fecha]> select * from estudiante;
+--------+------------------+----------------+-----------------+------+
| carnet | nombre           | fechamatricula | fechanacimiento | sexo |
+--------+------------------+----------------+-----------------+------+
| 001    | maria            | 2010-01-15     | 1966-05-13      | f    |
| 002    | juana            | 2010-06-08     | 1973-01-22      | f    |
| 003    | carlos           | 2010-06-28     | 1976-03-05      | m    |
| 004    | Maria parra      | 2010-06-11     | 1976-08-15      | f    |
| 005    | Pablo neruda     | 2011-02-13     | 1990-08-25      | m    |
| 006    | Bladimir palacio | 2011-02-04     | 1994-09-03      | m    |
| 007    | Apolonia serrano | 2011-02-28     | 1994-03-09      | f    |
+--------+------------------+----------------+-----------------+------+
7 rows in set (0.001 sec)

MariaDB [fecha]>  insert into estudiante(carnet, nombre, fechamatricula, fechanacimiento, sexo) values('008', 'Federico serrano', "2011-03-05", "1991-06-10", 'm');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> select * from estudiante;
+--------+------------------+----------------+-----------------+------+
| carnet | nombre           | fechamatricula | fechanacimiento | sexo |
+--------+------------------+----------------+-----------------+------+
| 001    | maria            | 2010-01-15     | 1966-05-13      | f    |
| 002    | juana            | 2010-06-08     | 1973-01-22      | f    |
| 003    | carlos           | 2010-06-28     | 1976-03-05      | m    |
| 004    | Maria parra      | 2010-06-11     | 1976-08-15      | f    |
| 005    | Pablo neruda     | 2011-02-13     | 1990-08-25      | m    |
| 006    | Bladimir palacio | 2011-02-04     | 1994-09-03      | m    |
| 007    | Apolonia serrano | 2011-02-28     | 1994-03-09      | f    |
| 008    | Federico serrano | 2011-03-05     | 1991-06-10      | m    |
+--------+------------------+----------------+-----------------+------+
8 rows in set (0.001 sec)

MariaDB [fecha]> insert into materia(codigom, descripcion, valor) values('001', 'software I', "320000");
Query OK, 1 row affected (0.005 sec)

MariaDB [fecha]> insert into materia(codigom, descripcion, valor) values('002', 'software II', "328000");
Query OK, 1 row affected (0.009 sec)

MariaDB [fecha]> insert into materia(codigom, descripcion, valor) values('003', 'software III', "400000");
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into materia(codigom, descripcion, valor) values('004', 'matematicas', "300000");
Query OK, 1 row affected (0.004 sec)

MariaDB [fecha]> insert into materia(codigom, descripcion, valor) values('005', 'ingles', "300000");
Query OK, 1 row affected (0.010 sec)

MariaDB [fecha]> select * from materia;
+---------+--------------+--------+
| codigom | descripcion  | valor  |
+---------+--------------+--------+
| 001     | software I   | 320000 |
| 002     | software II  | 328000 |
| 003     | software III | 400000 |
| 004     | matematicas  | 300000 |
| 005     | ingles       | 300000 |
+---------+--------------+--------+
5 rows in set (0.001 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('1', '3');
Query OK, 1 row affected (0.011 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('1', '5');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('2', '2');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('2', '3');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('2', '4');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('3', '4');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('3', '1');
Query OK, 1 row affected (0.002 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('4', '4');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('4', '5');
Query OK, 1 row affected (0.010 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('5', '2');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('5', '5');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('6', '1');
Query OK, 1 row affected (0.001 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('6', '5');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('7', '3');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('7', '4');
Query OK, 1 row affected (0.004 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('8', '1');
Query OK, 1 row affected (0.004 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('8', '4');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> insert into estmat(carnet, codigom) values('8', '5');
Query OK, 1 row affected (0.003 sec)

MariaDB [fecha]> select * from estmat;
+--------+---------+
| carnet | codigom |
+--------+---------+
| 1      | 3       |
| 1      | 5       |
| 2      | 2       |
| 2      | 3       |
| 2      | 4       |
| 3      | 4       |
| 3      | 1       |
| 4      | 4       |
| 4      | 5       |
| 5      | 2       |
| 5      | 5       |
| 6      | 1       |
| 6      | 5       |
| 7      | 3       |
| 7      | 4       |
| 8      | 1       |
| 8      | 4       |
| 8      | 5       |
+--------+---------+
18 rows in set (0.001 sec)

MariaDB [aplicacion_cadena]>  select carnet,nombre from discente where substr(carnet, 10,12) 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       |
| 201110117088 | GRAJALES MU･OZ VICTOR CAMILO        |
| 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         |
| 201314004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201320010075 | CORREA CORREA ANGELICA MARIA        |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
+--------------+-------------------------------------+
63 rows in set (0.001 sec)

MariaDB [aplicacion_cadena]>  select carnet,nombre from discente where substr(carnet, 10,12) 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         |
| 201314004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201320010075 | CORREA CORREA ANGELICA MARIA        |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
+--------------+-------------------------------------+
43 rows in set (0.001 sec)

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

MariaDB [aplicacion_cadena]>  select carnet,nombre from discente where substr(carnet, 10,12) not in ('075', '088');
+--------------+-------------------------------------+
| carnet       | nombre                              |
+--------------+-------------------------------------+
| 200820036073 | RIOS QUINCHIA TATIANA               |
| 200910007073 | ZAPATA VALENCIA OLGA LUCIA          |
| 200910069073 | FUENTES FLOREZ JESSICA VIVIANA      |
| 200920013073 | SILVA ARIAS NANCY CRISTINA          |
| 201110058073 | BURGOS ECHEVERRY LISBETH            |
| 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE      |
| 201120028073 | OSPINA DAVID DORA ALBA              |
| 201120030073 | VELASQUEZ ACEVEDO BIVIANA ELIZABETH |
| 201120036073 | MENA ARTEAGA JUAN NORBERTO          |
| 201222007073 | AREIZA VERA JOHN FREDY              |
| 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA        |
| 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                |
| 201320011059 | MU･OZ LOPEZ JONATHATAN FELIPE       |
| 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS      |
| 201320013070 | TIECK MACIAS NICOLAS                |
| 201320013074 | MURILLO MURILLO VIDAL CAMILO        |
| 201320024070 | BOLA･O MADERA  MAIRA MIRITH         |
| 201324013073 | VELEZ DIANA MARCELA                 |
+--------------+-------------------------------------+
29 rows in set (0.001 sec)

MariaDB [aplicacion_cadena]> select * from discente where substr(carnet,1,4) in ('2012')
    -> ;
+--------------+------------------------------------+
| carnet       | nombre                             |
+--------------+------------------------------------+
| 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         |
+--------------+------------------------------------+
29 rows in set (0.001 sec)

MariaDB [aplicacion_cadena]> select count(nombre) from discente where substr(carnet,5,1) in ('1');
+---------------+
| count(nombre) |
+---------------+
|            42 |
+---------------+
1 row in set (0.001 sec)

MariaDB [aplicacion_cadena]> select * from alumno where substr(carnet,1,4) in ('2013') and substr(carnet,4,1) and substr(carnet,4,1) < ('2013');
ERROR 1146 (42S02): Table 'aplicacion_cadena.alumno' doesn't exist
MariaDB [aplicacion_cadena]> select * from discente where substr(carnet,1,4) in ('2013') and substr(carnet,4,1) and substr(carnet,4,1) < ('2013');
Empty set (0.001 sec)

MariaDB [aplicacion_cadena]> select * from discente where substr(carnet,1,4) in ('2013') and substr(carnet,4,1) and substr(carnet,1,4) < ('2013');
Empty set (0.001 sec)

MariaDB [aplicacion_cadena]> select * from discente where substr(carnet,1,4) in ('2013') and substr(carnet,1,4) and substr(carnet,1,4) < ('2013');
Empty set (0.001 sec)

MariaDB [aplicacion_cadena]> select * from discente order by substr(carnet,1,4);
+--------------+-------------------------------------+
| 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      |
| 201110117088 | GRAJALES MU･OZ VICTOR CAMILO        |
| 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   |
| 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER   |
| 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       |
| 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                  |
| 201320006073 | RUIZ RIVERA ISABEL                  |
| 201320011059 | MU･OZ LOPEZ JONATHATAN FELIPE       |
| 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS      |
| 201320013070 | TIECK MACIAS NICOLAS                |
| 201320013074 | MURILLO MURILLO VIDAL CAMILO        |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201320024070 | BOLA･O MADERA  MAIRA MIRITH         |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
| 201324013073 | VELEZ DIANA MARCELA                 |
| 201320005086 | GUTﾖERREZ SEGURO  BEATRIZ           |
| 201320005073 | HOYOS HENAO JORGE NILTON            |
| 201320004072 | PATI･O FLOREZ MARIA ANDREA          |
| 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         |
| 201314004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO    |
| 201320002073 | LEON ESTEVEZ DEISY YOLIMA           |
| 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA       |
| 201320003072 | LOPEZ BLANDON LUISA FERNANDA        |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      |
+--------------+-------------------------------------+
92 rows in set (0.001 sec)

MariaDB [aplicacion_cadena]> select * from discente where substr(carnet,3,4) in ('13') and substr(carnet,5,1) in ('2') and substr(carnet,3,4) < ('13');
Empty set (0.001 sec)

MariaDB [aplicacion_cadena]> select * from discente where substr(carnet,3,4) in ('13') and substr(carnet,5,1) in ('2') and substr(carnet,1,4) < ('13');
Empty set (0.001 sec)

MariaDB [aplicacion_cadena]> select * from discente where substr(carnet,3,4) in ('13') and substr(carnet,5,1) in ('2')  < ('13');
Empty set (0.002 sec)

MariaDB [aplicacion_cadena]> select COUNT(*) 'Matriculas antes del 2013' from discente where substr(carnet,1,4) < ('2013');
+---------------------------+
| Matriculas antes del 2013 |
+---------------------------+
|                        61 |
+---------------------------+
1 row in set (0.001 sec)

MariaDB [aplicacion_cadena]> select * from discente order by substr(carnet,1,4);
+--------------+-------------------------------------+
| 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      |
| 201110117088 | GRAJALES MU･OZ VICTOR CAMILO        |
| 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   |
| 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER   |
| 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       |
| 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                  |
| 201320006073 | RUIZ RIVERA ISABEL                  |
| 201320011059 | MU･OZ LOPEZ JONATHATAN FELIPE       |
| 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS      |
| 201320013070 | TIECK MACIAS NICOLAS                |
| 201320013074 | MURILLO MURILLO VIDAL CAMILO        |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201320024070 | BOLA･O MADERA  MAIRA MIRITH         |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
| 201324013073 | VELEZ DIANA MARCELA                 |
| 201320005086 | GUTﾖERREZ SEGURO  BEATRIZ           |
| 201320005073 | HOYOS HENAO JORGE NILTON            |
| 201320004072 | PATI･O FLOREZ MARIA ANDREA          |
| 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         |
| 201314004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO    |
| 201320002073 | LEON ESTEVEZ DEISY YOLIMA           |
| 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA       |
| 201320003072 | LOPEZ BLANDON LUISA FERNANDA        |
| 201310008075 | GIRALDO VERGARA YOLANDA MILENA      |
+--------------+-------------------------------------+
92 rows in set (0.001 sec)

MariaDB [aplicacion_cadena]> select carnet,nombre from discente where substr(carnet,10,3) in ('075') and substr(carnet,1,4) < ('2012');
+--------------+----------------------------------+
| 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       |
+--------------+----------------------------------+
16 rows in set (0.001 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.002 sec)

MariaDB [aplicacion_cadena]> select carnet, nombre, if(carnet like '%088', '5% Descuento', 'No Descuento') 'informaci｢n' from discente;
+--------------+-------------------------------------+--------------+
| carnet       | nombre                              | informaci｢n  |
+--------------+-------------------------------------+--------------+
| 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     | 5% Descuento |
| 201020006088 | CARDONA CHICA DIEGO FERNANDO        | 5% Descuento |
| 201110005088 | NARANJO DE LOS RIOS MONICA MARIA    | 5% Descuento |
| 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN        | No Descuento |
| 201110016075 | GOMEZ GOMEZ JULIO CESAR             | No Descuento |
| 201110017088 | GRAJALES MU･OZ VICTOR CAMILO        | 5% Descuento |
| 201110019088 | CASTRO NAVIA KARINA                 | 5% 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 |
| 201110117088 | GRAJALES MU･OZ VICTOR CAMILO        | 5% 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               | 5% 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         | 5% Descuento |
| 201210007075 | OCAMPO NARANJO LUIS FELIPE          | No Descuento |
| 201210009075 | MOSQUERA PALACIOS NELSON JHAIR      | No Descuento |
| 201210009088 | COLLAZO PATI･O  ALEX FERNEY         | 5% Descuento |
| 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE    | 5% Descuento |
| 201210022088 | OROZCO CARMONA DIDIER               | 5% Descuento |
| 201210030075 | CAICEDO CABEZAS JOHE ALDREITH       | No Descuento |
| 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY    | 5% Descuento |
| 201212003075 | ZAPATA ZU･IGA ADRIANA PATRICIA      | No Descuento |
| 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH   | No Descuento |
| 201213000088 | MONTOYA HENAO MARCELA               | 5% Descuento |
| 201213002088 | ZULUAGA LONDO･O ANGELA CRISTINA     | 5% 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     | 5% Descuento |
| 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA   | No Descuento |
| 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER  | 5% Descuento |
| 201220022088 | RAMIREZ MESA JULIAN ALBERTO         | 5% 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          | 5% Descuento |
| 201223003075 | SERNA ESCOBAR JUAN CARLOS           | No Descuento |
| 201224000088 | GRANADA MESA VICTOR ALONSO          | 5% 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         | 5% 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 |
| 201314004075 | RADA RODRIGUEZ SILVIO SEGUNDO       | 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 | GUTﾖERREZ 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 |
| 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 |
+--------------+-------------------------------------+--------------+
92 rows in set (0.002 sec)

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

MariaDB [aplicacion_cadena]> select * from discente where substr(carnet,10,3) in ('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   |
| 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 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心 FELIPE         |
| 201314004075 | RADA RODRIGUEZ SILVIO SEGUNDO       |
| 201320010075 | CORREA CORREA ANGELICA MARIA        |
| 201320021075 | PEREZ  YEISON FABIAN                |
| 201324002075 | ASPRILLA MENA WALNHER YHAMYD        |
+--------------+-------------------------------------+
34 rows in set (0.002 sec)

MariaDB [aplicacion_cadena]> exit
MariaDB [fechas]> create table pagos(identi varchar(4) not null primary key,
    -> descripcion varchar(20) not null,
    -> fechaadquisicion Date);
Query OK, 0 rows affected (0.064 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0001', 'Chasis', "2012-09-02");
Query OK, 1 row affected (0.011 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0002', 'mouse', "2013-07-29");
Query OK, 1 row affected (0.002 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0003', 'teclado', "2012-06-04");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0004', 'ram', "2012-03-27");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0005', 'Memoria usb', "2012-12-06");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0006', 'ups', "2012-03-25");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0007', 'regulador voltaje', "2012-05-08");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0008', 'cableado', "2012-04-24");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0009', 'Tablet', "2012-08-10");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0010', 'Escanner', "2012-03-21");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0011', 'lapiz optico', "2012-02-12");
Query OK, 1 row affected (0.004 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0012', 'Procedador pentium', "2012-06-19");
Query OK, 1 row affected (0.004 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0013', 'Procesador SN', "2012-04-14");
Query OK, 1 row affected (0.004 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0014', 'Unidad CD', "2012-09-17");
Query OK, 1 row affected (0.002 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0015', 'hub', "2012-01-16");
Query OK, 1 row affected (0.002 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0016', 'Multifuncional', "2013-04-15");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0017', 'Camara', "2013-03-18");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0018', 'Board', "2013-01-13");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0019', 'impresora laser', "2013-10-20");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0020', 'Fuente', "2013-07-11");
Query OK, 1 row affected (0.003 sec)

MariaDB [fechas]> insert into pagos(identi, descripcion, fechaadquisicion) values('0021', 'disco duro', "2013-11-22");
Query OK, 1 row affected (0.006 sec)

MariaDB [fechas]> select * from pagos;
+--------+--------------------+------------------+
| identi | descripcion        | fechaadquisicion |
+--------+--------------------+------------------+
| 0001   | Chasis             | 2012-09-02       |
| 0002   | mouse              | 2013-07-29       |
| 0003   | teclado            | 2012-06-04       |
| 0004   | ram                | 2012-03-27       |
| 0005   | Memoria usb        | 2012-12-06       |
| 0006   | ups                | 2012-03-25       |
| 0007   | regulador voltaje  | 2012-05-08       |
| 0008   | cableado           | 2012-04-24       |
| 0009   | Tablet             | 2012-08-10       |
| 0010   | Escanner           | 2012-03-21       |
| 0011   | lapiz optico       | 2012-02-12       |
| 0012   | Procedador pentium | 2012-06-19       |
| 0013   | Procesador SN      | 2012-04-14       |
| 0014   | Unidad CD          | 2012-09-17       |
| 0015   | hub                | 2012-01-16       |
| 0016   | Multifuncional     | 2013-04-15       |
| 0017   | Camara             | 2013-03-18       |
| 0018   | Board              | 2013-01-13       |
| 0019   | impresora laser    | 2013-10-20       |
| 0020   | Fuente             | 2013-07-11       |
| 0021   | disco duro         | 2013-11-22       |
+--------+--------------------+------------------+
21 rows in set (0.003 sec)

MariaDB [fechas]> select * from pagos where substr(fechaadquisicion,1,7) < ('2012-06') ;
+--------+-------------------+------------------+
| identi | descripcion       | fechaadquisicion |
+--------+-------------------+------------------+
| 0004   | ram               | 2012-03-27       |
| 0006   | ups               | 2012-03-25       |
| 0007   | regulador voltaje | 2012-05-08       |
| 0008   | cableado          | 2012-04-24       |
| 0010   | Escanner          | 2012-03-21       |
| 0011   | lapiz optico      | 2012-02-12       |
| 0013   | Procesador SN     | 2012-04-14       |
| 0015   | hub               | 2012-01-16       |
+--------+-------------------+------------------+
8 rows in set (0.002 sec)

MariaDB [fechas]> select * from pagos where fechaadquisicion = (select max(fechaadquisicion) from pagos);
+--------+-------------+------------------+
| identi | descripcion | fechaadquisicion |
+--------+-------------+------------------+
| 0021   | disco duro  | 2013-11-22       |
+--------+-------------+------------------+
1 row in set (0.007 sec)

MariaDB [fechas]> select * from pagos where descripcion like '%o' or descripcion like '%m';
+--------+--------------------+------------------+
| identi | descripcion        | fechaadquisicion |
+--------+--------------------+------------------+
| 0003   | teclado            | 2012-06-04       |
| 0004   | ram                | 2012-03-27       |
| 0008   | cableado           | 2012-04-24       |
| 0011   | lapiz optico       | 2012-02-12       |
| 0012   | Procedador pentium | 2012-06-19       |
| 0021   | disco duro         | 2013-11-22       |
+--------+--------------------+------------------+
6 rows in set (0.005 sec)

MariaDB [fechas]> select * from pagos where descripcion not rlike '[aeiou];
    '> '
    -> ;
+--------+--------------------+------------------+
| identi | descripcion        | fechaadquisicion |
+--------+--------------------+------------------+
| 0001   | Chasis             | 2012-09-02       |
| 0002   | mouse              | 2013-07-29       |
| 0003   | teclado            | 2012-06-04       |
| 0004   | ram                | 2012-03-27       |
| 0005   | Memoria usb        | 2012-12-06       |
| 0006   | ups                | 2012-03-25       |
| 0007   | regulador voltaje  | 2012-05-08       |
| 0008   | cableado           | 2012-04-24       |
| 0009   | Tablet             | 2012-08-10       |
| 0010   | Escanner           | 2012-03-21       |
| 0011   | lapiz optico       | 2012-02-12       |
| 0012   | Procedador pentium | 2012-06-19       |
| 0013   | Procesador SN      | 2012-04-14       |
| 0014   | Unidad CD          | 2012-09-17       |
| 0015   | hub                | 2012-01-16       |
| 0016   | Multifuncional     | 2013-04-15       |
| 0017   | Camara             | 2013-03-18       |
| 0018   | Board              | 2013-01-13       |
| 0019   | impresora laser    | 2013-10-20       |
| 0020   | Fuente             | 2013-07-11       |
| 0021   | disco duro         | 2013-11-22       |
+--------+--------------------+------------------+
21 rows in set (0.005 sec)

MariaDB [fechas]> select descripcion,fechaadquisicion, if(month(fechaadquisicion) <= 6, 'Plazo 5 Meses' from pagos;
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 'from pagos' at line 1
MariaDB [fechas]> select descripcion,fechaadquisicion, if(month(fechaadquisicion) <= 6, 'Plazo 5 Meses', 'Plazo 8 meses')'Plazo Pago' from pagos;
+--------------------+------------------+---------------+
| descripcion        | fechaadquisicion | Plazo Pago    |
+--------------------+------------------+---------------+
| Chasis             | 2012-09-02       | Plazo 8 meses |
| mouse              | 2013-07-29       | Plazo 8 meses |
| teclado            | 2012-06-04       | Plazo 5 Meses |
| ram                | 2012-03-27       | Plazo 5 Meses |
| Memoria usb        | 2012-12-06       | Plazo 8 meses |
| ups                | 2012-03-25       | Plazo 5 Meses |
| regulador voltaje  | 2012-05-08       | Plazo 5 Meses |
| cableado           | 2012-04-24       | Plazo 5 Meses |
| Tablet             | 2012-08-10       | Plazo 8 meses |
| Escanner           | 2012-03-21       | Plazo 5 Meses |
| lapiz optico       | 2012-02-12       | Plazo 5 Meses |
| Procedador pentium | 2012-06-19       | Plazo 5 Meses |
| Procesador SN      | 2012-04-14       | Plazo 5 Meses |
| Unidad CD          | 2012-09-17       | Plazo 8 meses |
| hub                | 2012-01-16       | Plazo 5 Meses |
| Multifuncional     | 2013-04-15       | Plazo 5 Meses |
| Camara             | 2013-03-18       | Plazo 5 Meses |
| Board              | 2013-01-13       | Plazo 5 Meses |
| impresora laser    | 2013-10-20       | Plazo 8 meses |
| Fuente             | 2013-07-11       | Plazo 8 meses |
| disco duro         | 2013-11-22       | Plazo 8 meses |
+--------------------+------------------+---------------+
21 rows in set (0.007 sec)

MariaDB [fechas]> exit