Microsoft Windows [Versión 10.0.22631.5039] (c) Microsoft Corporation. Todos los derechos reservados. C:\Users\Yeison>cd/xampp/mysql/bin C:\xampp\mysql\bin> C:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.4.32-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> create database Aplicacion_cadena; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | aplicacion_cadena | | cadena | | information_schema | | mysql | | performance_schema | | phpmyadmin | | subconsultas | | test | | veterinaria | +--------------------+ 9 rows in set (0.034 sec) MariaDB [(none)]> use Aplicacion_cadena; Database changed MariaDB [Aplicacion_cadena]> CREATE TABLE Discente ( -> carnet VARCHAR(20) PRIMARY KEY, -> nombre VARCHAR(100) NOT NULL -> ); Query OK, 0 rows affected (0.013 sec) MariaDB [Aplicacion_cadena]> show tables; +-----------------------------+ | Tables_in_aplicacion_cadena | +-----------------------------+ | discente | +-----------------------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> decribe Discente; 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 'decribe Discente' at line 1 MariaDB [Aplicacion_cadena]> describe Discente; +--------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------+-------+ | carnet | varchar(20) | NO | PRI | NULL | | | nombre | varchar(100) | NO | | NULL | | +--------+--------------+------+-----+---------+-------+ 2 rows in set (0.014 sec) 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ÉS 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'), -> ('200820040075', 'WALTON MAYA NATALIA MARIA'), -> ('200920009075', 'ATEHORTUA LONDOÑO JUAN CAMILO'), -> ('201220003075', 'BLANDON LONDOÑO CRISTIAN MAURICIO'), -> ('201010005075', 'CASTRO HERNANDEZ MARIA CRISTINA'), -> ('201110019088', 'CASTRO NAVIA KARINA'), -> ('201020003088', 'CEBALLOS BETANCUR DANIEL STEVEN'), -> ('201222003075', 'RESTREPO GOMEZ RUBEN FERNANDO'), -> ('201110034075', 'RODRIGUEZ CARDONA YENY ANDREA'), -> ('201310016075', 'VALDERRAMA MAHECHA DIEGO ALEJANDRO'), -> ('201222007073', 'AREIZA VERA JOHN FREDY'), -> ('201110058073', 'BURGOS ECHEVERRY LISBETH'), -> ('201222008073', 'DOMINGUEZ GOMEZ LIBIA ESTELA'), -> ('201314005073', 'DURANGO RODRIGUEZ JESUS HUMBEIRO'), -> ('200910069073', 'FUENTES FLOREZ JESSICA VIVIANA'), -> ('201312008075', 'JARAMILLO LUIS FERNANDO'), -> ('201120004073', 'LOPERA GUTIERREZ ALBA MIREYLLE'), -> ('201120036073', 'MENA ARTEAGA JUAN NORBERTO'), -> ('201120028073', 'OSPINA DAVID DORA ALBA'), -> ('200820036073', 'RIOS QUINCHIA TATIANA'), -> ('200920013073', 'SILVA ARIAS NANCY CRISTINA'), -> ('201312001088', 'VARELA BEDOYA DAISSY ANDREA'), -> ('201120030073', 'VELASQUEZ ACEVEDO BIVIANA ELIZABETH'), -> ('201324013073', 'VELEZ DIANA MARCELA'), -> ('200910007073', 'ZAPATA VALENCIA OLGA LUCIA'), -> ('201320024070', 'BOLAÑO MADERA MAIRA MIRITH'), -> ('201320016070', 'GRISALES ISAZA PAOLA ANDREA'), -> ('201320005086', 'GUTÍERREZ SEGURO BEATRIZ'), -> ('201320005073', 'HOYOS HENAO JORGE NILTON'), -> ('201320002073', 'LEON ESTEVEZ DEISY YOLIMA'), -> ('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'), -> ('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'), -> ('201320006074', 'YEPES HENAO MONICA'); Query OK, 91 rows affected (0.030 sec) Records: 91 Duplicates: 0 Warnings: 0 MariaDB [Aplicacion_cadena]> select * from Dicente; ERROR 1146 (42S02): Table 'aplicacion_cadena.dicente' doesn't exist MariaDB [Aplicacion_cadena]> select * from Discente; +--------------+-------------------------------------+ | carnet | nombre | +--------------+-------------------------------------+ | 200820036073 | RIOS QUINCHIA TATIANA | | 200820040075 | WALTON MAYA NATALIA MARIA | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 200910007073 | ZAPATA VALENCIA OLGA LUCIA | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | | 200910069073 | FUENTES FLOREZ JESSICA VIVIANA | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 200920009075 | ATEHORTUA LONDOÑO JUAN CAMILO | | 200920013073 | SILVA ARIAS NANCY CRISTINA | | 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 | | 201110058073 | BURGOS ECHEVERRY LISBETH | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | | 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 | | 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 | | 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ÉS FELIPE | | 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 | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201320011059 | MUÑOZ LOPEZ JONATHATAN FELIPE | | 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS | | 201320013070 | TIECK MACIAS NICOLAS | | 201320013074 | MURILLO MURILLO VIDAL CAMILO | | 201320016070 | GRISALES ISAZA PAOLA ANDREA | | 201320021075 | PEREZ YEISON FABIAN | | 201320024070 | BOLAÑO MADERA MAIRA MIRITH | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | | 201324013073 | VELEZ DIANA MARCELA | +--------------+-------------------------------------+ 91 rows in set (0.000 sec) MariaDB [Aplicacion_cadena]> select count(*) from alumno where substr(carnet,11,13) in ('075, 088'); ERROR 1146 (42S02): Table 'aplicacion_cadena.alumno' doesn't exist MariaDB [Aplicacion_cadena]> select count(*) from Discente where substr(carnet,11,13) in ('075, 088'); +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.000 sec) MariaDB [Aplicacion_cadena]> select count(*) from Discente where substr(carnet,10,12) in ('075, 088'); +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> select count(*) from Discente where substr(carnet,10,3) in ('075, 088'); +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> SELECT COUNT(*) -> FROM Discente -> WHERE SUBSTR(carnet, 10, 3) IN ('075', '088'); +----------+ | COUNT(*) | +----------+ | 61 | +----------+ 1 row in set (0.000 sec) MariaDB [Aplicacion_cadena]> select count(*) from Discente where substr(carnet,10,3) in ('075', '088'); +----------+ | count(*) | +----------+ | 61 | +----------+ 1 row in set (0.000 sec) MariaDB [Aplicacion_cadena]> select count(*) as Estudiantes from Discente where substr(carnet,10,3) in ('075', '088'); +-------------+ | Estudiantes | +-------------+ | 61 | +-------------+ 1 row in set (0.000 sec) MariaDB [Aplicacion_cadena]> select count(*) as Ingenieria from DISCENTE where substr(carnet,10,3) in ('075'); +------------+ | Ingenieria | +------------+ | 42 | +------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> select nombre as nombres<25 from discente where character_length(nombre) < 25; 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 '<25 from discente where character_length(nombre) < 25' at line 1 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 | | GUTÍERREZ SEGURO BEATRIZ | | RUIZ RIVERA ISABEL | | YEPES HENAO MONICA | | LONDOÑO MUÑOZ MARISOL | | MAZO MARIN ANA MARIA | | TIECK MACIAS NICOLAS | | PEREZ YEISON FABIAN | | VELEZ DIANA MARCELA | +--------------------------+ 23 rows in set (0.002 sec) MariaDB [Aplicacion_cadena]> select count(*) asNotSsitemas from dicentes where substr(carnet,10,2) not in ('08'); ERROR 1146 (42S02): Table 'aplicacion_cadena.dicentes' doesn't exist MariaDB [Aplicacion_cadena]> select count(*) as NotSsitemas from dicentes where substr(carnet,10,2) not in ('08'); ERROR 1146 (42S02): Table 'aplicacion_cadena.dicentes' doesn't exist MariaDB [Aplicacion_cadena]> select count(*) from dicentes where substr(carnet,10,2) not in ('08'); ERROR 1146 (42S02): Table 'aplicacion_cadena.dicentes' doesn't exist MariaDB [Aplicacion_cadena]> select count(*) from dicentes where substr(carnet,10,3) not in ('088'); ERROR 1146 (42S02): Table 'aplicacion_cadena.dicentes' doesn't exist MariaDB [Aplicacion_cadena]> SELECT COUNT(*) AS No_Tecnologia_Sistemas -> FROM Discente -> WHERE SUBSTR(carnet, 10, 3) NOT IN ('088'); +------------------------+ | No_Tecnologia_Sistemas | +------------------------+ | 72 | +------------------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> select * from discente; +--------------+-------------------------------------+ | carnet | nombre | +--------------+-------------------------------------+ | 200820036073 | RIOS QUINCHIA TATIANA | | 200820040075 | WALTON MAYA NATALIA MARIA | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | | 200910007073 | ZAPATA VALENCIA OLGA LUCIA | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | | 200910069073 | FUENTES FLOREZ JESSICA VIVIANA | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 200920009075 | ATEHORTUA LONDOÑO JUAN CAMILO | | 200920013073 | SILVA ARIAS NANCY CRISTINA | | 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 | | 201110058073 | BURGOS ECHEVERRY LISBETH | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | | 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 | | 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 | | 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ÉS FELIPE | | 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 | | 201320010075 | CORREA CORREA ANGELICA MARIA | | 201320011059 | MUÑOZ LOPEZ JONATHATAN FELIPE | | 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS | | 201320013070 | TIECK MACIAS NICOLAS | | 201320013074 | MURILLO MURILLO VIDAL CAMILO | | 201320016070 | GRISALES ISAZA PAOLA ANDREA | | 201320021075 | PEREZ YEISON FABIAN | | 201320024070 | BOLAÑO MADERA MAIRA MIRITH | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | | 201324013073 | VELEZ DIANA MARCELA | +--------------+-------------------------------------+ 91 rows in set (0.001 sec) MariaDB [Aplicacion_cadena]> select count(carnet) from discente where substr(carnet,3,2) < ('12'); +---------------+ | count(carnet) | +---------------+ | 31 | +---------------+ 1 row in set (0.000 sec) MariaDB [Aplicacion_cadena]> select count(carnet) as comenzaron_2012 from discente where substr(carnet,3,2) < ('12'); +-----------------+ | comenzaron_2012 | +-----------------+ | 31 | +-----------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> SELECT COUNT(carnet) AS comenzaron_2012 -> FROM Discente -> WHERE SUBSTR(carnet, 1, 4) = '2012'; +-----------------+ | comenzaron_2012 | +-----------------+ | 29 | +-----------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> SELECT COUNT(*) AS Total_primer_semestre -> FROM Discente -> WHERE SUBSTR(carnet, 5, 1) = '1'; +-----------------------+ | Total_primer_semestre | +-----------------------+ | 40 | +-----------------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> SELECT COUNT(*) AS Total_antes_2013 -> FROM Discente -> WHERE SUBSTR(carnet, 1, 4) < '2013'; +------------------+ | Total_antes_2013 | +------------------+ | 60 | +------------------+ 1 row in set (0.000 sec) MariaDB [Aplicacion_cadena]> SELECT -> carnet, -> nombre, -> SUBSTR(carnet, 1, 4) AS año_matricula -- Opcional: muestra el año extraído -> FROM Discente -> ORDER BY SUBSTR(carnet, 1, 4); -- Ordena por año ascendente (más antiguo a más reciente) +--------------+-------------------------------------+---------------+ | carnet | nombre | año_matricula | +--------------+-------------------------------------+---------------+ | 200820036073 | RIOS QUINCHIA TATIANA | 2008 | | 200820040075 | WALTON MAYA NATALIA MARIA | 2008 | | 200920013073 | SILVA ARIAS NANCY CRISTINA | 2009 | | 200920009075 | ATEHORTUA LONDOÑO JUAN CAMILO | 2009 | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | 2009 | | 200910069073 | FUENTES FLOREZ JESSICA VIVIANA | 2009 | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | 2009 | | 200910007073 | ZAPATA VALENCIA OLGA LUCIA | 2009 | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | 2009 | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | 2010 | | 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN | 2010 | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | 2010 | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | 2010 | | 201116037075 | MANYOMA GARCIA HENSLLY | 2011 | | 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE | 2011 | | 201120011088 | ASPRILLA LEUDO YILMAR | 2011 | | 201120028073 | OSPINA DAVID DORA ALBA | 2011 | | 201120030073 | VELASQUEZ ACEVEDO BIVIANA ELIZABETH | 2011 | | 201120036073 | MENA ARTEAGA JUAN NORBERTO | 2011 | | 201126012075 | ALVARADO RESTREPO ESTEBAN | 2011 | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | 2011 | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | 2011 | | 201110058073 | BURGOS ECHEVERRY LISBETH | 2011 | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | 2011 | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | 2011 | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | 2011 | | 201110017088 | GRAJALES MUÑOZ VICTOR CAMILO | 2011 | | 201110019088 | CASTRO NAVIA KARINA | 2011 | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | 2011 | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | 2011 | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | 2011 | | 201222000075 | RAMIREZ MONTOYA ANDRES | 2012 | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | 2012 | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | 2012 | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | 2012 | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | 2012 | | 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO | 2012 | | 201222004075 | VEGA MAZO OMAIRA MARIA | 2012 | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | 2012 | | 201222007073 | AREIZA VERA JOHN FREDY | 2012 | | 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA | 2012 | | 201223000088 | CALLE PUERTA LILIANA MARIA | 2012 | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | 2012 | | 201224000088 | GRANADA MESA VICTOR ALONSO | 2012 | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | 2012 | | 201220003075 | BLANDON LONDOÑO CRISTIAN MAURICIO | 2012 | | 201220002075 | LONDOÑO FONNEGRA JHONNY ALEXANDER | 2012 | | 201210005088 | HERRERA CARDONA JUAN DANIEL | 2012 | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | 2012 | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | 2012 | | 201210009088 | COLLAZO PATIÑO ALEX FERNEY | 2012 | | 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE | 2012 | | 201210022088 | OROZCO CARMONA DIDIER | 2012 | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | 2012 | | 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY | 2012 | | 201212003075 | ZAPATA ZUÑIGA ADRIANA PATRICIA | 2012 | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | 2012 | | 201213000088 | MONTOYA HENAO MARCELA | 2012 | | 201213002088 | ZULUAGA LONDOÑO ANGELA CRISTINA | 2012 | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | 2012 | | 201320011059 | MUÑOZ LOPEZ JONATHATAN FELIPE | 2013 | | 201320010075 | CORREA CORREA ANGELICA MARIA | 2013 | | 201320009070 | MAZO MARIN ANA MARIA | 2013 | | 201320008060 | LONDOÑO MUÑOZ MARISOL | 2013 | | 201320008059 | RODRIGUEZ VILLA YOHAN SEBASTIAN | 2013 | | 201320006074 | YEPES HENAO MONICA | 2013 | | 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS | 2013 | | 201320013070 | TIECK MACIAS NICOLAS | 2013 | | 201320013074 | MURILLO MURILLO VIDAL CAMILO | 2013 | | 201320016070 | GRISALES ISAZA PAOLA ANDREA | 2013 | | 201320021075 | PEREZ YEISON FABIAN | 2013 | | 201320024070 | BOLAÑO MADERA MAIRA MIRITH | 2013 | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | 2013 | | 201324013073 | VELEZ DIANA MARCELA | 2013 | | 201320006073 | RUIZ RIVERA ISABEL | 2013 | | 201320005086 | GUTÍERREZ SEGURO BEATRIZ | 2013 | | 201320005073 | HOYOS HENAO JORGE NILTON | 2013 | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | 2013 | | 201310026075 | ANGARITA TORRES IRAMA | 2013 | | 201312001088 | VARELA BEDOYA DAISSY ANDREA | 2013 | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | 2013 | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | 2013 | | 201312008075 | JARAMILLO LUIS FERNANDO | 2013 | | 201313001075 | CUESTA CUERVO YURY LORENA | 2013 | | 201313006075 | TEJADA CASTRO ANDRÉS FELIPE | 2013 | | 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO | 2013 | | 201320002073 | LEON ESTEVEZ DEISY YOLIMA | 2013 | | 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA | 2013 | | 201320003072 | LOPEZ BLANDON LUISA FERNANDA | 2013 | | 201320004072 | PATIÑO FLOREZ MARIA ANDREA | 2013 | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | 2013 | +--------------+-------------------------------------+---------------+ 91 rows in set (0.001 sec) MariaDB [Aplicacion_cadena]> SELECT carnet, nombre -> FROM Discente -> WHERE SUBSTR(carnet, 10, 3) = '075' -- Código de Ingeniería de Sistemas -> AND SUBSTR(carnet, 1, 4) < '2012' -- Matriculados antes de 2012 -> AND SUBSTR(carnet, 5, 1) = '2' -- Segundo semestre (digito 5 = 2) -> ORDER BY SUBSTR(carnet, 1, 4); -- Ordenados por año de matrícula +--------------+-------------------------------+ | carnet | nombre | +--------------+-------------------------------+ | 200820040075 | WALTON MAYA NATALIA MARIA | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | | 200920009075 | ATEHORTUA LONDOÑO JUAN CAMILO | | 201126012075 | ALVARADO RESTREPO ESTEBAN | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | +--------------+-------------------------------+ 5 rows in set (0.001 sec) MariaDB [Aplicacion_cadena]> SELECT MIN(carnet) -> FROM Discente -> WHERE SUBSTR(carnet, 10, 3) NOT IN ('075', '088'); +--------------+ | MIN(carnet) | +--------------+ | 200820036073 | +--------------+ 1 row in set (0.001 sec) MariaDB [Aplicacion_cadena]> SELECT -> carnet, -> nombre, -> CASE -> WHEN SUBSTR(carnet, 10, 3) = '088' THEN valor_matricula * 0.95 -> ELSE valor_matricula -> END AS valor_a_pagar -> FROM Discente; ERROR 1054 (42S22): Unknown column 'valor_matricula' in 'field list' MariaDB [Aplicacion_cadena]> SELECT -> carnet, -> nombre, -> CASE -> WHEN SUBSTR(carnet, 10, 3) = '088' THEN 500000 * 0.95 -- Valor fijo con descuento -> ELSE 500000 -- Valor fijo sin descuento -> END AS valor_a_pagar -> FROM Discente; +--------------+-------------------------------------+---------------+ | carnet | nombre | valor_a_pagar | +--------------+-------------------------------------+---------------+ | 200820036073 | RIOS QUINCHIA TATIANA | 500000.00 | | 200820040075 | WALTON MAYA NATALIA MARIA | 500000.00 | | 200910005075 | BEDOYA BEDOYA DIEGO ALEXANDER | 500000.00 | | 200910007073 | ZAPATA VALENCIA OLGA LUCIA | 500000.00 | | 200910012075 | ALZATE CARVAJAL RAFAEL ALEXANDER | 500000.00 | | 200910069073 | FUENTES FLOREZ JESSICA VIVIANA | 500000.00 | | 200920001075 | VARGAS ARTEAGA ALEXIS ALBERTO | 500000.00 | | 200920009075 | ATEHORTUA LONDOÑO JUAN CAMILO | 500000.00 | | 200920013073 | SILVA ARIAS NANCY CRISTINA | 500000.00 | | 201010002075 | VANEGAS AGUDELO ETHAN ARLEY | 500000.00 | | 201010005075 | CASTRO HERNANDEZ MARIA CRISTINA | 500000.00 | | 201020003088 | CEBALLOS BETANCUR DANIEL STEVEN | 475000.00 | | 201020006088 | CARDONA CHICA DIEGO FERNANDO | 475000.00 | | 201110005088 | NARANJO DE LOS RIOS MONICA MARIA | 475000.00 | | 201110011075 | ARENAS TAMAYO JOAN SEBASTIAN | 500000.00 | | 201110016075 | GOMEZ GOMEZ JULIO CESAR | 500000.00 | | 201110017088 | GRAJALES MUÑOZ VICTOR CAMILO | 475000.00 | | 201110019088 | CASTRO NAVIA KARINA | 475000.00 | | 201110020075 | MARTINEZ VALENCIA JHON DENNIS | 500000.00 | | 201110022075 | HURTADO TAMAYO CARLOS ESTIBEN | 500000.00 | | 201110034075 | RODRIGUEZ CARDONA YENY ANDREA | 500000.00 | | 201110058073 | BURGOS ECHEVERRY LISBETH | 500000.00 | | 201116027075 | CARMONA TABORDA JOHN ALEXANDER | 500000.00 | | 201116037075 | MANYOMA GARCIA HENSLLY | 500000.00 | | 201120004073 | LOPERA GUTIERREZ ALBA MIREYLLE | 500000.00 | | 201120011088 | ASPRILLA LEUDO YILMAR | 475000.00 | | 201120028073 | OSPINA DAVID DORA ALBA | 500000.00 | | 201120030073 | VELASQUEZ ACEVEDO BIVIANA ELIZABETH | 500000.00 | | 201120036073 | MENA ARTEAGA JUAN NORBERTO | 500000.00 | | 201126012075 | ALVARADO RESTREPO ESTEBAN | 500000.00 | | 201126016075 | MESA ROLDAN JAVIER ALBERTO | 500000.00 | | 201210005088 | HERRERA CARDONA JUAN DANIEL | 475000.00 | | 201210007075 | OCAMPO NARANJO LUIS FELIPE | 500000.00 | | 201210009075 | MOSQUERA PALACIOS NELSON JHAIR | 500000.00 | | 201210009088 | COLLAZO PATIÑO ALEX FERNEY | 475000.00 | | 201210012088 | SALDARRIAGA ARAQUE ANDRES FELIPE | 475000.00 | | 201210022088 | OROZCO CARMONA DIDIER | 475000.00 | | 201210030075 | CAICEDO CABEZAS JOHE ALDREITH | 500000.00 | | 201210043088 | MARTINEZ VALENCIA JHONATAN ARLEY | 475000.00 | | 201212003075 | ZAPATA ZUÑIGA ADRIANA PATRICIA | 500000.00 | | 201212005075 | TORRES TONOCOLIA JENNIFER JULIETH | 500000.00 | | 201213000088 | MONTOYA HENAO MARCELA | 475000.00 | | 201213002088 | ZULUAGA LONDOÑO ANGELA CRISTINA | 475000.00 | | 201214004075 | RADA RODRIGUEZ SILVIO SEGUNDO | 500000.00 | | 201220002075 | LONDOÑO FONNEGRA JHONNY ALEXANDER | 500000.00 | | 201220003075 | BLANDON LONDOÑO CRISTIAN MAURICIO | 500000.00 | | 201220004075 | VALLEJO MAZO PAOLA ANDREA | 500000.00 | | 201220004088 | SALAZAR BUSTAMANTE MERY JOHANNA | 475000.00 | | 201220006075 | ECHAVARRIA RODRIGUEZ SANDRA MARIA | 500000.00 | | 201220016088 | JARAMILLO CARDONA MARLON ALEXANDER | 475000.00 | | 201220022088 | RAMIREZ MESA JULIAN ALBERTO | 475000.00 | | 201222000075 | RAMIREZ MONTOYA ANDRES | 500000.00 | | 201222003075 | RESTREPO GOMEZ RUBEN FERNANDO | 500000.00 | | 201222004075 | VEGA MAZO OMAIRA MARIA | 500000.00 | | 201222005075 | ANDRADE RIVERA JOHAN ALEXIS | 500000.00 | | 201222007073 | AREIZA VERA JOHN FREDY | 500000.00 | | 201222008073 | DOMINGUEZ GOMEZ LIBIA ESTELA | 500000.00 | | 201223000088 | CALLE PUERTA LILIANA MARIA | 475000.00 | | 201223003075 | SERNA ESCOBAR JUAN CARLOS | 500000.00 | | 201224000088 | GRANADA MESA VICTOR ALONSO | 475000.00 | | 201310008075 | GIRALDO VERGARA YOLANDA MILENA | 500000.00 | | 201310016075 | VALDERRAMA MAHECHA DIEGO ALEJANDRO | 500000.00 | | 201310026075 | ANGARITA TORRES IRAMA | 500000.00 | | 201312001088 | VARELA BEDOYA DAISSY ANDREA | 475000.00 | | 201312004075 | MUNERA CARDENAS JOHN JAIRO | 500000.00 | | 201312007075 | CARO BEDOYA WALTER DAVIDSON | 500000.00 | | 201312008075 | JARAMILLO LUIS FERNANDO | 500000.00 | | 201313001075 | CUESTA CUERVO YURY LORENA | 500000.00 | | 201313006075 | TEJADA CASTRO ANDRÉS FELIPE | 500000.00 | | 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO | 500000.00 | | 201320002073 | LEON ESTEVEZ DEISY YOLIMA | 500000.00 | | 201320003070 | TEJADA AGUIRRE ZAIRA CRISTINA | 500000.00 | | 201320003072 | LOPEZ BLANDON LUISA FERNANDA | 500000.00 | | 201320004072 | PATIÑO FLOREZ MARIA ANDREA | 500000.00 | | 201320005073 | HOYOS HENAO JORGE NILTON | 500000.00 | | 201320005086 | GUTÍERREZ SEGURO BEATRIZ | 500000.00 | | 201320006073 | RUIZ RIVERA ISABEL | 500000.00 | | 201320006074 | YEPES HENAO MONICA | 500000.00 | | 201320008059 | RODRIGUEZ VILLA YOHAN SEBASTIAN | 500000.00 | | 201320008060 | LONDOÑO MUÑOZ MARISOL | 500000.00 | | 201320009070 | MAZO MARIN ANA MARIA | 500000.00 | | 201320010075 | CORREA CORREA ANGELICA MARIA | 500000.00 | | 201320011059 | MUÑOZ LOPEZ JONATHATAN FELIPE | 500000.00 | | 201320011073 | LOPEZ JIMENEZ LILLYAM DE JESUS | 500000.00 | | 201320013070 | TIECK MACIAS NICOLAS | 500000.00 | | 201320013074 | MURILLO MURILLO VIDAL CAMILO | 500000.00 | | 201320016070 | GRISALES ISAZA PAOLA ANDREA | 500000.00 | | 201320021075 | PEREZ YEISON FABIAN | 500000.00 | | 201320024070 | BOLAÑO MADERA MAIRA MIRITH | 500000.00 | | 201324002075 | ASPRILLA MENA WALNHER YHAMYD | 500000.00 | | 201324013073 | VELEZ DIANA MARCELA | 500000.00 | +--------------+-------------------------------------+---------------+ 91 rows in set (0.000 sec) MariaDB [Aplicacion_cadena]> SELECT carnet, nombre -> FROM Discente -> WHERE SUBSTR(carnet, 10, 3) = '073' -- Código de Contaduría -> AND SUBSTR(carnet, 5, 1) = '1' -- Primer semestre -> ORDER BY SUBSTR(carnet, 1, 4); -- Ordenados por año de matrícula +--------------+----------------------------------+ | carnet | nombre | +--------------+----------------------------------+ | 200910007073 | ZAPATA VALENCIA OLGA LUCIA | | 200910069073 | FUENTES FLOREZ JESSICA VIVIANA | | 201110058073 | BURGOS ECHEVERRY LISBETH | | 201314005073 | DURANGO RODRIGUEZ JESUS HUMBEIRO | +--------------+----------------------------------+ 4 rows in set (0.001 sec) MariaDB [Aplicacion_cadena]>