MariaDB [(none)]> create database Aplicacion_cadena; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> show database; 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 'database' at line 1 MariaDB [(none)]> show databases; +--------------------------------+ | Database | +--------------------------------+ | aplicacion_cadena | | cadena | | club_deportivo_corporacion_aws | | empresabuses | | fechas | | fechas1 | | information_schema | | mysql | | parcial1 | | performance_schema | | phpmyadmin | | pruebadetrigger | | simulacro | | subconsultas | | test | | veterinaria | +--------------------------------+ 16 rows in set (0.020 sec) MariaDB [(none)]> use Aplicacion_cadena; Database changed MariaDB [Aplicacion_cadena]> create table discente ( -> carnet varchar(12) primary key, -> nombre varchar(100) -> ); Query OK, 0 rows affected (0.020 sec) MariaDB [Aplicacion_cadena]> insert into discente (carnet, nombre) values -> -> 201126012075ALVARADO RESTREPO ESTEBAN -> 201110011075ARENAS TAMAYO JOAN SEBASTIAN -> 200910005075BEDOYA BEDOYA DIEGO ALEXANDER -> 201020006088CARDONA CHICA DIEGO FERNANDO -> 201116027075CARMONA TABORDA JOHN ALEXANDER -> 201320010075CORREA CORREA ANGELICA MARIA -> 201110016075GOMEZ GOMEZ JULIO CESAR -> 201110022075HURTADO TAMAYO CARLOS ESTIBEN -> 201220002075LONDO･O FONNEGRA JHONNY ALEXANDER -> 201116037075MANYOMA GARCIA HENSLLY -> 201110020075MARTINEZ VALENCIA JHON DENNIS -> 201320021075PEREZ YEISON FABIAN -> 201220004088SALAZAR BUSTAMANTE MERY JOHANNA -> 201212005075TORRES TONOCOLIA JENNIFER JULIETH -> 201213002088ZULUAGA LONDO･O ANGELA CRISTINA -> 201120011088ASPRILLA LEUDO YILMAR -> 201324002075ASPRILLA MENA WALNHER YHAMYD -> 201223000088CALLE PUERTA LILIANA MARIA -> 201210009088COLLAZO PATI･O ALEX FERNEY -> 201224000088GRANADA MESA VICTOR ALONSO -> 201210005088HERRERA CARDONA JUAN DANIEL -> 201220016088JARAMILLO CARDONA MARLON ALEXANDER -> 201210043088MARTINEZ VALENCIA JHONATAN ARLEY -> 201210009075MOSQUERA PALACIOS NELSON JHAIR -> 201210007075OCAMPO NARANJO LUIS FELIPE -> 201210022088OROZCO CARMONA DIDIER -> 201222000075RAMIREZ MONTOYA ANDRES -> 201210012088SALDARRIAGA ARAQUE ANDRES FELIPE -> 201010002075VANEGAS AGUDELO ETHAN ARLEY -> 200910012075ALZATE CARVAJAL RAFAEL ALEXANDER -> 200910005075BEDOYA BEDOYA DIEGO ALEXANDER -> 201210030075CAICEDO CABEZAS JOHE ALDREITH -> 201126016075MESA ROLDAN JAVIER ALBERTO -> 201213000088MONTOYA HENAO MARCELA -> 201312004075MUNERA CARDENAS JOHN JAIRO -> 201320021075PEREZ YEISON FABIAN -> 201220022088RAMIREZ MESA JULIAN ALBERTO -> 201313006075TEJADA CASTRO ANDR心 FELIPE -> 201212005075TORRES TONOCOLIA JENNIFER JULIETH -> 201220004075VALLEJO MAZO PAOLA ANDREA -> 200920001075VARGAS ARTEAGA ALEXIS ALBERTO -> 201212003075ZAPATA ZU･IGA ADRIANA PATRICIA -> 201222005075ANDRADE RIVERA JOHAN ALEXIS -> 201310026075ANGARITA TORRES IRAMA -> 201312007075CARO BEDOYA WALTER DAVIDSON -> 201313001075CUESTA CUERVO YURY LORENA -> 201220006075ECHAVARRIA RODRIGUEZ SANDRA MARIA -> 201310008075GIRALDO VERGARA YOLANDA MILENA -> 201110017088GRAJALES MU･OZ VICTOR CAMILO -> 201110005088NARANJO DE LOS RIOS MONICA MARIA -> 201214004075RADA RODRIGUEZ SILVIO SEGUNDO -> 201223003075SERNA ESCOBAR JUAN CARLOS -> 201222004075VEGA MAZO OMAIRA MARIA -> 200820040075WALTON MAYA NATALIA MARIA -> 200920009075ATEHORTUA LONDO･O JUAN CAMILO -> 201220003075BLANDON LONDO･O CRISTIAN MAURICIO -> 201020006088CARDONA CHICA DIEGO FERNANDO -> 201010005075CASTRO HERNANDEZ MARIA CRISTINA -> 201110019088CASTRO NAVIA KARINA -> 201020003088CEBALLOS BETANCUR DANIEL STEVEN -> 201110017088GRAJALES MU･OZ VICTOR CAMILO -> 201222003075RESTREPO GOMEZ RUBEN FERNANDO -> 201110034075RODRIGUEZ CARDONA YENY ANDREA -> 201310016075VALDERRAMA MAHECHA DIEGO ALEJANDRO -> 201222007073AREIZA VERA JOHN FREDY -> 201110058073BURGOS ECHEVERRY LISBETH -> 201222008073DOMINGUEZ GOMEZ LIBIA ESTELA -> 201314005073DURANGO RODRIGUEZ JESUS HUMBEIRO -> 200910069073FUENTES FLOREZ JESSICA VIVIANA -> 201312008075JARAMILLO LUIS FERNANDO -> 201120004073LOPERA GUTIERREZ ALBA MIREYLLE -> 201120036073MENA ARTEAGA JUAN NORBERTO -> 201120028073OSPINA DAVID DORA ALBA -> 201214004075RADA RODRIGUEZ SILVIO SEGUNDO -> 200820036073RIOS QUINCHIA TATIANA -> 200920013073SILVA ARIAS NANCY CRISTINA -> 201312001088VARELA BEDOYA DAISSY ANDREA -> 201120030073VELASQUEZ ACEVEDO BIVIANA ELIZABETH -> 201324013073VELEZ DIANA MARCELA -> 200910007073ZAPATA VALENCIA OLGA LUCIA -> 201320024070BOLA･O MADERA MAIRA MIRITH -> 201320016070GRISALES ISAZA PAOLA ANDREA -> 201320005086GUTﾖERREZ SEGURO BEATRIZ -> 201320005073HOYOS HENAO JORGE NILTON -> 201320002073LEON ESTEVEZ DEISY YOLIMA -> 201320008060LONDO･O MU･OZ MARISOL -> 201320003072LOPEZ BLANDON LUISA FERNANDA -> 201320011073LOPEZ JIMENEZ LILLYAM DE JESUS -> 201320009070MAZO MARIN ANA MARIA -> 201320011059MU･OZ LOPEZ JONATHATAN FELIPE -> 201320013074MURILLO MURILLO VIDAL CAMILO -> 201320004072PATI･O FLOREZ MARIA ANDREA -> 201320008059RODRIGUEZ VILLA YOHAN SEBASTIAN -> 201320006073RUIZ RIVERA ISABEL -> 201320003070TEJADA AGUIRRE ZAIRA CRISTINA -> 201320013070TIECK MACIAS NICOLAS -> 201320006074YEPES HENAO MONICA ; 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 '201126012075ALVARADO RESTREPO ESTEBAN 201110011075ARENAS TAMAYO JOAN SEBASTIA...' at line 3 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心 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'), -> ('201214004075', 'RADA RODRIGUEZ SILVIO SEGUNDO'), -> ('201223003075', 'SERNA ESCOBAR JUAN CARLOS'), -> ('201222004075', 'VEGA MAZO OMAIRA MARIA'); Query OK, 50 rows affected (0.031 sec) Records: 50 Duplicates: 0 Warnings: 0 MariaDB [Aplicacion_cadena]> select * from discente where substr(carnet, 10, 3) in ('075' '088'); Empty set (0.001 sec) MariaDB [Aplicacion_cadena]> select count(*) as total_ingenieria from discente where substr(carnet, 10, 3) = '075'; +------------------+ | total_ingenieria | +------------------+ | 34 | +------------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> select nombre from discente where length(nombre) <=25; +---------------------------+ | nombre | +---------------------------+ | GOMEZ GOMEZ JULIO CESAR | | MANYOMA GARCIA HENSLLY | | ASPRILLA LEUDO YILMAR | | ALVARADO RESTREPO ESTEBAN | | OROZCO CARMONA DIDIER | | MONTOYA HENAO MARCELA | | VALLEJO MAZO PAOLA ANDREA | | RAMIREZ MONTOYA ANDRES | | VEGA MAZO OMAIRA MARIA | | SERNA ESCOBAR JUAN CARLOS | | ANGARITA TORRES IRAMA | | PEREZ YEISON FABIAN | +---------------------------+ 12 rows in set (0.001 sec) MariaDB [Aplicacion_cadena]> select count(*) as total_2012 from discente where substr(carnet, 1, 4) = '2012'; +------------+ | total_2012 | +------------+ | 25 | +------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> select count(*) as primer_semestre from discente where substr(carnet, 5, 1) = '1'; +-----------------+ | primer_semestre | +-----------------+ | 30 | +-----------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> select count(*) as antes_2013 from discente where substr(carnet, 1, 4) < '2013'; +------------+ | antes_2013 | +------------+ | 41 | +------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> select * from discente order by substr(carnet, 1, 4); +--------------+------------------------------------+ | carnet | nombre | +--------------+------------------------------------+ | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | | 201116037075 | MANYOMA GARCIA HENSLLY | | 201120011088 | ASPRILLA LEUDO YILMAR | | 201126012075 | ALVARADO RESTREPO ESTEBAN | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | | 201110017088 | GRAJALES MU･OZ VICTOR CAMILO | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | | 201222000075 | RAMIREZ MONTOYA ANDRES | | 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 | | 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | | 201213002088 | ZULUAGA LONDO･O ANGELA CRISTINA | | 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 | | 201320021075 | PEREZ YEISON FABIAN | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201313006075 | TEJADA CASTRO ANDR心 FELIPE | | 201313001075 | CUESTA CUERVO YURY LORENA | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | | 201310026075 | ANGARITA TORRES IRAMA | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | +--------------+------------------------------------+ 50 rows in set (0.002 sec) MariaDB [Aplicacion_cadena]> select * from discente where substr(carnet, 1, 4) < '2012' and substr(carnet, 5, 1) = '2' and substr(carnet, 10, 3) = '075'; +--------------+-------------------------------+ | carnet | nombre | +--------------+-------------------------------+ | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 201126012075 | ALVARADO RESTREPO ESTEBAN | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | +--------------+-------------------------------+ 3 rows in set (0.011 sec) MariaDB [Aplicacion_cadena]> select min(carnet) as menor_carnet from discente where substr(carnet, 10, 3) not in ('075', '088'); +--------------+ | menor_carnet | +--------------+ | NULL | +--------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> select carnet, nombre, -> case when substr(carnet, 10, 3) = '088' then 'descuento 5%' -> else 'pago completo' end as estado_pago -> from discente; +--------------+------------------------------------+---------------+ | carnet | nombre | estado_pago | +--------------+------------------------------------+---------------+ | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | pago completo | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | pago completo | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | pago completo | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | pago completo | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | descuento 5% | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | descuento 5% | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | pago completo | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | pago completo | | 201110017088 | GRAJALES MU･OZ VICTOR CAMILO | descuento 5% | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | pago completo | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | pago completo | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | pago completo | | 201116037075 | MANYOMA GARCIA HENSLLY | pago completo | | 201120011088 | ASPRILLA LEUDO YILMAR | descuento 5% | | 201126012075 | ALVARADO RESTREPO ESTEBAN | pago completo | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | pago completo | | 201210005088 | HERRERA CARDONA JUAN DANIEL | descuento 5% | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | pago completo | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | pago completo | | 201210009088 | COLLAZO PATI･O ALEX FERNEY | descuento 5% | | 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE | descuento 5% | | 201210022088 | OROZCO CARMONA DIDIER | descuento 5% | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | pago completo | | 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY | descuento 5% | | 201212003075 | ZAPATA ZU･IGA ADRIANA PATRICIA | pago completo | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | pago completo | | 201213000088 | MONTOYA HENAO MARCELA | descuento 5% | | 201213002088 | ZULUAGA LONDO･O ANGELA CRISTINA | descuento 5% | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | pago completo | | 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER | pago completo | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | pago completo | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | descuento 5% | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | pago completo | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | descuento 5% | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | descuento 5% | | 201222000075 | RAMIREZ MONTOYA ANDRES | pago completo | | 201222004075 | VEGA MAZO OMAIRA MARIA | pago completo | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | pago completo | | 201223000088 | CALLE PUERTA LILIANA MARIA | descuento 5% | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | pago completo | | 201224000088 | GRANADA MESA VICTOR ALONSO | descuento 5% | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | pago completo | | 201310026075 | ANGARITA TORRES IRAMA | pago completo | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | pago completo | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | pago completo | | 201313001075 | CUESTA CUERVO YURY LORENA | pago completo | | 201313006075 | TEJADA CASTRO ANDR心 FELIPE | pago completo | | 201320010075 | CORREA CORREA ANGELICA MARIA | pago completo | | 201320021075 | PEREZ YEISON FABIAN | pago completo | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | pago completo | +--------------+------------------------------------+---------------+ 50 rows in set (0.001 sec) MariaDB [Aplicacion_cadena]> select carnet, nombre, -> case when substr(carnet, 10, 3) = '073' then 'contaduria' -> else 'otra carrera af｡n' end as carrera -> from discente; +--------------+------------------------------------+-------------------+ | carnet | nombre | carrera | +--------------+------------------------------------+-------------------+ | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | otra carrera af｡n | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | otra carrera af｡n | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | otra carrera af｡n | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | 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 | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | otra carrera af｡n | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | otra carrera af｡n | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | otra carrera af｡n | | 201116037075 | MANYOMA GARCIA HENSLLY | otra carrera af｡n | | 201120011088 | ASPRILLA LEUDO YILMAR | otra carrera af｡n | | 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 | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | otra carrera af｡n | | 201220002075 | LONDO･O FONNEGRA JHONNY ALEXANDER | 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 | | 201222004075 | VEGA MAZO OMAIRA MARIA | otra carrera af｡n | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | otra carrera af｡n | | 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 | | 201310026075 | ANGARITA TORRES IRAMA | otra carrera af｡n | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | otra carrera af｡n | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | otra carrera af｡n | | 201313001075 | CUESTA CUERVO YURY LORENA | otra carrera af｡n | | 201313006075 | TEJADA CASTRO ANDR心 FELIPE | otra carrera af｡n | | 201320010075 | CORREA CORREA ANGELICA MARIA | otra carrera af｡n | | 201320021075 | PEREZ YEISON FABIAN | otra carrera af｡n | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | otra carrera af｡n | +--------------+------------------------------------+-------------------+ 50 rows in set (0.003 sec) MariaDB [Aplicacion_cadena]> select * from discente where substr(carnet, 10, 3) = '075' and nombre like '%i%'; +--------------+-----------------------------------+ | carnet | nombre | +--------------+-----------------------------------+ | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | | 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 | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | | 201222000075 | RAMIREZ MONTOYA ANDRES | | 201222004075 | VEGA MAZO OMAIRA MARIA | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | | 201310026075 | ANGARITA TORRES IRAMA | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | | 201313006075 | TEJADA CASTRO ANDR心 FELIPE | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201320021075 | PEREZ YEISON FABIAN | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | +--------------+-----------------------------------+ 26 rows in set (0.001 sec) MariaDB [Aplicacion_cadena]> exit