MariaDB [(none)]> create database praticaf;
Query OK, 1 row affected (0.008 sec)

MariaDB [(none)]> drop database praticaf;
Query OK, 0 rows affected (0.032 sec)

MariaDB [(none)]> create database practicaf;
Query OK, 1 row affected (0.006 sec)

MariaDB [(none)]> use practicaf;
Database changed
MariaDB [practicaf]> create table estudiante
    -> (Carnet varchar(10) not null primary key,
    -> Nombre varchar(50) not null,
    -> Fechamatricula date,
    -> Fechanacimiento date,
    -> Sexo varchar(10) not null);
Query OK, 0 rows affected (0.892 sec)

MariaDB [practicaf]> describe estudiante;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| Carnet          | varchar(10) | NO   | PRI | NULL    |       |
| Nombre          | varchar(50) | NO   |     | NULL    |       |
| Fechamatricula  | date        | YES  |     | NULL    |       |
| Fechanacimiento | date        | YES  |     | NULL    |       |
| Sexo            | varchar(10) | NO   |     | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
5 rows in set (0.150 sec)

MariaDB [practicaf]> create table materia
    -> (Codigom varchar(10) not null primary key,
    -> Descripcion varchar(50) not null,
    -> Precio float not null);
Query OK, 0 rows affected (0.130 sec)

MariaDB [practicaf]> describe materia;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| Codigom     | varchar(10) | NO   | PRI | NULL    |       |
| Descripcion | varchar(50) | NO   |     | NULL    |       |
| Precio      | float       | NO   |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
3 rows in set (0.169 sec)

MariaDB [practicaf]> create table estmat
    -> (Carnet varchar(10) not null,
    -> Codigom varchar(10) not null,
    -> foreign key(carnet) references estudiante(carnet) on delete cascade on update cascade,
    -> foreign key(codigom) references materia(codigom) on delete cascade on update cascade);
Query OK, 0 rows affected (0.943 sec)

MariaDB [practicaf]> describe estmat;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| Carnet  | varchar(10) | NO   | MUL | NULL    |       |
| Codigom | varchar(10) | NO   | MUL | NULL    |       |
+---------+-------------+------+-----+---------+-------+
2 rows in set (0.135 sec)

MariaDB [practicaf]> insert into estudiante(Carnet,Nombre,Fechamatricula,Fechanacimiento,Sexo) values('001','Maria','2010-01-15','1966-05-13','F');
Query OK, 1 row affected (0.051 sec)

MariaDB [practicaf]> select *from estudiante;
+--------+--------+----------------+-----------------+------+
| Carnet | Nombre | Fechamatricula | Fechanacimiento | Sexo |
+--------+--------+----------------+-----------------+------+
| 001    | Maria  | 2010-01-15     | 1966-05-13      | F    |
+--------+--------+----------------+-----------------+------+
1 row in set (0.006 sec)

MariaDB [practicaf]> insert into estudiante(Carnet,Nombre,Fechamatricula,Fechanacimiento,Sexo) values('002','Juana','2010-06-08','1973-01-22','F');
Query OK, 1 row affected (0.015 sec)

MariaDB [practicaf]> insert into estudiante(Carnet,Nombre,Fechamatricula,Fechanacimiento,Sexo) values('003','Carlos','2010-06-28','1976-03-05','M'), ('004','Maria Parra','2010-06-11','1976-08-15','F');
Query OK, 2 rows affected (0.007 sec)
Records: 2  Duplicates: 0  Warnings: 0

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    |
+--------+-------------+----------------+-----------------+------+
4 rows in set (0.001 sec)

MariaDB [practicaf]> insert into estudiante(Carnet,Nombre,Fechamatricula,Fechanacimiento,Sexo) values('005','Pablo Neruda','2011-02-13','1990-08-25','M'), ('006','Bladimir Palacio','2011-02-04','1994-09-03','M');
Query OK, 2 rows affected (0.004 sec)
Records: 2  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> insert into estudiante(Carnet,Nombre,Fechamatricula,Fechanacimiento,Sexo) values('007','Apolonia Serrano','2011-02-28','1994-03-09','F'), ('008','Federico Serrano','2011-03-05','1991-06-10','M');
Query OK, 2 rows affected (0.004 sec)
Records: 2  Duplicates: 0  Warnings: 0

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.001 sec)

MariaDB [practicaf]> describe materia;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| Codigom     | varchar(10) | NO   | PRI | NULL    |       |
| Descripcion | varchar(50) | NO   |     | NULL    |       |
| Precio      | float       | NO   |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
3 rows in set (0.136 sec)

MariaDB [practicaf]> alter table materia change Precio Valor float not null;
Query OK, 0 rows affected (0.930 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> describe materia;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| Codigom     | varchar(10) | NO   | PRI | NULL    |       |
| Descripcion | varchar(50) | NO   |     | NULL    |       |
| Valor       | float       | NO   |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
3 rows in set (0.108 sec)

MariaDB [practicaf]> insert into materia(Codigom,Descripcion,Valor) values('001','Software I',320000);
Query OK, 1 row affected (0.005 sec)

MariaDB [practicaf]> insert into materia(Codigom,Descripcion,Valor) values('0012','Software II',328000);
Query OK, 1 row affected (0.014 sec)

MariaDB [practicaf]> insert into materia(Codigom,Descripcion,Valor) values('002','Software II',328000);
Query OK, 1 row affected (0.004 sec)

MariaDB [practicaf]> delete from materia where codigom='0012';
Query OK, 1 row affected (0.047 sec)

MariaDB [practicaf]> insert into materia(Codigom,Descripcion,Valor) values('003','Software III',400000);
Query OK, 1 row affected (0.004 sec)

MariaDB [practicaf]> insert into materia(Codigom,Descripcion,Valor) values('004','Matematicas',300000);
Query OK, 1 row affected (0.029 sec)

MariaDB [practicaf]> insert into materia(Codigom,Descripcion,Valor) values('005','Ingles',300000);
Query OK, 1 row affected (0.032 sec)

MariaDB [practicaf]> select *from materia;
+---------+--------------+--------+
| Codigom | Descripcion  | Valor  |
+---------+--------------+--------+
| 001     | Software I   | 320000 |
| 002     | Software II  | 328000 |
| 003     | Software III | 400000 |
| 004     | Matematicas  | 300000 |
| 005     | Ingles       | 300000 |
+---------+--------------+--------+
5 rows in set (0.002 sec)

MariaDB [practicaf]> insert into estmat(Carnet,Codigom) values('001','003'), ('001','005');
Query OK, 2 rows affected (0.003 sec)
Records: 2  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> insert into estmat(Carnet,Codigom) values('002','002'), ('002','003'),('002','004'),('003','004');
Query OK, 4 rows affected (0.006 sec)
Records: 4  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> insert into estmat(Carnet,Codigom) values('003','001'), ('004','004'),('004','005'),('005','002'),('005','005'),('006','001'),('006','005');
Query OK, 7 rows affected (0.014 sec)
Records: 7  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> insert into estmat(Carnet,Codigom) values('007','003'), ('007','004'),('008','001'),('008','004'),('008','005');
Query OK, 5 rows affected (0.004 sec)
Records: 5  Duplicates: 0  Warnings: 0

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.001 sec)

MariaDB [practicaf]> select sum(fechanacimiento) from estudiante where year(fechanacimiento) >=1970;
+----------------------+
| sum(fechanacimiento) |
+----------------------+
|            138943889 |
+----------------------+
1 row in set (0.045 sec)

MariaDB [practicaf]> select sum(*) from estudiante where year(fechanacimiento) >=1970;
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 estudiante where year(fechanacimiento) >=1970' at line 1
MariaDB [practicaf]> select sum(carnet) from estudiante where year(fechanacimiento) >=1970;
+-------------+
| sum(carnet) |
+-------------+
|          35 |
+-------------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from estudiante where year(fechanacimiento) >=1970;
+----------+
| count(*) |
+----------+
|        7 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select *from estudiante where year(current_date())-year(fechanacimiento) between '16' and '20';
Empty set (0.009 sec)

MariaDB [practicaf]> select *from estudiante where year(current_date())-year(fechanacimiento) between '30' and '50';
+--------+------------------+----------------+-----------------+------+
| Carnet | Nombre           | Fechamatricula | Fechanacimiento | Sexo |
+--------+------------------+----------------+-----------------+------+
| 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    |
| 008    | Federico Serrano | 2011-03-05     | 1991-06-10      | M    |
+--------+------------------+----------------+-----------------+------+
5 rows in set (0.001 sec)

MariaDB [practicaf]> select *from estudiante where year(current_date())-year(fechanacimiento) between '25' and '50';
+--------+------------------+----------------+-----------------+------+
| Carnet | Nombre           | Fechamatricula | Fechanacimiento | Sexo |
+--------+------------------+----------------+-----------------+------+
| 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    |
+--------+------------------+----------------+-----------------+------+
7 rows in set (0.001 sec)

MariaDB [practicaf]> select nombre,count(*) from estudiante where year(current_date)-year(fechanacimiento) >=25;
+--------+----------+
| nombre | count(*) |
+--------+----------+
| Maria  |        8 |
+--------+----------+
1 row in set (0.002 sec)

MariaDB [practicaf]> select nombre from estudiante where year(current_date)-year(fechanacimiento) >=25;
+------------------+
| nombre           |
+------------------+
| Maria            |
| Juana            |
| Carlos           |
| Maria Parra      |
| Pablo Neruda     |
| Bladimir Palacio |
| Apolonia Serrano |
| Federico Serrano |
+------------------+
8 rows in set (0.001 sec)

MariaDB [practicaf]> select nombre,year(current_date())-year(fechanacimiento) 'A¤os' from estudiante;
+------------------+------+
| nombre           | A¤os |
+------------------+------+
| Maria            |   55 |
| Juana            |   48 |
| Carlos           |   45 |
| Maria Parra      |   45 |
| Pablo Neruda     |   31 |
| Bladimir Palacio |   27 |
| Apolonia Serrano |   27 |
| Federico Serrano |   30 |
+------------------+------+
8 rows in set (0.001 sec)

MariaDB [practicaf]> select count(*) from estudiante where year(fechanacimiento) >=1970;
+----------+
| count(*) |
+----------+
|        7 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from estudiante where year(fechanacimiento) between '1970' and '1980';
+----------+
| count(*) |
+----------+
|        3 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> mysqldump -B -uroot -p practicaf>c:/xampp/practicaf.sql
    -> 
    -> 
    -> ;
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 'mysqldump -B -uroot -p practicaf>c:/xampp/practicaf.sql' at line 1
MariaDB [practicaf]> mysqldump -B -uroot -p practicaf>c:/xampp/practicaf.sql
    -> 
    -> 
    -> mysqldump -B -uroot -p  --routines practicaf>c:/xampp/practicaf.sql
    -> 
    -> ;
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 'mysqldump -B -uroot -p practicaf>c:/xampp/practicaf.sql


mysqldump -B -uroot...' at line 1
MariaDB [practicaf]> mysqldump -B -uroot -p practicaf>c:/xampp/practicaf.sql
    -> 
    -> 
    -> 
    -> 
    -> 
    -> mysqldump -B -uroot -p practica>c:/xampp/practica.sql
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> exit
    -> ;
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 'mysqldump -B -uroot -p practicaf>c:/xampp/practicaf.sql





mysqldump -B -ur...' at line 1
MariaDB [practicaf]> exit
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| biblioteca         |
| clinica            |
| colegio            |
| escuela            |
| fechas             |
| information_schema |
| libreria           |
| matricula          |
| matricula2         |
| mysql              |
| otros              |
| performance_schema |
| phpmyadmin         |
| practicaf          |
| subconsultas       |
| taller2            |
| test               |
| trespastore        |
| turismo            |
+--------------------+
19 rows in set (0.360 sec)

MariaDB [(none)]> create table repaso
    -> (Codigo varchar(15) not null primary key,
    -> Nombre varchar(50) not null,
    -> Sexo varchar(15) not null,
    -> Fechanacimiento date not null,
    -> Nrohijos int(3) not null);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> use practicaf;
Database changed
MariaDB [practicaf]>  create table repaso
    ->     (Codigo varchar(15) not null primary key,
    ->     Nombre varchar(50) not null,
    ->     Sexo varchar(15) not null,
    ->     Fechanacimiento date not null,
    ->     Nrohijos int(3) not null);
Query OK, 0 rows affected (0.286 sec)

MariaDB [practicaf]> insert into repaso(Codigo,Nombre,Sexo,Fechanacimiento,Nrohijos) values('111222','Carlos Ramirez','Hombre','1969-04-04',2);
Query OK, 1 row affected (0.377 sec)

MariaDB [practicaf]> insert into repaso(Codigo,Nombre,Sexo,Fechanacimiento,Nrohijos) values('333666','Marina Ruiz','Mujer','1978-12-15',3), ('999111','Veronica Gonzalez','Mujer','1982-03-30',1);
Query OK, 2 rows affected (0.006 sec)
Records: 2  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> insert into repaso(Codigo,Nombre,Sexo,Fechanacimiento,Nrohijos) values('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);
Query OK, 4 rows affected (0.004 sec)
Records: 4  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> insert into repaso(Codigo,Nombre,Sexo,Fechanacimiento,Nrohijos) values('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, 4 rows affected (0.033 sec)
Records: 4  Duplicates: 0  Warnings: 0

MariaDB [practicaf]> select *from repaso;
+--------+-------------------+--------+-----------------+----------+
| Codigo | Nombre            | Sexo   | Fechanacimiento | Nrohijos |
+--------+-------------------+--------+-----------------+----------+
| 111222 | Carlos Ramirez    | Hombre | 1969-04-04      |        2 |
| 111333 | Andrea Gutierrez  | Mujer  | 1985-04-12      |        1 |
| 333666 | Marina Ruiz       | Mujer  | 1978-12-15      |        3 |
| 333777 | Gladys Bermudez   | Mujer  | 1979-01-01      |        2 |
| 444666 | Sandra Henao      | Mujer  | 1982-11-25      |        3 |
| 444777 | Carlos Sepulveda  | Hombre | 1974-01-10      |        1 |
| 555333 | Fernando Perez    | Hombre | 1980-11-11      |        4 |
| 555777 | Mario Gomez       | Hombre | 1982-05-29      |        2 |
| 666555 | Juliana Arredondo | Mujer  | 1988-12-31      |        2 |
| 888777 | Isabel Betancur   | Mujer  | 1977-11-15      |        1 |
| 999111 | Veronica Gonzalez | Mujer  | 1982-03-30      |        1 |
+--------+-------------------+--------+-----------------+----------+
11 rows in set (0.013 sec)

MariaDB [practicaf]> select count(*) from repaso where sexo='mujer' and nombre like '%z';
+----------+
| count(*) |
+----------+
|        4 |
+----------+
1 row in set (0.036 sec)

MariaDB [practicaf]> select count(*) from repaso where year(fechannacimiento) between '1970' and '1980';
ERROR 1054 (42S22): Unknown column 'fechannacimiento' in 'where clause'
MariaDB [practicaf]> select count(*) from repaso where year(fechanacimiento) between '1970' and '1980';
+----------+
| count(*) |
+----------+
|        5 |
+----------+
1 row in set (0.003 sec)

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

MariaDB [practicaf]> select *from repaso where year(current_date())-year(fechanacimiento) between '25' and '30;
    '> ';
Empty set, 11 warnings (0.018 sec)

MariaDB [practicaf]> select *from repaso where year(current_date())-year(fechanacimiento) between '25' and '30';
Empty set (0.001 sec)

MariaDB [practicaf]> select *from repaso where year(current_date())-year(fechanacimiento) between '35' and '40';
+--------+-------------------+--------+-----------------+----------+
| Codigo | Nombre            | Sexo   | Fechanacimiento | Nrohijos |
+--------+-------------------+--------+-----------------+----------+
| 111333 | Andrea Gutierrez  | Mujer  | 1985-04-12      |        1 |
| 444666 | Sandra Henao      | Mujer  | 1982-11-25      |        3 |
| 555777 | Mario Gomez       | Hombre | 1982-05-29      |        2 |
| 999111 | Veronica Gonzalez | Mujer  | 1982-03-30      |        1 |
+--------+-------------------+--------+-----------------+----------+
4 rows in set (0.001 sec)

MariaDB [practicaf]> select nrohijos, count(*) from repaso group by nrohijos;
+----------+----------+
| nrohijos | count(*) |
+----------+----------+
|        1 |        4 |
|        2 |        4 |
|        3 |        2 |
|        4 |        1 |
+----------+----------+
4 rows in set (0.004 sec)

MariaDB [practicaf]> select count(*) from repaso where nombre='Carlos';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from repaso where Nombre='Carlos';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from repaso where nombre='Carlos';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select *from repaso where nombre='Carlos';
Empty set (0.001 sec)

MariaDB [practicaf]> select count(*) from repaso where nombre='Carlos';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from repaso where nombre='Marina';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from repaso where nombre='Ramirez';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from repaso where nombre='Fernando';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from repaso where year(current_date)-year(fechanacimiento)<=22 and sexo'mujer';
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 ''mujer'' at line 1
MariaDB [practicaf]> select count(*) from repaso where year(current_date)-year(fechanacimiento)<=22 and sexo='mujer';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.003 sec)

MariaDB [practicaf]> select count(*) from repaso where year(current_date)-year(fechanacimiento)<=35 and sexo='mujer';
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from repaso where year(current_date)-year(fechanacimiento)<=40 and sexo='mujer';
+----------+
| count(*) |
+----------+
|        4 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select count(*) from repaso where year(current_date)-year(fechanacimiento)=>30 and sexo='Hombre' and nrohijos => 1;
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 '>30 and sexo='Hombre' and nrohijos => 1' at line 1
MariaDB [practicaf]> select count(*) from repaso where year(current_date)-year(fechanacimiento)=>30 and sexo='Hombre' and nrohijos => '1';
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 '>30 and sexo='Hombre' and nrohijos => '1'' at line 1
MariaDB [practicaf]> select count(*) from repaso where year(current_date)-year(fechanacimiento)>30 and sexo='Hombre' and nrohijos > '1';
+----------+
| count(*) |
+----------+
|        3 |
+----------+
1 row in set (0.003 sec)

MariaDB [practicaf]> select count(*) from repaso where year(current_date)-year(fechanacimiento)>25 and sexo='Mujer' and nrohijos between '1' and '3';
+----------+
| count(*) |
+----------+
|        7 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select sum() from repaso where year(current_date)-year(fechanacimiento)<=22 and sexo'mujer';
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 repaso where year(current_date)-year(fechanacimiento)<=22 and sexo'mujer'' at line 1
MariaDB [practicaf]> select sum(Sexo) from repaso where year(current_date)-year(fechanacimiento)<=22 and sexo'mujer';
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 ''mujer'' at line 1
MariaDB [practicaf]> select sum() from repaso where year(current_date)-year(fechanacimiento)<=22 and sexo='mujer';
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 repaso where year(current_date)-year(fechanacimiento)<=22 and sexo='mu...' at line 1
MariaDB [practicaf]> select sum(sexo) from repaso where year(current_date)-year(fechanacimiento)<=22 and sexo='mujer';
+-----------+
| sum(sexo) |
+-----------+
|      NULL |
+-----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select sum(sex) from repaso where year(current_date)-year(fechanacimiento)<=22 and sexo='mujer';
ERROR 1054 (42S22): Unknown column 'sex' in 'field list'
MariaDB [practicaf]> select count(*) from repaso where year(current_date)-year(fechanacimiento)>25 and sexo='Mujer' and nrohijos between '1' and '3';
+----------+
| count(*) |
+----------+
|        7 |
+----------+
1 row in set (0.001 sec)

MariaDB [practicaf]> select nombre,year(current_date())-year(fechanacimiento) 'Edad' from repaso;
+-------------------+------+
| nombre            | Edad |
+-------------------+------+
| Carlos Ramirez    |   52 |
| Andrea Gutierrez  |   36 |
| Marina Ruiz       |   43 |
| Gladys Bermudez   |   42 |
| Sandra Henao      |   39 |
| Carlos Sepulveda  |   47 |
| Fernando Perez    |   41 |
| Mario Gomez       |   39 |
| Juliana Arredondo |   33 |
| Isabel Betancur   |   44 |
| Veronica Gonzalez |   39 |
+-------------------+------+
11 rows in set (0.001 sec)

MariaDB [practicaf]> into outfile 'c:/xampp/practicaf.xls'
    -> ;
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 'into outfile 'c:/xampp/practicaf.xls'' at line 1
MariaDB [practicaf]> into outfile 'c:/xampp/practicaf.xls';
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 'into outfile 'c:/xampp/practicaf.xls'' at line 1
MariaDB [practicaf]> into outfile c:/xampp/practicaf.xls
    -> ;
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 'into outfile c:/xampp/practicaf.xls' at line 1
MariaDB [practicaf]> exit