MariaDB [cadena]> show tables; +------------------+ | Tables_in_cadena | +------------------+ | alumno | +------------------+ 1 row in set (0.000 sec) MariaDB [cadena]> select * from alumno; +------------+------------------------------------+ | carnet | nombre | +------------+------------------------------------+ | 0601110015 | CUADROS BALDRICH MARIA ALEJANDRA | | 0601110034 | HOLGUIN MUNOZ HERVIN HAROLD | | 0700310071 | ORREGO LOZANO JUAN JOSE | | 0701110007 | ANGEL ACEVEDO LEIDY TATIANA | | 0701110013 | JARAMILLO MONTOYA JUAN PABLO | | 0701110016 | CHICA JANNA JUAN DAVID | | 0701110031 | MARTINEZ PATINO YULIETH PAOLA | | 0701110036 | MALLAMA GIRALDO ANGIE CAROLINA | | 0701110037 | FLOREZ SALDARRIAGA MIGUEL ANGEL | | 0701110051 | FAJARDO QUINTERO JOHANA CATALINA | | 0701110055 | GALLEGO ZAPATA SINDY CATHERINNE | | 0701110063 | ARIAS JIMENEZ JOHAN | | 0710620022 | YEPES GRISALES NATHALIA | | 0710720005 | QUINTERO JOSE MIGUEL | | 0710720010 | BOLIVAR CARTAGENA GUILLERMO ALEXIS | | 0710820004 | ZULUAGA DIAZ HECTOR EDUARDO | | 0710820025 | ZAPATA BEDOYA VICTOR FABIAN | | 0710820026 | CONDE ALVAREZ YESICA YESSENIA | | 0710820034 | ADARMES MURCIA JESSICA BRIGHIT | | 0710910007 | QUINCHIA CHAVERRA EDWIN ALEXANDER | | 0710910018 | ALZATE ARROYAVE MAURICIO | | 0711020003 | AGUILAR LARGO JESUS AUGUSTO | | 0721110006 | CASTRO SUAREZ RUTH ANGELICA | | 0721110008 | HIDALGO CADAVID CAROLINA | | 0721110012 | GARCIA MORALES LUISA FERNANDA | | 0721110017 | GALVIS CUESTA KELLY JOHANA | | 0721110022 | CORREA GONZALEZ GABRIEL JOSE | | 0721110023 | SAENZ DANIELA FERNANDA | | 0721110025 | CASTRILLON SALAZAR ISABEL CRISTINA | | 0721110028 | MANCILLA MONTERO MARLYS MACIEL | | 0721110033 | BEDOYA ACEVEDO LILIANA | | 0721110034 | GARCIA MENDEZ SARA DANIELA | | 0721110036 | GOMEZ BELTRAN KATHERINE JOHANA | | 0731110017 | MADRID MURILLO ARLENYS | | 0731110020 | MACIAS HERNANDEZ YURI ALEIDA | | 0741110010 | PALACIOS QUINTO SNDY | | 0741110016 | GRANADOS MARIN DAVID FELIPE | | 0750210001 | HENAO BRAN DIXON RODRIGO | | 0750310024 | PALACIOS ALUMA MARBIN | | 0750410035 | LONDONO HERRERA DORIAN ALEXANDER | | 0750616022 | ESTRADA MARTINEZ ANET ELLACY | | 0750710001 | OROZCO MONTOYA MARLON FELIPE | | 0750710003 | BLANDON NARANJO ADRIANA MARIA | | 0750710014 | MONTOYA LONDONO SERGIO ANDRES | | 0750816010 | ECHAVARRIA RIOS JENIFER ANDREA | | 0750826036 | SEPULVEDA GARCIA ADRIANA ROCIO | | 0750920012 | BENJUMEA HERRERA CAMILO ANDRES | | 0751010013 | DUQUE LOPEZ YESID ANDRES | | 0751010015 | LOPERA BUILES VICTOR ARLEY | | 0751010021 | SALAZAR ALZATE LEON RODRIGO | | 0751016012 | PALACIOS PALACIOS JESSIE JACKSON | | 0751016023 | LOPERA AGUDELO MARIA MAGDALENA | | 0751020017 | GOMEZ JIMENEZ DEICY JULIANA | | 0751020018 | CALIXTO BETANCOURT JENNY MARCELA | | 0751020021 | LONDONO OCAMPO WALTER FABER | | 0751026030 | RAMOS ASPRILLA YUBER JOSE | | 0751110010 | FUENTES VARGAS EDUWIN DANIEL | | 0751110014 | ROJAS VALENCIA OSCAR FERNANDO | | 0751110017 | RAMIREZ HERMES | | 0751110018 | VERGARA DIAZ YURANIS MARLEY | | 0751110034 | RODRIGUEZ CARDONA YENY ANDREA | | 0751110036 | MUNOZ CADAVID ANA MARINA | | 0751110046 | ISAZA MORALES NELSON JOVANNY | | 0751110047 | VEGA BONILLA LIZET VANESSA | | 0751116028 | VERGARA RUA NANCY JULIETH | | 0751116031 | QUINTERO MONTES AICARDO | | 0751116033 | RENTERIA SANABRIA LUIS ANTONIO | | 0880920004 | CORDOBA GARCIA JESBER | | 0880920022 | ARBOLEDA PALACIOS YUSLY YULIPSA | | 0880920023 | DIAZ RAMIREZ OSCAR GERMAN | | 0880920025 | OSPINA MORENO MARGARITA MARIA | | 0881010011 | RESTREPO GOMEZ RUBEN FERNANDO | | 0881010015 | PEREZ CARDENAS STEFANIA | | 0881020007 | VANEGAS HENAO ELMER ANDRES | | 0881020031 | MUNOZ MONSALVE CIPRIANO ANTONIO | | 0881110004 | BLANDON TORRES OVIDIO ALBERTO | | 0881110009 | GOMEZ BRAVO LUIS GABRIEL | | 0881110013 | AGUDLO SIERRA JOHAN SEBASTIAN | | 0881110017 | GRAJALES MUNOZ VICTOR CAMILO | | 0881110026 | GARCIA LOPEZ GAYO | | 0881110029 | RODRIGUEZ HERNANDEZ PAOLA TATIANA | | 0881110030 | GONZALEZ SIERRA JONATAN ANDRES | +------------+------------------------------------+ 82 rows in set (0.002 sec) MariaDB [cadena]> describe -> ; 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 '' at line 1 MariaDB [cadena]> describe alumno; +--------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+----------+------+-----+---------+-------+ | carnet | char(10) | NO | PRI | NULL | | | nombre | char(50) | NO | | NULL | | +--------+----------+------+-----+---------+-------+ 2 rows in set (0.175 sec) MariaDB [cadena]> select carnet,nombre from alumno where substr(carnet, 1,3) not in ('070','072','060'); +------------+------------------------------------+ | carnet | nombre | +------------+------------------------------------+ | 0710620022 | YEPES GRISALES NATHALIA | | 0710720005 | QUINTERO JOSE MIGUEL | | 0710720010 | BOLIVAR CARTAGENA GUILLERMO ALEXIS | | 0710820004 | ZULUAGA DIAZ HECTOR EDUARDO | | 0710820025 | ZAPATA BEDOYA VICTOR FABIAN | | 0710820026 | CONDE ALVAREZ YESICA YESSENIA | | 0710820034 | ADARMES MURCIA JESSICA BRIGHIT | | 0710910007 | QUINCHIA CHAVERRA EDWIN ALEXANDER | | 0710910018 | ALZATE ARROYAVE MAURICIO | | 0711020003 | AGUILAR LARGO JESUS AUGUSTO | | 0731110017 | MADRID MURILLO ARLENYS | | 0731110020 | MACIAS HERNANDEZ YURI ALEIDA | | 0741110010 | PALACIOS QUINTO SNDY | | 0741110016 | GRANADOS MARIN DAVID FELIPE | | 0750210001 | HENAO BRAN DIXON RODRIGO | | 0750310024 | PALACIOS ALUMA MARBIN | | 0750410035 | LONDONO HERRERA DORIAN ALEXANDER | | 0750616022 | ESTRADA MARTINEZ ANET ELLACY | | 0750710001 | OROZCO MONTOYA MARLON FELIPE | | 0750710003 | BLANDON NARANJO ADRIANA MARIA | | 0750710014 | MONTOYA LONDONO SERGIO ANDRES | | 0750816010 | ECHAVARRIA RIOS JENIFER ANDREA | | 0750826036 | SEPULVEDA GARCIA ADRIANA ROCIO | | 0750920012 | BENJUMEA HERRERA CAMILO ANDRES | | 0751010013 | DUQUE LOPEZ YESID ANDRES | | 0751010015 | LOPERA BUILES VICTOR ARLEY | | 0751010021 | SALAZAR ALZATE LEON RODRIGO | | 0751016012 | PALACIOS PALACIOS JESSIE JACKSON | | 0751016023 | LOPERA AGUDELO MARIA MAGDALENA | | 0751020017 | GOMEZ JIMENEZ DEICY JULIANA | | 0751020018 | CALIXTO BETANCOURT JENNY MARCELA | | 0751020021 | LONDONO OCAMPO WALTER FABER | | 0751026030 | RAMOS ASPRILLA YUBER JOSE | | 0751110010 | FUENTES VARGAS EDUWIN DANIEL | | 0751110014 | ROJAS VALENCIA OSCAR FERNANDO | | 0751110017 | RAMIREZ HERMES | | 0751110018 | VERGARA DIAZ YURANIS MARLEY | | 0751110034 | RODRIGUEZ CARDONA YENY ANDREA | | 0751110036 | MUNOZ CADAVID ANA MARINA | | 0751110046 | ISAZA MORALES NELSON JOVANNY | | 0751110047 | VEGA BONILLA LIZET VANESSA | | 0751116028 | VERGARA RUA NANCY JULIETH | | 0751116031 | QUINTERO MONTES AICARDO | | 0751116033 | RENTERIA SANABRIA LUIS ANTONIO | | 0880920004 | CORDOBA GARCIA JESBER | | 0880920022 | ARBOLEDA PALACIOS YUSLY YULIPSA | | 0880920023 | DIAZ RAMIREZ OSCAR GERMAN | | 0880920025 | OSPINA MORENO MARGARITA MARIA | | 0881010011 | RESTREPO GOMEZ RUBEN FERNANDO | | 0881010015 | PEREZ CARDENAS STEFANIA | | 0881020007 | VANEGAS HENAO ELMER ANDRES | | 0881020031 | MUNOZ MONSALVE CIPRIANO ANTONIO | | 0881110004 | BLANDON TORRES OVIDIO ALBERTO | | 0881110009 | GOMEZ BRAVO LUIS GABRIEL | | 0881110013 | AGUDLO SIERRA JOHAN SEBASTIAN | | 0881110017 | GRAJALES MUNOZ VICTOR CAMILO | | 0881110026 | GARCIA LOPEZ GAYO | | 0881110029 | RODRIGUEZ HERNANDEZ PAOLA TATIANA | | 0881110030 | GONZALEZ SIERRA JONATAN ANDRES | +------------+------------------------------------+ 59 rows in set (0.001 sec) MariaDB [cadena]> select count(*) from alumno where substr(carnet,1,3) in ('072'); +----------+ | count(*) | +----------+ | 11 | +----------+ 1 row in set (0.001 sec) MariaDB [cadena]> select count(nombre) from alumno where substr(carnet,6,1) in ('1'); +---------------+ | count(nombre) | +---------------+ | 62 | +---------------+ 1 row in set (0.000 sec) MariaDB [cadena]> select * from alumno where substr(carnet,6,1) in ('2'); +------------+------------------------------------+ | carnet | nombre | +------------+------------------------------------+ | 0710620022 | YEPES GRISALES NATHALIA | | 0710720005 | QUINTERO JOSE MIGUEL | | 0710720010 | BOLIVAR CARTAGENA GUILLERMO ALEXIS | | 0710820004 | ZULUAGA DIAZ HECTOR EDUARDO | | 0710820025 | ZAPATA BEDOYA VICTOR FABIAN | | 0710820026 | CONDE ALVAREZ YESICA YESSENIA | | 0710820034 | ADARMES MURCIA JESSICA BRIGHIT | | 0711020003 | AGUILAR LARGO JESUS AUGUSTO | | 0750826036 | SEPULVEDA GARCIA ADRIANA ROCIO | | 0750920012 | BENJUMEA HERRERA CAMILO ANDRES | | 0751020017 | GOMEZ JIMENEZ DEICY JULIANA | | 0751020018 | CALIXTO BETANCOURT JENNY MARCELA | | 0751020021 | LONDONO OCAMPO WALTER FABER | | 0751026030 | RAMOS ASPRILLA YUBER JOSE | | 0880920004 | CORDOBA GARCIA JESBER | | 0880920022 | ARBOLEDA PALACIOS YUSLY YULIPSA | | 0880920023 | DIAZ RAMIREZ OSCAR GERMAN | | 0880920025 | OSPINA MORENO MARGARITA MARIA | | 0881020007 | VANEGAS HENAO ELMER ANDRES | | 0881020031 | MUNOZ MONSALVE CIPRIANO ANTONIO | +------------+------------------------------------+ 20 rows in set (0.000 sec) MariaDB [cadena]> select * from alumno where substr(carnet,1,3) in ('072'); +------------+------------------------------------+ | carnet | nombre | +------------+------------------------------------+ | 0721110006 | CASTRO SUAREZ RUTH ANGELICA | | 0721110008 | HIDALGO CADAVID CAROLINA | | 0721110012 | GARCIA MORALES LUISA FERNANDA | | 0721110017 | GALVIS CUESTA KELLY JOHANA | | 0721110022 | CORREA GONZALEZ GABRIEL JOSE | | 0721110023 | SAENZ DANIELA FERNANDA | | 0721110025 | CASTRILLON SALAZAR ISABEL CRISTINA | | 0721110028 | MANCILLA MONTERO MARLYS MACIEL | | 0721110033 | BEDOYA ACEVEDO LILIANA | | 0721110034 | GARCIA MENDEZ SARA DANIELA | | 0721110036 | GOMEZ BELTRAN KATHERINE JOHANA | +------------+------------------------------------+ 11 rows in set (0.000 sec) MariaDB [cadena]> select count(nombre) from alumno where substr(carnet,6,1) in ('1'); +---------------+ | count(nombre) | +---------------+ | 62 | +---------------+ 1 row in set (0.001 sec) MariaDB [cadena]> select count(nombre) from alumno where substr(carnet,6,1) in ('2'); +---------------+ | count(nombre) | +---------------+ | 20 | +---------------+ 1 row in set (0.001 sec) MariaDB [cadena]> select count(carnet) from alumno where substr(carnet,4,2) < ('10'); +---------------+ | count(carnet) | +---------------+ | 24 | +---------------+ 1 row in set (0.001 sec) MariaDB [cadena]> select count(*) from alumno where substr(carnet,1,2) not in ('07'); +----------+ | count(*) | +----------+ | 17 | +----------+ 1 row in set (0.001 sec) MariaDB [cadena]> select * from alumno order by substr(carnet,4,2); +------------+------------------------------------+ | carnet | nombre | +------------+------------------------------------+ | 0750210001 | HENAO BRAN DIXON RODRIGO | | 0700310071 | ORREGO LOZANO JUAN JOSE | | 0750310024 | PALACIOS ALUMA MARBIN | | 0750410035 | LONDONO HERRERA DORIAN ALEXANDER | | 0710620022 | YEPES GRISALES NATHALIA | | 0750616022 | ESTRADA MARTINEZ ANET ELLACY | | 0750710003 | BLANDON NARANJO ADRIANA MARIA | | 0750710001 | OROZCO MONTOYA MARLON FELIPE | | 0750710014 | MONTOYA LONDONO SERGIO ANDRES | | 0710720005 | QUINTERO JOSE MIGUEL | | 0710720010 | BOLIVAR CARTAGENA GUILLERMO ALEXIS | | 0750816010 | ECHAVARRIA RIOS JENIFER ANDREA | | 0710820025 | ZAPATA BEDOYA VICTOR FABIAN | | 0710820034 | ADARMES MURCIA JESSICA BRIGHIT | | 0710820026 | CONDE ALVAREZ YESICA YESSENIA | | 0710820004 | ZULUAGA DIAZ HECTOR EDUARDO | | 0750826036 | SEPULVEDA GARCIA ADRIANA ROCIO | | 0710910018 | ALZATE ARROYAVE MAURICIO | | 0880920004 | CORDOBA GARCIA JESBER | | 0880920022 | ARBOLEDA PALACIOS YUSLY YULIPSA | | 0880920023 | DIAZ RAMIREZ OSCAR GERMAN | | 0880920025 | OSPINA MORENO MARGARITA MARIA | | 0710910007 | QUINCHIA CHAVERRA EDWIN ALEXANDER | | 0750920012 | BENJUMEA HERRERA CAMILO ANDRES | | 0751016012 | PALACIOS PALACIOS JESSIE JACKSON | | 0881010011 | RESTREPO GOMEZ RUBEN FERNANDO | | 0751020021 | LONDONO OCAMPO WALTER FABER | | 0751020018 | CALIXTO BETANCOURT JENNY MARCELA | | 0751020017 | GOMEZ JIMENEZ DEICY JULIANA | | 0751010013 | DUQUE LOPEZ YESID ANDRES | | 0751010021 | SALAZAR ALZATE LEON RODRIGO | | 0751026030 | RAMOS ASPRILLA YUBER JOSE | | 0881020007 | VANEGAS HENAO ELMER ANDRES | | 0881020031 | MUNOZ MONSALVE CIPRIANO ANTONIO | | 0881010015 | PEREZ CARDENAS STEFANIA | | 0711020003 | AGUILAR LARGO JESUS AUGUSTO | | 0751016023 | LOPERA AGUDELO MARIA MAGDALENA | | 0751010015 | LOPERA BUILES VICTOR ARLEY | | 0881110017 | GRAJALES MUNOZ VICTOR CAMILO | | 0751110010 | FUENTES VARGAS EDUWIN DANIEL | | 0751116031 | QUINTERO MONTES AICARDO | | 0881110026 | GARCIA LOPEZ GAYO | | 0881110029 | RODRIGUEZ HERNANDEZ PAOLA TATIANA | | 0881110004 | BLANDON TORRES OVIDIO ALBERTO | | 0881110030 | GONZALEZ SIERRA JONATAN ANDRES | | 0881110013 | AGUDLO SIERRA JOHAN SEBASTIAN | | 0751110046 | ISAZA MORALES NELSON JOVANNY | | 0751110047 | VEGA BONILLA LIZET VANESSA | | 0751110034 | RODRIGUEZ CARDONA YENY ANDREA | | 0751110018 | VERGARA DIAZ YURANIS MARLEY | | 0751110017 | RAMIREZ HERMES | | 0751116028 | VERGARA RUA NANCY JULIETH | | 0751116033 | RENTERIA SANABRIA LUIS ANTONIO | | 0751110036 | MUNOZ CADAVID ANA MARINA | | 0881110009 | GOMEZ BRAVO LUIS GABRIEL | | 0751110014 | ROJAS VALENCIA OSCAR FERNANDO | | 0721110034 | GARCIA MENDEZ SARA DANIELA | | 0721110008 | HIDALGO CADAVID CAROLINA | | 0721110006 | CASTRO SUAREZ RUTH ANGELICA | | 0601110015 | CUADROS BALDRICH MARIA ALEJANDRA | | 0701110063 | ARIAS JIMENEZ JOHAN | | 0701110051 | FAJARDO QUINTERO JOHANA CATALINA | | 0701110037 | FLOREZ SALDARRIAGA MIGUEL ANGEL | | 0701110036 | MALLAMA GIRALDO ANGIE CAROLINA | | 0701110031 | MARTINEZ PATINO YULIETH PAOLA | | 0701110016 | CHICA JANNA JUAN DAVID | | 0701110013 | JARAMILLO MONTOYA JUAN PABLO | | 0701110007 | ANGEL ACEVEDO LEIDY TATIANA | | 0721110012 | GARCIA MORALES LUISA FERNANDA | | 0721110017 | GALVIS CUESTA KELLY JOHANA | | 0701110055 | GALLEGO ZAPATA SINDY CATHERINNE | | 0741110016 | GRANADOS MARIN DAVID FELIPE | | 0741110010 | PALACIOS QUINTO SNDY | | 0731110020 | MACIAS HERNANDEZ YURI ALEIDA | | 0731110017 | MADRID MURILLO ARLENYS | | 0721110036 | GOMEZ BELTRAN KATHERINE JOHANA | | 0721110033 | BEDOYA ACEVEDO LILIANA | | 0721110028 | MANCILLA MONTERO MARLYS MACIEL | | 0721110025 | CASTRILLON SALAZAR ISABEL CRISTINA | | 0721110023 | SAENZ DANIELA FERNANDA | | 0721110022 | CORREA GONZALEZ GABRIEL JOSE | | 0601110034 | HOLGUIN MUNOZ HERVIN HAROLD | +------------+------------------------------------+ 82 rows in set (0.001 sec) MariaDB [cadena]> select nombre from alumno where character_length(nombre) < 20; +---------------------+ | nombre | +---------------------+ | ARIAS JIMENEZ JOHAN | | RAMIREZ HERMES | | GARCIA LOPEZ GAYO | +---------------------+ 3 rows in set (0.000 sec) MariaDB [cadena]> select nombre from alumno where character_length(nombre) > 20; +------------------------------------+ | nombre | +------------------------------------+ | CUADROS BALDRICH MARIA ALEJANDRA | | HOLGUIN MUNOZ HERVIN HAROLD | | ORREGO LOZANO JUAN JOSE | | ANGEL ACEVEDO LEIDY TATIANA | | JARAMILLO MONTOYA JUAN PABLO | | CHICA JANNA JUAN DAVID | | MARTINEZ PATINO YULIETH PAOLA | | MALLAMA GIRALDO ANGIE CAROLINA | | FLOREZ SALDARRIAGA MIGUEL ANGEL | | FAJARDO QUINTERO JOHANA CATALINA | | GALLEGO ZAPATA SINDY CATHERINNE | | YEPES GRISALES NATHALIA | | QUINTERO JOSE MIGUEL | | BOLIVAR CARTAGENA GUILLERMO ALEXIS | | ZULUAGA DIAZ HECTOR EDUARDO | | ZAPATA BEDOYA VICTOR FABIAN | | CONDE ALVAREZ YESICA YESSENIA | | ADARMES MURCIA JESSICA BRIGHIT | | QUINCHIA CHAVERRA EDWIN ALEXANDER | | ALZATE ARROYAVE MAURICIO | | AGUILAR LARGO JESUS AUGUSTO | | CASTRO SUAREZ RUTH ANGELICA | | HIDALGO CADAVID CAROLINA | | GARCIA MORALES LUISA FERNANDA | | GALVIS CUESTA KELLY JOHANA | | CORREA GONZALEZ GABRIEL JOSE | | SAENZ DANIELA FERNANDA | | CASTRILLON SALAZAR ISABEL CRISTINA | | MANCILLA MONTERO MARLYS MACIEL | | BEDOYA ACEVEDO LILIANA | | GARCIA MENDEZ SARA DANIELA | | GOMEZ BELTRAN KATHERINE JOHANA | | MADRID MURILLO ARLENYS | | MACIAS HERNANDEZ YURI ALEIDA | | GRANADOS MARIN DAVID FELIPE | | HENAO BRAN DIXON RODRIGO | | PALACIOS ALUMA MARBIN | | LONDONO HERRERA DORIAN ALEXANDER | | ESTRADA MARTINEZ ANET ELLACY | | OROZCO MONTOYA MARLON FELIPE | | BLANDON NARANJO ADRIANA MARIA | | MONTOYA LONDONO SERGIO ANDRES | | ECHAVARRIA RIOS JENIFER ANDREA | | SEPULVEDA GARCIA ADRIANA ROCIO | | BENJUMEA HERRERA CAMILO ANDRES | | DUQUE LOPEZ YESID ANDRES | | LOPERA BUILES VICTOR ARLEY | | SALAZAR ALZATE LEON RODRIGO | | PALACIOS PALACIOS JESSIE JACKSON | | LOPERA AGUDELO MARIA MAGDALENA | | GOMEZ JIMENEZ DEICY JULIANA | | CALIXTO BETANCOURT JENNY MARCELA | | LONDONO OCAMPO WALTER FABER | | RAMOS ASPRILLA YUBER JOSE | | FUENTES VARGAS EDUWIN DANIEL | | ROJAS VALENCIA OSCAR FERNANDO | | VERGARA DIAZ YURANIS MARLEY | | RODRIGUEZ CARDONA YENY ANDREA | | MUNOZ CADAVID ANA MARINA | | ISAZA MORALES NELSON JOVANNY | | VEGA BONILLA LIZET VANESSA | | VERGARA RUA NANCY JULIETH | | QUINTERO MONTES AICARDO | | RENTERIA SANABRIA LUIS ANTONIO | | CORDOBA GARCIA JESBER | | ARBOLEDA PALACIOS YUSLY YULIPSA | | DIAZ RAMIREZ OSCAR GERMAN | | OSPINA MORENO MARGARITA MARIA | | RESTREPO GOMEZ RUBEN FERNANDO | | PEREZ CARDENAS STEFANIA | | VANEGAS HENAO ELMER ANDRES | | MUNOZ MONSALVE CIPRIANO ANTONIO | | BLANDON TORRES OVIDIO ALBERTO | | GOMEZ BRAVO LUIS GABRIEL | | AGUDLO SIERRA JOHAN SEBASTIAN | | GRAJALES MUNOZ VICTOR CAMILO | | RODRIGUEZ HERNANDEZ PAOLA TATIANA | | GONZALEZ SIERRA JONATAN ANDRES | +------------------------------------+ 78 rows in set (0.000 sec) MariaDB [cadena]> select nombre from alumno where character_length(nombre) >= 20; +------------------------------------+ | nombre | +------------------------------------+ | CUADROS BALDRICH MARIA ALEJANDRA | | HOLGUIN MUNOZ HERVIN HAROLD | | ORREGO LOZANO JUAN JOSE | | ANGEL ACEVEDO LEIDY TATIANA | | JARAMILLO MONTOYA JUAN PABLO | | CHICA JANNA JUAN DAVID | | MARTINEZ PATINO YULIETH PAOLA | | MALLAMA GIRALDO ANGIE CAROLINA | | FLOREZ SALDARRIAGA MIGUEL ANGEL | | FAJARDO QUINTERO JOHANA CATALINA | | GALLEGO ZAPATA SINDY CATHERINNE | | YEPES GRISALES NATHALIA | | QUINTERO JOSE MIGUEL | | BOLIVAR CARTAGENA GUILLERMO ALEXIS | | ZULUAGA DIAZ HECTOR EDUARDO | | ZAPATA BEDOYA VICTOR FABIAN | | CONDE ALVAREZ YESICA YESSENIA | | ADARMES MURCIA JESSICA BRIGHIT | | QUINCHIA CHAVERRA EDWIN ALEXANDER | | ALZATE ARROYAVE MAURICIO | | AGUILAR LARGO JESUS AUGUSTO | | CASTRO SUAREZ RUTH ANGELICA | | HIDALGO CADAVID CAROLINA | | GARCIA MORALES LUISA FERNANDA | | GALVIS CUESTA KELLY JOHANA | | CORREA GONZALEZ GABRIEL JOSE | | SAENZ DANIELA FERNANDA | | CASTRILLON SALAZAR ISABEL CRISTINA | | MANCILLA MONTERO MARLYS MACIEL | | BEDOYA ACEVEDO LILIANA | | GARCIA MENDEZ SARA DANIELA | | GOMEZ BELTRAN KATHERINE JOHANA | | MADRID MURILLO ARLENYS | | MACIAS HERNANDEZ YURI ALEIDA | | PALACIOS QUINTO SNDY | | GRANADOS MARIN DAVID FELIPE | | HENAO BRAN DIXON RODRIGO | | PALACIOS ALUMA MARBIN | | LONDONO HERRERA DORIAN ALEXANDER | | ESTRADA MARTINEZ ANET ELLACY | | OROZCO MONTOYA MARLON FELIPE | | BLANDON NARANJO ADRIANA MARIA | | MONTOYA LONDONO SERGIO ANDRES | | ECHAVARRIA RIOS JENIFER ANDREA | | SEPULVEDA GARCIA ADRIANA ROCIO | | BENJUMEA HERRERA CAMILO ANDRES | | DUQUE LOPEZ YESID ANDRES | | LOPERA BUILES VICTOR ARLEY | | SALAZAR ALZATE LEON RODRIGO | | PALACIOS PALACIOS JESSIE JACKSON | | LOPERA AGUDELO MARIA MAGDALENA | | GOMEZ JIMENEZ DEICY JULIANA | | CALIXTO BETANCOURT JENNY MARCELA | | LONDONO OCAMPO WALTER FABER | | RAMOS ASPRILLA YUBER JOSE | | FUENTES VARGAS EDUWIN DANIEL | | ROJAS VALENCIA OSCAR FERNANDO | | VERGARA DIAZ YURANIS MARLEY | | RODRIGUEZ CARDONA YENY ANDREA | | MUNOZ CADAVID ANA MARINA | | ISAZA MORALES NELSON JOVANNY | | VEGA BONILLA LIZET VANESSA | | VERGARA RUA NANCY JULIETH | | QUINTERO MONTES AICARDO | | RENTERIA SANABRIA LUIS ANTONIO | | CORDOBA GARCIA JESBER | | ARBOLEDA PALACIOS YUSLY YULIPSA | | DIAZ RAMIREZ OSCAR GERMAN | | OSPINA MORENO MARGARITA MARIA | | RESTREPO GOMEZ RUBEN FERNANDO | | PEREZ CARDENAS STEFANIA | | VANEGAS HENAO ELMER ANDRES | | MUNOZ MONSALVE CIPRIANO ANTONIO | | BLANDON TORRES OVIDIO ALBERTO | | GOMEZ BRAVO LUIS GABRIEL | | AGUDLO SIERRA JOHAN SEBASTIAN | | GRAJALES MUNOZ VICTOR CAMILO | | RODRIGUEZ HERNANDEZ PAOLA TATIANA | | GONZALEZ SIERRA JONATAN ANDRES | +------------------------------------+ 79 rows in set (0.001 sec) MariaDB [cadena]> select nombre from alumno where character_length(nombre)= 20; +----------------------+ | nombre | +----------------------+ | PALACIOS QUINTO SNDY | +----------------------+ 1 row in set (0.001 sec) MariaDB [cadena]> select * from alumno where substr(carnet,1,2) in ('07') and substr(carnet,6,1) in ('1') and substr(carnet,4,1) < ('07'); +------------+-----------------------------------+ | carnet | nombre | +------------+-----------------------------------+ | 0700310071 | ORREGO LOZANO JUAN JOSE | | 0710910007 | QUINCHIA CHAVERRA EDWIN ALEXANDER | | 0710910018 | ALZATE ARROYAVE MAURICIO | | 0750210001 | HENAO BRAN DIXON RODRIGO | | 0750310024 | PALACIOS ALUMA MARBIN | | 0750410035 | LONDONO HERRERA DORIAN ALEXANDER | | 0750616022 | ESTRADA MARTINEZ ANET ELLACY | | 0750710001 | OROZCO MONTOYA MARLON FELIPE | | 0750710003 | BLANDON NARANJO ADRIANA MARIA | | 0750710014 | MONTOYA LONDONO SERGIO ANDRES | | 0750816010 | ECHAVARRIA RIOS JENIFER ANDREA | +------------+-----------------------------------+ 11 rows in set (0.001 sec) MariaDB [cadena]> select max(carnet) from alumno where substr(carnet,7,1); +-------------+ | max(carnet) | +-------------+ | 0751116033 | +-------------+ 1 row in set (0.001 sec) MariaDB [cadena]> select max(carnet) from alumno where substr(carnet,1,2) not in ('07') and substr(carnet,7,4); +-------------+ | max(carnet) | +-------------+ | 0881110030 | +-------------+ 1 row in set (0.001 sec) MariaDB [cadena]> select carnet,nombre,if(carnet like'088%','10% descuento','No descuento') from alumno; +------------+------------------------------------+------------------------------------------------------+ | carnet | nombre | if(carnet like'088%','10% descuento','No descuento') | +------------+------------------------------------+------------------------------------------------------+ | 0601110015 | CUADROS BALDRICH MARIA ALEJANDRA | No descuento | | 0601110034 | HOLGUIN MUNOZ HERVIN HAROLD | No descuento | | 0700310071 | ORREGO LOZANO JUAN JOSE | No descuento | | 0701110007 | ANGEL ACEVEDO LEIDY TATIANA | No descuento | | 0701110013 | JARAMILLO MONTOYA JUAN PABLO | No descuento | | 0701110016 | CHICA JANNA JUAN DAVID | No descuento | | 0701110031 | MARTINEZ PATINO YULIETH PAOLA | No descuento | | 0701110036 | MALLAMA GIRALDO ANGIE CAROLINA | No descuento | | 0701110037 | FLOREZ SALDARRIAGA MIGUEL ANGEL | No descuento | | 0701110051 | FAJARDO QUINTERO JOHANA CATALINA | No descuento | | 0701110055 | GALLEGO ZAPATA SINDY CATHERINNE | No descuento | | 0701110063 | ARIAS JIMENEZ JOHAN | No descuento | | 0710620022 | YEPES GRISALES NATHALIA | No descuento | | 0710720005 | QUINTERO JOSE MIGUEL | No descuento | | 0710720010 | BOLIVAR CARTAGENA GUILLERMO ALEXIS | No descuento | | 0710820004 | ZULUAGA DIAZ HECTOR EDUARDO | No descuento | | 0710820025 | ZAPATA BEDOYA VICTOR FABIAN | No descuento | | 0710820026 | CONDE ALVAREZ YESICA YESSENIA | No descuento | | 0710820034 | ADARMES MURCIA JESSICA BRIGHIT | No descuento | | 0710910007 | QUINCHIA CHAVERRA EDWIN ALEXANDER | No descuento | | 0710910018 | ALZATE ARROYAVE MAURICIO | No descuento | | 0711020003 | AGUILAR LARGO JESUS AUGUSTO | No descuento | | 0721110006 | CASTRO SUAREZ RUTH ANGELICA | No descuento | | 0721110008 | HIDALGO CADAVID CAROLINA | No descuento | | 0721110012 | GARCIA MORALES LUISA FERNANDA | No descuento | | 0721110017 | GALVIS CUESTA KELLY JOHANA | No descuento | | 0721110022 | CORREA GONZALEZ GABRIEL JOSE | No descuento | | 0721110023 | SAENZ DANIELA FERNANDA | No descuento | | 0721110025 | CASTRILLON SALAZAR ISABEL CRISTINA | No descuento | | 0721110028 | MANCILLA MONTERO MARLYS MACIEL | No descuento | | 0721110033 | BEDOYA ACEVEDO LILIANA | No descuento | | 0721110034 | GARCIA MENDEZ SARA DANIELA | No descuento | | 0721110036 | GOMEZ BELTRAN KATHERINE JOHANA | No descuento | | 0731110017 | MADRID MURILLO ARLENYS | No descuento | | 0731110020 | MACIAS HERNANDEZ YURI ALEIDA | No descuento | | 0741110010 | PALACIOS QUINTO SNDY | No descuento | | 0741110016 | GRANADOS MARIN DAVID FELIPE | No descuento | | 0750210001 | HENAO BRAN DIXON RODRIGO | No descuento | | 0750310024 | PALACIOS ALUMA MARBIN | No descuento | | 0750410035 | LONDONO HERRERA DORIAN ALEXANDER | No descuento | | 0750616022 | ESTRADA MARTINEZ ANET ELLACY | No descuento | | 0750710001 | OROZCO MONTOYA MARLON FELIPE | No descuento | | 0750710003 | BLANDON NARANJO ADRIANA MARIA | No descuento | | 0750710014 | MONTOYA LONDONO SERGIO ANDRES | No descuento | | 0750816010 | ECHAVARRIA RIOS JENIFER ANDREA | No descuento | | 0750826036 | SEPULVEDA GARCIA ADRIANA ROCIO | No descuento | | 0750920012 | BENJUMEA HERRERA CAMILO ANDRES | No descuento | | 0751010013 | DUQUE LOPEZ YESID ANDRES | No descuento | | 0751010015 | LOPERA BUILES VICTOR ARLEY | No descuento | | 0751010021 | SALAZAR ALZATE LEON RODRIGO | No descuento | | 0751016012 | PALACIOS PALACIOS JESSIE JACKSON | No descuento | | 0751016023 | LOPERA AGUDELO MARIA MAGDALENA | No descuento | | 0751020017 | GOMEZ JIMENEZ DEICY JULIANA | No descuento | | 0751020018 | CALIXTO BETANCOURT JENNY MARCELA | No descuento | | 0751020021 | LONDONO OCAMPO WALTER FABER | No descuento | | 0751026030 | RAMOS ASPRILLA YUBER JOSE | No descuento | | 0751110010 | FUENTES VARGAS EDUWIN DANIEL | No descuento | | 0751110014 | ROJAS VALENCIA OSCAR FERNANDO | No descuento | | 0751110017 | RAMIREZ HERMES | No descuento | | 0751110018 | VERGARA DIAZ YURANIS MARLEY | No descuento | | 0751110034 | RODRIGUEZ CARDONA YENY ANDREA | No descuento | | 0751110036 | MUNOZ CADAVID ANA MARINA | No descuento | | 0751110046 | ISAZA MORALES NELSON JOVANNY | No descuento | | 0751110047 | VEGA BONILLA LIZET VANESSA | No descuento | | 0751116028 | VERGARA RUA NANCY JULIETH | No descuento | | 0751116031 | QUINTERO MONTES AICARDO | No descuento | | 0751116033 | RENTERIA SANABRIA LUIS ANTONIO | No descuento | | 0880920004 | CORDOBA GARCIA JESBER | 10% descuento | | 0880920022 | ARBOLEDA PALACIOS YUSLY YULIPSA | 10% descuento | | 0880920023 | DIAZ RAMIREZ OSCAR GERMAN | 10% descuento | | 0880920025 | OSPINA MORENO MARGARITA MARIA | 10% descuento | | 0881010011 | RESTREPO GOMEZ RUBEN FERNANDO | 10% descuento | | 0881010015 | PEREZ CARDENAS STEFANIA | 10% descuento | | 0881020007 | VANEGAS HENAO ELMER ANDRES | 10% descuento | | 0881020031 | MUNOZ MONSALVE CIPRIANO ANTONIO | 10% descuento | | 0881110004 | BLANDON TORRES OVIDIO ALBERTO | 10% descuento | | 0881110009 | GOMEZ BRAVO LUIS GABRIEL | 10% descuento | | 0881110013 | AGUDLO SIERRA JOHAN SEBASTIAN | 10% descuento | | 0881110017 | GRAJALES MUNOZ VICTOR CAMILO | 10% descuento | | 0881110026 | GARCIA LOPEZ GAYO | 10% descuento | | 0881110029 | RODRIGUEZ HERNANDEZ PAOLA TATIANA | 10% descuento | | 0881110030 | GONZALEZ SIERRA JONATAN ANDRES | 10% descuento | +------------+------------------------------------+------------------------------------------------------+ 82 rows in set (0.000 sec) MariaDB [cadena]> select carnet,nombre,if(carnet like'088%' or carnet like '075%','10% descuento','No descuento') from alumno; +------------+------------------------------------+----------------------------------------------------------------------------+ | carnet | nombre | if(carnet like'088%' or carnet like '075%','10% descuento','No descuento') | +------------+------------------------------------+----------------------------------------------------------------------------+ | 0601110015 | CUADROS BALDRICH MARIA ALEJANDRA | No descuento | | 0601110034 | HOLGUIN MUNOZ HERVIN HAROLD | No descuento | | 0700310071 | ORREGO LOZANO JUAN JOSE | No descuento | | 0701110007 | ANGEL ACEVEDO LEIDY TATIANA | No descuento | | 0701110013 | JARAMILLO MONTOYA JUAN PABLO | No descuento | | 0701110016 | CHICA JANNA JUAN DAVID | No descuento | | 0701110031 | MARTINEZ PATINO YULIETH PAOLA | No descuento | | 0701110036 | MALLAMA GIRALDO ANGIE CAROLINA | No descuento | | 0701110037 | FLOREZ SALDARRIAGA MIGUEL ANGEL | No descuento | | 0701110051 | FAJARDO QUINTERO JOHANA CATALINA | No descuento | | 0701110055 | GALLEGO ZAPATA SINDY CATHERINNE | No descuento | | 0701110063 | ARIAS JIMENEZ JOHAN | No descuento | | 0710620022 | YEPES GRISALES NATHALIA | No descuento | | 0710720005 | QUINTERO JOSE MIGUEL | No descuento | | 0710720010 | BOLIVAR CARTAGENA GUILLERMO ALEXIS | No descuento | | 0710820004 | ZULUAGA DIAZ HECTOR EDUARDO | No descuento | | 0710820025 | ZAPATA BEDOYA VICTOR FABIAN | No descuento | | 0710820026 | CONDE ALVAREZ YESICA YESSENIA | No descuento | | 0710820034 | ADARMES MURCIA JESSICA BRIGHIT | No descuento | | 0710910007 | QUINCHIA CHAVERRA EDWIN ALEXANDER | No descuento | | 0710910018 | ALZATE ARROYAVE MAURICIO | No descuento | | 0711020003 | AGUILAR LARGO JESUS AUGUSTO | No descuento | | 0721110006 | CASTRO SUAREZ RUTH ANGELICA | No descuento | | 0721110008 | HIDALGO CADAVID CAROLINA | No descuento | | 0721110012 | GARCIA MORALES LUISA FERNANDA | No descuento | | 0721110017 | GALVIS CUESTA KELLY JOHANA | No descuento | | 0721110022 | CORREA GONZALEZ GABRIEL JOSE | No descuento | | 0721110023 | SAENZ DANIELA FERNANDA | No descuento | | 0721110025 | CASTRILLON SALAZAR ISABEL CRISTINA | No descuento | | 0721110028 | MANCILLA MONTERO MARLYS MACIEL | No descuento | | 0721110033 | BEDOYA ACEVEDO LILIANA | No descuento | | 0721110034 | GARCIA MENDEZ SARA DANIELA | No descuento | | 0721110036 | GOMEZ BELTRAN KATHERINE JOHANA | No descuento | | 0731110017 | MADRID MURILLO ARLENYS | No descuento | | 0731110020 | MACIAS HERNANDEZ YURI ALEIDA | No descuento | | 0741110010 | PALACIOS QUINTO SNDY | No descuento | | 0741110016 | GRANADOS MARIN DAVID FELIPE | No descuento | | 0750210001 | HENAO BRAN DIXON RODRIGO | 10% descuento | | 0750310024 | PALACIOS ALUMA MARBIN | 10% descuento | | 0750410035 | LONDONO HERRERA DORIAN ALEXANDER | 10% descuento | | 0750616022 | ESTRADA MARTINEZ ANET ELLACY | 10% descuento | | 0750710001 | OROZCO MONTOYA MARLON FELIPE | 10% descuento | | 0750710003 | BLANDON NARANJO ADRIANA MARIA | 10% descuento | | 0750710014 | MONTOYA LONDONO SERGIO ANDRES | 10% descuento | | 0750816010 | ECHAVARRIA RIOS JENIFER ANDREA | 10% descuento | | 0750826036 | SEPULVEDA GARCIA ADRIANA ROCIO | 10% descuento | | 0750920012 | BENJUMEA HERRERA CAMILO ANDRES | 10% descuento | | 0751010013 | DUQUE LOPEZ YESID ANDRES | 10% descuento | | 0751010015 | LOPERA BUILES VICTOR ARLEY | 10% descuento | | 0751010021 | SALAZAR ALZATE LEON RODRIGO | 10% descuento | | 0751016012 | PALACIOS PALACIOS JESSIE JACKSON | 10% descuento | | 0751016023 | LOPERA AGUDELO MARIA MAGDALENA | 10% descuento | | 0751020017 | GOMEZ JIMENEZ DEICY JULIANA | 10% descuento | | 0751020018 | CALIXTO BETANCOURT JENNY MARCELA | 10% descuento | | 0751020021 | LONDONO OCAMPO WALTER FABER | 10% descuento | | 0751026030 | RAMOS ASPRILLA YUBER JOSE | 10% descuento | | 0751110010 | FUENTES VARGAS EDUWIN DANIEL | 10% descuento | | 0751110014 | ROJAS VALENCIA OSCAR FERNANDO | 10% descuento | | 0751110017 | RAMIREZ HERMES | 10% descuento | | 0751110018 | VERGARA DIAZ YURANIS MARLEY | 10% descuento | | 0751110034 | RODRIGUEZ CARDONA YENY ANDREA | 10% descuento | | 0751110036 | MUNOZ CADAVID ANA MARINA | 10% descuento | | 0751110046 | ISAZA MORALES NELSON JOVANNY | 10% descuento | | 0751110047 | VEGA BONILLA LIZET VANESSA | 10% descuento | | 0751116028 | VERGARA RUA NANCY JULIETH | 10% descuento | | 0751116031 | QUINTERO MONTES AICARDO | 10% descuento | | 0751116033 | RENTERIA SANABRIA LUIS ANTONIO | 10% descuento | | 0880920004 | CORDOBA GARCIA JESBER | 10% descuento | | 0880920022 | ARBOLEDA PALACIOS YUSLY YULIPSA | 10% descuento | | 0880920023 | DIAZ RAMIREZ OSCAR GERMAN | 10% descuento | | 0880920025 | OSPINA MORENO MARGARITA MARIA | 10% descuento | | 0881010011 | RESTREPO GOMEZ RUBEN FERNANDO | 10% descuento | | 0881010015 | PEREZ CARDENAS STEFANIA | 10% descuento | | 0881020007 | VANEGAS HENAO ELMER ANDRES | 10% descuento | | 0881020031 | MUNOZ MONSALVE CIPRIANO ANTONIO | 10% descuento | | 0881110004 | BLANDON TORRES OVIDIO ALBERTO | 10% descuento | | 0881110009 | GOMEZ BRAVO LUIS GABRIEL | 10% descuento | | 0881110013 | AGUDLO SIERRA JOHAN SEBASTIAN | 10% descuento | | 0881110017 | GRAJALES MUNOZ VICTOR CAMILO | 10% descuento | | 0881110026 | GARCIA LOPEZ GAYO | 10% descuento | | 0881110029 | RODRIGUEZ HERNANDEZ PAOLA TATIANA | 10% descuento | | 0881110030 | GONZALEZ SIERRA JONATAN ANDRES | 10% descuento | +------------+------------------------------------+----------------------------------------------------------------------------+ 82 rows in set (0.000 sec) MariaDB [cadena]> exit