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