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

C:\Windows\system32>MYSQL -U ROOT -P
"MYSQL" no se reconoce como un comando interno o externo,
programa o archivo por lotes ejecutable.

C:\Windows\system32>
C:\Windows\system32>cd
C:\Windows\system32

C:\Windows\system32>cd c:/xampp/mysql/bin

c:\xampp\mysql\bin>mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.4.28-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 practicaf
    -> ;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> practicaf;
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 'practicaf' at line 1
MariaDB [(none)]> use practicaf;
Database changed
MariaDB [practicaf]> CREATE TABLE estudiante (
    ->     carnet VARCHAR(10) PRIMARY KEY,
    ->     nombre VARCHAR(100),
    ->     fechamatricula DATE,
    ->     fechanacimiento DATE,
    ->     sexo CHAR(1)
    -> );
Query OK, 0 rows affected (0.011 sec)

MariaDB [practicaf]> CREATE TABLE materia (
    ->     codigom VARCHAR(10) PRIMARY KEY,
    ->     descripcion VARCHAR(100),
    ->     valor DECIMAL(10, 2)
    -> );
Query OK, 0 rows affected (0.016 sec)

MariaDB [practicaf]> CREATE TABLE estmat (
    ->     carnet VARCHAR(10),
    ->     codigom VARCHAR(10),
    ->     FOREIGN KEY (carnet) REFERENCES estudiante(carnet),
    ->     FOREIGN KEY (codigom) REFERENCES materia(codigom)
    -> );
Query OK, 0 rows affected (0.029 sec)

MariaDB [practicaf]> INSERT INTO estudiante (carnet, nombre, fechamatricula, fechanacimiento, sexo) VALUES
    -> ('001', 'maria', '2010-01-15', '1966-05-13', 'f'),
    -> ('002', 'juana', '2010-06-08', '1973-01-22', 'f'),
    -> ('003', 'carlos', '2010-06-28', '1976-03-05', 'm'),
    -> ('004', 'Maria Parra', '2010-06-11', '1976-08-15', 'f'),
    -> ('005', 'Pablo Neruda', '2011-02-13', '1990-08-25', 'm'),
    -> ('006', 'Bladimir Palacio', '2011-02-04', '1994-09-03', 'm'),
    -> ('007', 'Apolonia Serrano', '2011-02-28', '1994-03-09', 'f'),
    -> ('008', 'Federico Serrano', '2011-03-05', '1991-06-10', 'm');
Query OK, 8 rows affected (0.053 sec)
Records: 8  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> INSERT INTO materia (codigom, descripcion, valor) VALUES
    -> ('001', 'software I', 320000),
    -> ('002', 'software II', 328000),
    -> ('003', 'software III', 400000),
    -> ('004', 'matematicas', 300000),
    -> ('005', 'ingles', 300000);
Query OK, 5 rows affected (0.005 sec)
Records: 5  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> INSERT INTO estmat (carnet, codigom) VALUES
    -> ('001', '003'),
    -> ('001', '005'),
    -> ('002', '002'),
    -> ('002', '003'),
    -> ('002', '004'),
    -> ('003', '004'),
    -> ('003', '001'),
    -> ('004', '004'),
    -> ('004', '005'),
    -> ('005', '002'),
    -> ('005', '005'),
    -> ('006', '001'),
    -> ('006', '005'),
    -> ('007', '003'),
    -> ('007', '004'),
    -> ('008', '001'),
    -> ('008', '004'),
    -> ('008', '005');
Query OK, 18 rows affected (0.010 sec)
Records: 18  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> mysql -u usuario -p < mis_sentencias.sql > salida.txt
    -> ;
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 'mysql -u usuario -p < mis_sentencias.sql > salida.txt' at line 1
MariaDB [practicaf]> select * from estudiante;
+--------+------------------+----------------+-----------------+------+
| carnet | nombre           | fechamatricula | fechanacimiento | sexo |
+--------+------------------+----------------+-----------------+------+
| 001    | maria            | 2010-01-15     | 1966-05-13      | f    |
| 002    | juana            | 2010-06-08     | 1973-01-22      | f    |
| 003    | carlos           | 2010-06-28     | 1976-03-05      | m    |
| 004    | Maria Parra      | 2010-06-11     | 1976-08-15      | f    |
| 005    | Pablo Neruda     | 2011-02-13     | 1990-08-25      | m    |
| 006    | Bladimir Palacio | 2011-02-04     | 1994-09-03      | m    |
| 007    | Apolonia Serrano | 2011-02-28     | 1994-03-09      | f    |
| 008    | Federico Serrano | 2011-03-05     | 1991-06-10      | m    |
+--------+------------------+----------------+-----------------+------+
8 rows in set (0.000 sec)

MariaDB [practicaf]> select * from materia;
+---------+--------------+-----------+
| codigom | descripcion  | valor     |
+---------+--------------+-----------+
| 001     | software I   | 320000.00 |
| 002     | software II  | 328000.00 |
| 003     | software III | 400000.00 |
| 004     | matematicas  | 300000.00 |
| 005     | ingles       | 300000.00 |
+---------+--------------+-----------+
5 rows in set (0.000 sec)

MariaDB [practicaf]> select * from estmat;
+--------+---------+
| carnet | codigom |
+--------+---------+
| 001    | 003     |
| 001    | 005     |
| 002    | 002     |
| 002    | 003     |
| 002    | 004     |
| 003    | 004     |
| 003    | 001     |
| 004    | 004     |
| 004    | 005     |
| 005    | 002     |
| 005    | 005     |
| 006    | 001     |
| 006    | 005     |
| 007    | 003     |
| 007    | 004     |
| 008    | 001     |
| 008    | 004     |
| 008    | 005     |
+--------+---------+
18 rows in set (0.000 sec)

MariaDB [practicaf]> SELECT COUNT(*) AS total_estudiantes_70
    -> FROM estudiante
    -> WHERE YEAR(fechanacimiento) BETWEEN 1970 AND 1979;
+----------------------+
| total_estudiantes_70 |
+----------------------+
|                    3 |
+----------------------+
1 row in set (0.000 sec)

MariaDB [practicaf]> SELECT *
    -> FROM estudiante
    -> WHERE TIMESTAMPDIFF(YEAR, fechanacimiento, CURDATE()) BETWEEN 16 AND 20;
Empty set (0.001 sec)

MariaDB [practicaf]> SELECT nombre
    -> FROM estudiante
    -> WHERE TIMESTAMPDIFF(YEAR, fechanacimiento, CURDATE()) > 25;
+------------------+
| nombre           |
+------------------+
| maria            |
| juana            |
| carlos           |
| Maria Parra      |
| Pablo Neruda     |
| Bladimir Palacio |
| Apolonia Serrano |
| Federico Serrano |
+------------------+
8 rows in set (0.000 sec)

MariaDB [practicaf]> SELECT nombre, fechanacimiento, TIMESTAMPDIFF(YEAR, fechanacimiento, CURDATE()) AS edad
    -> FROM estudiante;
+------------------+-----------------+------+
| nombre           | fechanacimiento | edad |
+------------------+-----------------+------+
| maria            | 1966-05-13      |   57 |
| juana            | 1973-01-22      |   51 |
| carlos           | 1976-03-05      |   47 |
| Maria Parra      | 1976-08-15      |   47 |
| Pablo Neruda     | 1990-08-25      |   33 |
| Bladimir Palacio | 1994-09-03      |   29 |
| Apolonia Serrano | 1994-03-09      |   29 |
| Federico Serrano | 1991-06-10      |   32 |
+------------------+-----------------+------+
8 rows in set (0.000 sec)

MariaDB [practicaf]> CREATE TABLE Repaso2 (
    ->     codigo VARCHAR(10) PRIMARY KEY,
    ->     nombre VARCHAR(100),
    ->     sexo VARCHAR(10),
    ->     fechanacimiento DATE,
    ->     nrohijos INT
    -> );
Query OK, 0 rows affected (0.015 sec)

MariaDB [practicaf]> INSERT INTO Repaso2 (codigo, nombre, sexo, fechanacimiento, nrohijos) 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.005 sec)
Records: 11  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> SELECT COUNT(*) AS mujeres_con_z
    -> FROM Repaso2
    -> WHERE sexo = 'mujer' AND nombre LIKE '%z';
+---------------+
| mujeres_con_z |
+---------------+
|             4 |
+---------------+
1 row in set (0.001 sec)

MariaDB [practicaf]> SELECT COUNT(*) AS total_personas_70s
    -> FROM Repaso2
    -> WHERE YEAR(fechanacimiento) BETWEEN 1970 AND 1979;
+--------------------+
| total_personas_70s |
+--------------------+
|                  4 |
+--------------------+
1 row in set (0.000 sec)

MariaDB [practicaf]> SELECT *
    -> FROM Repaso2
    -> WHERE TIMESTAMPDIFF(YEAR, fechanacimiento, CURDATE()) BETWEEN 25 AND 30;
Empty set (0.000 sec)

MariaDB [practicaf]> SELECT nrohijos, COUNT(*) AS cantidad
    -> FROM Repaso2
    -> GROUP BY nrohijos;
+----------+----------+
| nrohijos | cantidad |
+----------+----------+
|        1 |        4 |
|        2 |        4 |
|        3 |        2 |
|        4 |        1 |
+----------+----------+
4 rows in set (0.000 sec)

MariaDB [practicaf]> SELECT COUNT(*) AS personas_carlos
    -> FROM Repaso2
    -> WHERE nombre LIKE '%carlos%';
+-----------------+
| personas_carlos |
+-----------------+
|               2 |
+-----------------+
1 row in set (0.000 sec)

MariaDB [practicaf]> SELECT COUNT(*) AS total_mujeres_menor_22
    -> FROM Repaso2
    -> WHERE sexo = 'mujer' AND TIMESTAMPDIFF(YEAR, fechanacimiento, CURDATE()) <= 22;
+------------------------+
| total_mujeres_menor_22 |
+------------------------+
|                      0 |
+------------------------+
1 row in set (0.000 sec)

MariaDB [practicaf]> SELECT COUNT(*) AS hombres_mayor_30_con_mas_de_1_hijo
    -> FROM Repaso2
    -> WHERE sexo = 'hombre' AND TIMESTAMPDIFF(YEAR, fechanacimiento, CURDATE()) > 30 AND nrohijos > 1;
+------------------------------------+
| hombres_mayor_30_con_mas_de_1_hijo |
+------------------------------------+
|                                  3 |
+------------------------------------+
1 row in set (0.000 sec)

MariaDB [practicaf]> SELECT COUNT(*) AS hombres_mayor_30_con_mas_de_1_hijo
    -> FROM Repaso2
    -> WHERE sexo = 'hombre' AND TIMESTAMPDIFF(YEAR, fechanacimiento, CURDATE()) > 30 AND nrohijos > 1;
+------------------------------------+
| hombres_mayor_30_con_mas_de_1_hijo |
+------------------------------------+
|                                  3 |
+------------------------------------+
1 row in set (0.000 sec)

MariaDB [practicaf]> SELECT COUNT(*) AS mujeres_mayor_25_con_1_a_3_hijos
    -> FROM Repaso2
    -> WHERE sexo = 'mujer' AND TIMESTAMPDIFF(YEAR, fechanacimiento, CURDATE()) > 25 AND nrohijos BETWEEN 1 AND 3;
+----------------------------------+
| mujeres_mayor_25_con_1_a_3_hijos |
+----------------------------------+
|                                7 |
+----------------------------------+
1 row in set (0.000 sec)

MariaDB [practicaf]> SELECT nombre, fechanacimiento, TIMESTAMPDIFF(YEAR, fechanacimiento, CURDATE()) AS edad_aproximada
    -> FROM Repaso2;
+-------------------+-----------------+-----------------+
| nombre            | fechanacimiento | edad_aproximada |
+-------------------+-----------------+-----------------+
| carlos ramirez    | 1969-04-04      |              54 |
| andrea gutierrez  | 1985-04-12      |              38 |
| marina ruiz       | 1978-12-15      |              45 |
| gladys bermudez   | 1979-01-01      |              45 |
| sandra henao      | 1982-11-25      |              41 |
| carlos sepulveda  | 1974-01-10      |              50 |
| fernando perez    | 1980-11-11      |              43 |
| mario gomez       | 1982-05-29      |              41 |
| juliana arredondo | 1988-12-31      |              35 |
| isabel betancur   | 1977-11-15      |              46 |
| veronica gonzalez | 1982-03-30      |              41 |
+-------------------+-----------------+-----------------+
11 rows in set (0.000 sec)