MariaDB [(none)]> source C:\Users\alexis\Downloads\cumple.sql Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 1 row affected (0.001 sec) Database changed Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.023 sec) Query OK, 0 rows affected (0.420 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 8 rows affected (0.129 sec) Records: 8 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.090 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) MariaDB [cumple]> show tables; +------------------+ | Tables_in_cumple | +------------------+ | ejercicio | +------------------+ 1 row in set (0.001 sec) MariaDB [cumple]> select current_date(); +----------------+ | current_date() | +----------------+ | 2023-08-25 | +----------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select day(current_date()); +---------------------+ | day(current_date()) | +---------------------+ | 25 | +---------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select date_add(current_date(),interval 12 month); +--------------------------------------------+ | date_add(current_date(),interval 12 month) | +--------------------------------------------+ | 2024-08-25 | +--------------------------------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select date_add(current_date(),interval 10 day); +------------------------------------------+ | date_add(current_date(),interval 10 day) | +------------------------------------------+ | 2023-09-04 | +------------------------------------------+ 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:55:05 PM | +----------------------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select datediff(current_date(),'1970-03-22'); +---------------------------------------+ | datediff(current_date(),'1970-03-22') | +---------------------------------------+ | 19514 | +---------------------------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select datediff(current_date(),'2004-05-28'); +---------------------------------------+ | datediff(current_date(),'2004-05-28') | +---------------------------------------+ | 7028 | +---------------------------------------+ 1 row in set (0.000 sec) MariaDB [cumple]> select datediff(current_date(),'1997-12-10'); +---------------------------------------+ | datediff(current_date(),'1997-12-10') | +---------------------------------------+ | 9389 | +---------------------------------------+ 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 | 63 | | Juan Carlos Serpa | 41 | | Mariana Gonzalez | 41 | | Yoreida Maria | 45 | | Angel Cuadrado | 57 | | Jorge Fuentes | 43 | | Angela Ruiz | 46 | | Carlota Sonora | 38 | +-------------------+-----------------------------------------+ 8 rows in set (0.002 sec) MariaDB [cumple]> select nombre, year(current_date()) - year(nacimiento) 'edad' from ejercicio; +-------------------+------+ | nombre | edad | +-------------------+------+ | Eder Pulgar | 63 | | Juan Carlos Serpa | 41 | | Mariana Gonzalez | 41 | | Yoreida Maria | 45 | | Angel Cuadrado | 57 | | Jorge Fuentes | 43 | | Angela Ruiz | 46 | | Carlota Sonora | 38 | +-------------------+------+ 8 rows in set (0.000 sec) MariaDB [cumple]> select nombre from ejercicio where sexo='mujer' and nombre like '%a'; +----------------+ | nombre | +----------------+ | Yoreida Maria | | Carlota Sonora | +----------------+ 2 rows in set (0.071 sec) MariaDB [cumple]> select count(*) from ejercicio where sexo='mujer' and nombre like '%a'; +----------+ | count(*) | +----------+ | 2 | +----------+ 1 row in set (0.021 sec) MariaDB [cumple]> select count(*) from ejercicio where year(nacimiento) between '1960'and 1969; +----------+ | count(*) | +----------+ | 2 | +----------+ 1 row in set (0.009 sec) MariaDB [cumple]> select sum(hijos) from ejercicio; +------------+ | sum(hijos) | +------------+ | 18 | +------------+ 1 row in set (0.031 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.016 sec) MariaDB [cumple]> select count(*) from ejercicio where year(current_date)-year(nacimiento)<=37 and sexo='mujer'; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.027 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]> insert into ejercicio(codigo,nombre,sexo,nacimiento,hijos) values('8005129','Alberto Lechona','hombre','1970-03-22','1'); Query OK, 1 row affected (0.080 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.001 sec) MariaDB [cumple]> show tables; +------------------+ | Tables_in_cumple | +------------------+ | ejercicio | +------------------+ 1 row in set (0.001 sec) MariaDB [cumple]> create view ejercicioa as select * from ejercicio where nombre like'%a'; Query OK, 0 rows affected (0.376 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 | | 8005129 | Alberto Lechona | hombre | 1970-03-22 | 1 | | 9999957446 | Carlota Sonora | Mujer | 1985-11-03 | 4 | +------------+-------------------+--------+------------+-------+ 4 rows in set (0.012 sec) MariaDB [cumple]> create view ejerciciosexo as select * from ejercicio where sexo= "hombre"; Query OK, 0 rows affected (0.083 sec) MariaDB [cumple]> select ù* from ejerciciosexo; 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 'ù* from ejerciciosexo' at line 1 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]> show tables; +------------------+ | Tables_in_cumple | +------------------+ | ejercicio | | ejercicioa | +------------------+ 2 rows in set (0.001 sec) MariaDB [cumple]> drop view ejercicioa; Query OK, 0 rows affected (0.001 sec) MariaDB [cumple]> show tables; +------------------+ | Tables_in_cumple | +------------------+ | ejercicio | +------------------+ 1 row in set (0.001 sec) MariaDB [cumple]> exit