Microsoft Windows [Versión 10.0.22621.2134]
(c) Microsoft Corporation. Todos los derechos reservados.

C:\Users\Harold Martinez>cd/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 12
Server version: 10.4.24-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 Practica2;
Query OK, 1 row affected (0.003 sec)

MariaDB [(none)]> use Practica2;
Database changed
MariaDB [Practica2]> create table Repaso
    -> Bye
Ctrl-C -- exit!

C:\xampp\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 10.4.24-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)]> use Practica2;
Database changed
MariaDB [Practica2]> create table Repaso
    -> (Codigo varchar(10) not null,
    -> Nombre varchar(30) not null,
    -> Sexo varchar(10) not null,
    -> Fecha_Nacimiento date,
    -> Numero_Hijos int(1)not null);
Query OK, 0 rows affected (0.009 sec)

MariaDB [Practica2]> describe Repaso;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| Codigo           | varchar(10) | NO   |     | NULL    |       |
| Nombre           | varchar(30) | NO   |     | NULL    |       |
| Sexo             | varchar(10) | NO   |     | NULL    |       |
| Fecha_Nacimiento | date        | YES  |     | NULL    |       |
| Numero_Hijos     | int(1)      | NO   |     | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
5 rows in set (0.006 sec)

MariaDB [Practica2]> insert into Repaso(Codigo,Nombre,Sexo,Fecha_Nacimiento,Numero_Hijos) values ("111222","carlos ramirez","hombre","1969-04-04",2),("333666","marina ruiz","mujer","1978-12-15",3),("999111","veronica gonzalez","mujer","1982-03-30",1),("888777","isabel betancur","mujer","1977-11-15",1),("333777","gladys bermudez","mujer","1979-01-01",2),("444666","sandra henao","mujer","1982-11-25",3),("555777","mario gomez","hombre","1982-05-29",2),("111333","andrea gutierrez","mujer","1985-04-12",1),("444777","carlos sepulveda","hombre","1974-01-10",1),("555333","fernando perez","hombre","1980-11-11",4),("666555","juliana arredondo","mujer","1988-12-31",2);
Query OK, 11 rows affected (0.007 sec)
Records: 11  Duplicates: 0  Warnings: 0

MariaDB [Practica2]> select * from Repaso;
+--------+-------------------+--------+------------------+--------------+
| Codigo | Nombre            | Sexo   | Fecha_Nacimiento | Numero_Hijos |
+--------+-------------------+--------+------------------+--------------+
| 111222 | carlos ramirez    | hombre | 1969-04-04       |            2 |
| 333666 | marina ruiz       | mujer  | 1978-12-15       |            3 |
| 999111 | veronica gonzalez | mujer  | 1982-03-30       |            1 |
| 888777 | isabel betancur   | mujer  | 1977-11-15       |            1 |
| 333777 | gladys bermudez   | mujer  | 1979-01-01       |            2 |
| 444666 | sandra henao      | mujer  | 1982-11-25       |            3 |
| 555777 | mario gomez       | hombre | 1982-05-29       |            2 |
| 111333 | andrea gutierrez  | mujer  | 1985-04-12       |            1 |
| 444777 | carlos sepulveda  | hombre | 1974-01-10       |            1 |
| 555333 | fernando perez    | hombre | 1980-11-11       |            4 |
| 666555 | juliana arredondo | mujer  | 1988-12-31       |            2 |
+--------+-------------------+--------+------------------+--------------+
11 rows in set (0.001 sec)

MariaDB [Practica2]> select count(*) "Numero_mujeres" from repaso where Sexo = "mujer" and Nombre like "%z";
+----------------+
| Numero_mujeres |
+----------------+
|              4 |
+----------------+
1 row in set (0.001 sec)

MariaDB [Practica2]> select count(*) "Numero_nacimiento" from repaso where year(Fecha_Nacimiento) between "1970" and "1979";
+-------------------+
| Numero_nacimiento |
+-------------------+
|                 4 |
+-------------------+
1 row in set (0.001 sec)

MariaDB [Practica2]> select Nombre from repaso where year(current_date()) - year(Fecha_Nacimiento) between "25" and "30";
Empty set (0.001 sec)

MariaDB [Practica2]> select sum(Numero_Hijos) "Total hijos" from repaso;
+-------------+
| Total hijos |
+-------------+
|          22 |
+-------------+
1 row in set (0.001 sec)

MariaDB [Practica2]> select Nombre, Numero_Hijos from repaso group by Numero_hijos;
+-------------------+--------------+
| Nombre            | Numero_Hijos |
+-------------------+--------------+
| veronica gonzalez |            1 |
| carlos ramirez    |            2 |
| marina ruiz       |            3 |
| fernando perez    |            4 |
+-------------------+--------------+
4 rows in set (0.001 sec)

MariaDB [Practica2]> select count(*) from repaso where Nombre like "%carlos%";
+----------+
| count(*) |
+----------+
|        2 |
+----------+
1 row in set (0.001 sec)

MariaDB [Practica2]> select count(*) from repaso where Sexo = "mujer" and year(current_date()) - year(Fecha_Nacimiento) <= 22;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.001 sec)

MariaDB [Practica2]> select count(*) from repaso where Sexo = "hombre" and year(current_date()) - year(Fecha_Nacimiento) > 30 and Numero_Hijos > 1;
+----------+
| count(*) |
+----------+
|        3 |
+----------+
1 row in set (0.001 sec)

MariaDB [Practica2]> select count(*) from repaso where Sexo = "mujer" and year(current_date()) - year(Fecha_Nacimiento) > 25 and Numero_hijos between 1 and 3;
+----------+
| count(*) |
+----------+
|        7 |
+----------+
1 row in set (0.001 sec)

MariaDB [Practica2]> exit
Bye

C:\xampp\mysql\bin>mysqldump -B -uroot -p Practica2>c:/xampp/Practica2.sql
Enter password:

C:\xampp\mysql\bin>