MariaDB [cumple]> show tables; +------------------+ | Tables_in_cumple | +------------------+ | ejercicio | +------------------+ 1 row in set (0.001 sec) MariaDB [cumple]> select * from ejercicio; +------------+-------------------+--------+------------+-------+ | codigo | nombre | sexo | nacimiento | hijos | +------------+-------------------+--------+------------+-------+ | 0022559966 | Eder Pulgar | Hombre | 1960-02-20 | 6 | | 0028957446 | Juan Carlos Serpa | Hombre | 1982-11-25 | 2 | | 0822559966 | Mariana Gonzalez | Mujer | 1982-03-24 | 1 | | 1188996633 | Yoreida Maria | Mujer | 1978-03-05 | 2 | | 22663355 | Angel Cuadrado | hombre | 1966-05-13 | 0 | | 4488663322 | Jorge Fuentes | Hombre | 1980-06-22 | 2 | | 556959966 | Angela Ruiz | Mujer | 1977-11-15 | 1 | | 9999957446 | Carlota Sonora | Mujer | 1985-11-03 | 4 | +------------+-------------------+--------+------------+-------+ 8 rows in set (0.001 sec) MariaDB [cumple]> select current_date(); +----------------+ | current_date() | +----------------+ | 2025-03-01 | +----------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select year (current_date()); +-----------------------+ | year (current_date()) | +-----------------------+ | 2025 | +-----------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select month(current_date()); +-----------------------+ | month(current_date()) | +-----------------------+ | 3 | +-----------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select day(current_date()); +---------------------+ | day(current_date()) | +---------------------+ | 1 | +---------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select date_add(current_date(),interval 6 year); +------------------------------------------+ | date_add(current_date(),interval 6 year) | +------------------------------------------+ | 2031-03-01 | +------------------------------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select date_add(current_date(),interval 10 month); +--------------------------------------------+ | date_add(current_date(),interval 10 month) | +--------------------------------------------+ | 2026-01-01 | +--------------------------------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select date_add(current_date(),interval 10 day); +------------------------------------------+ | date_add(current_date(),interval 10 day) | +------------------------------------------+ | 2025-03-11 | +------------------------------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select date_format(now(),'%h:%i:%s %p'); +----------------------------------+ | date_format(now(),'%h:%i:%s %p') | +----------------------------------+ | 04:49:55 PM | +----------------------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select datediff(current_date(),'2006-03-26'); +---------------------------------------+ | datediff(current_date(),'2006-03-26') | +---------------------------------------+ | 6915 | +---------------------------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select nombre, year(current_date()) - year(nacimiento) from ejercicio; +-------------------+-----------------------------------------+ | nombre | year(current_date()) - year(nacimiento) | +-------------------+-----------------------------------------+ | Eder Pulgar | 65 | | Juan Carlos Serpa | 43 | | Mariana Gonzalez | 43 | | Yoreida Maria | 47 | | Angel Cuadrado | 59 | | Jorge Fuentes | 45 | | Angela Ruiz | 48 | | Carlota Sonora | 40 | +-------------------+-----------------------------------------+ 8 rows in set (0.001 sec) MariaDB [cumple]> select nombre, year(current_date()) - year(nacimiento)'edad' from ejercicio; +-------------------+------+ | nombre | edad | +-------------------+------+ | Eder Pulgar | 65 | | Juan Carlos Serpa | 43 | | Mariana Gonzalez | 43 | | Yoreida Maria | 47 | | Angel Cuadrado | 59 | | Jorge Fuentes | 45 | | Angela Ruiz | 48 | | Carlota Sonora | 40 | +-------------------+------+ 8 rows in set (0.001 sec) MariaDB [cumple]> select nombre from ejercicio where sexo='mujer' and nombre like '%a'; +----------------+ | nombre | +----------------+ | Yoreida Maria | | Carlota Sonora | +----------------+ 2 rows in set (0.001 sec) MariaDB [cumple]> select nombre,sexo from ejercicio where sexo='mujer' and nombre like '%a'; +----------------+-------+ | nombre | sexo | +----------------+-------+ | Yoreida Maria | Mujer | | Carlota Sonora | Mujer | +----------------+-------+ 2 rows in set (0.000 sec) MariaDB [cumple]> select count(*) from ejercicio where year(nacimiento) between '1960'and 1969; +----------+ | count(*) | +----------+ | 2 | +----------+ 1 row in set (0.001 sec) MariaDB [cumple]> select * from ejercicio where year(nacimiento) between '1960'and 1969; +------------+----------------+--------+------------+-------+ | codigo | nombre | sexo | nacimiento | hijos | +------------+----------------+--------+------------+-------+ | 0022559966 | Eder Pulgar | Hombre | 1960-02-20 | 6 | | 22663355 | Angel Cuadrado | hombre | 1966-05-13 | 0 | +------------+----------------+--------+------------+-------+ 2 rows in set (0.000 sec) MariaDB [cumple]> select * from ejercicio where year(current_date()) - year(nacimiento) between '43' and '4+7'; Empty set, 8 warnings (0.000 sec) MariaDB [cumple]> select * from ejercicio where year(current_date()) - year(nacimiento) between '43' and '4+7'; Empty set, 8 warnings (0.000 sec) MariaDB [cumple]> select * from ejercicio where year(current_date()) - year(nacimiento) between '43' and '47'; +------------+-------------------+--------+------------+-------+ | codigo | nombre | sexo | nacimiento | hijos | +------------+-------------------+--------+------------+-------+ | 0028957446 | Juan Carlos Serpa | Hombre | 1982-11-25 | 2 | | 0822559966 | Mariana Gonzalez | Mujer | 1982-03-24 | 1 | | 1188996633 | Yoreida Maria | Mujer | 1978-03-05 | 2 | | 4488663322 | Jorge Fuentes | Hombre | 1980-06-22 | 2 | +------------+-------------------+--------+------------+-------+ 4 rows in set (0.000 sec) MariaDB [cumple]> select hijos,count(*) from ejercicio group by hijos; +-------+----------+ | hijos | count(*) | +-------+----------+ | 0 | 1 | | 1 | 2 | | 2 | 3 | | 4 | 1 | | 6 | 1 | +-------+----------+ 5 rows in set (0.001 sec) MariaDB [cumple]> select hijos,count(*)'#hijos' from ejercicio group by hijos; +-------+--------+ | hijos | #hijos | +-------+--------+ | 0 | 1 | | 1 | 2 | | 2 | 3 | | 4 | 1 | | 6 | 1 | +-------+--------+ 5 rows in set (0.000 sec) MariaDB [cumple]> select count(*) from ejercicio where year(current_date)-year(nacimiento)<=47 and sexo='mujer'; +----------+ | count(*) | +----------+ | 3 | +----------+ 1 row in set (0.001 sec) MariaDB [cumple]> select * from ejercicio where year(current_date)-year(nacimiento)<=47 and sexo='mujer'; +------------+------------------+-------+------------+-------+ | codigo | nombre | sexo | nacimiento | hijos | +------------+------------------+-------+------------+-------+ | 0822559966 | Mariana Gonzalez | Mujer | 1982-03-24 | 1 | | 1188996633 | Yoreida Maria | Mujer | 1978-03-05 | 2 | | 9999957446 | Carlota Sonora | Mujer | 1985-11-03 | 4 | +------------+------------------+-------+------------+-------+ 3 rows in set (0.001 sec) MariaDB [cumple]> create view ejercicioa as select * from ejercicio where nombre like'%a'; Query OK, 0 rows affected (0.006 sec) MariaDB [cumple]> show tables; +------------------+ | Tables_in_cumple | +------------------+ | ejercicio | | ejercicioa | +------------------+ 2 rows in set (0.001 sec) MariaDB [cumple]> select * from ejercicioa; +------------+-------------------+--------+------------+-------+ | codigo | nombre | sexo | nacimiento | hijos | +------------+-------------------+--------+------------+-------+ | 0028957446 | Juan Carlos Serpa | Hombre | 1982-11-25 | 2 | | 1188996633 | Yoreida Maria | Mujer | 1978-03-05 | 2 | | 9999957446 | Carlota Sonora | Mujer | 1985-11-03 | 4 | +------------+-------------------+--------+------------+-------+ 3 rows in set (0.001 sec) MariaDB [cumple]> describe ejercicio; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | codigo | char(10) | NO | PRI | NULL | | | nombre | char(30) | YES | | NULL | | | sexo | char(10) | YES | | NULL | | | nacimiento | date | YES | | NULL | | | hijos | char(2) | YES | | NULL | | +------------+----------+------+-----+---------+-------+ 5 rows in set (0.014 sec) MariaDB [cumple]> create view ejerciciosexo as select * from ejercicio where sexo= "hombre"; Query OK, 0 rows affected (0.003 sec) MariaDB [cumple]> insert into ejercicio(codigo,nombre,sexo,nacimiento,hijos) values('8005129','Alberto Lechona','hombre','1970-03-22','1'); Query OK, 1 row affected (0.003 sec) MariaDB [cumple]> select * from ejercicio; +------------+-------------------+--------+------------+-------+ | codigo | nombre | sexo | nacimiento | hijos | +------------+-------------------+--------+------------+-------+ | 0022559966 | Eder Pulgar | Hombre | 1960-02-20 | 6 | | 0028957446 | Juan Carlos Serpa | Hombre | 1982-11-25 | 2 | | 0822559966 | Mariana Gonzalez | Mujer | 1982-03-24 | 1 | | 1188996633 | Yoreida Maria | Mujer | 1978-03-05 | 2 | | 22663355 | Angel Cuadrado | hombre | 1966-05-13 | 0 | | 4488663322 | Jorge Fuentes | Hombre | 1980-06-22 | 2 | | 556959966 | Angela Ruiz | Mujer | 1977-11-15 | 1 | | 8005129 | Alberto Lechona | hombre | 1970-03-22 | 1 | | 9999957446 | Carlota Sonora | Mujer | 1985-11-03 | 4 | +------------+-------------------+--------+------------+-------+ 9 rows in set (0.000 sec) MariaDB [cumple]> select * from ejerciciosexo; +------------+-------------------+--------+------------+-------+ | codigo | nombre | sexo | nacimiento | hijos | +------------+-------------------+--------+------------+-------+ | 0022559966 | Eder Pulgar | Hombre | 1960-02-20 | 6 | | 0028957446 | Juan Carlos Serpa | Hombre | 1982-11-25 | 2 | | 22663355 | Angel Cuadrado | hombre | 1966-05-13 | 0 | | 4488663322 | Jorge Fuentes | Hombre | 1980-06-22 | 2 | | 8005129 | Alberto Lechona | hombre | 1970-03-22 | 1 | +------------+-------------------+--------+------------+-------+ 5 rows in set (0.001 sec) MariaDB [cumple]> drop view ejerciciosexo; Query OK, 0 rows affected (0.001 sec) MariaDB [cumple]> MariaDB [cumple]> exit