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 max(carnet) from alumno where substr(carnet,1,2) in ('07') and substr(carnet,7,4); +-------------+ | max(carnet) | +-------------+ | 0751116033 | +-------------+ 1 row in set (0,001 sec) MariaDB [cadena]> select max(carnet) from alumno where substr(carnet,1,2) in ('07'); +-------------+ | max(carnet) | +-------------+ | 0751116033 | +-------------+ 1 row in set (0,001 sec) MariaDB [cadena]> select max(carnet) from alumno where substr(carnet,7,4) not in ('07'); +-------------+ | max(carnet) | +-------------+ | 0881110030 | +-------------+ 1 row in set (0,001 sec) MariaDB [cadena]> select * from alumno where substr(carnet,1,2) > ('07'); +------------+-----------------------------------+ | carnet | nombre | +------------+-----------------------------------+ | 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 | +------------+-----------------------------------+ 15 rows in set (0,001 sec) MariaDB [cadena]> select max(carnet) from alumno where substr(carnet,1,2) in ('07') and substr(carnet,7,4); +-------------+ | 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 * from alumno where substr(carnet,1,3) in ('088') -> ; +------------+-----------------------------------+ | carnet | nombre | +------------+-----------------------------------+ | 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 | +------------+-----------------------------------+ 15 rows 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,001 sec) MariaDB [cadena]> notee;