MariaDB [(none)]> create table Repaso2 -> (Codigo varchar(10) not null, -> Nombre varchar(30) not null, -> Sexo varchar(10) not null, -> Fecha_Nacimiento date, -> Numero_Hijos int(1)not null); ERROR 1046 (3D000): No database selected MariaDB [(none)]> tee c:/xampp/Repaso2mysql.txt MariaDB [(none)]> use Practica2 ERROR 1049 (42000): Unknown database 'practica2' MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | fechas | | gestionescolar | | information_schema | | libreria | | matricula | | matricula2 | | mysql | | nombre_biblioteca | | performance_schema | | phpmyadmin | | practicaf | | procolor | | reto2 | | subconsultas | | test | | turismo | +--------------------+ 16 rows in set (0.004 sec) MariaDB [(none)]> create database Practica2; Query OK, 1 row affected (0.004 sec) MariaDB [(none)]> use Practica2; Database changed MariaDB [Practica2]> create table Repaso 2 -> (Codigo varchar(10) not null, -> Nombre varchar(30) not null, -> Sexo varchar(10) not null, -> Fecha_Nacimiento date, -> Numero_Hijos int(1)not null); 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 '2 (Codigo varchar(10) not null, Nombre varchar(30) not null, Sexo varchar(10)...' at line 1 MariaDB [Practica2]> (Codigo varchar(10) not null, -> Nombre varchar(30) not null, -> Sexo varchar(10) not null, -> Fecha_Nacimiento date, -> Numero_Hijos int(1)not null); 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 'Codigo varchar(10) not null, Nombre varchar(30) not null, Sexo varchar(10) no...' at line 1 MariaDB [Practica2]> create table Repaso2 ( -> Codigo varchar(10) not null, -> Nombre varchar(30) not null, -> Sexo varchar(10) not null, -> Fecha_Nacimiento date, -> Numero_Hijos int not null -> ); Query OK, 0 rows affected (0.028 sec) MariaDB [Practica2]> describe Repaso; ERROR 1146 (42S02): Table 'practica2.repaso' doesn't exist MariaDB [Practica2]> describe Repaso2; +------------------+-------------+------+-----+---------+-------+ | 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(11) | NO | | NULL | | +------------------+-------------+------+-----+---------+-------+ 5 rows in set (0.028 sec) MariaDB [Practica2]> insert into Repaso2(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.014 sec) Records: 11 Duplicates: 0 Warnings: 0 MariaDB [Practica2]> select * from Repaso2; +--------+-------------------+--------+------------------+--------------+ | 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.000 sec) MariaDB [Practica2]> select count(*) "Numero_mujeres" from Repaso2 where Sexo = "mujer" and Nombre like "%z"; +----------------+ | Numero_mujeres | +----------------+ | 4 | +----------------+ 1 row in set (0.000 sec) MariaDB [Practica2]> select count(*) "Numero_nacimiento" from Repaso2 where year(Fecha_Nacimiento) between "1970" and "1979"; +-------------------+ | Numero_nacimiento | +-------------------+ | 4 | +-------------------+ 1 row in set (0.000 sec) MariaDB [Practica2]> select Nombre from Repaso2 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 Repaso2; +-------------+ | Total hijos | +-------------+ | 22 | +-------------+ 1 row in set (0.001 sec) MariaDB [Practica2]> select Nombre, Numero_Hijos from Repaso2 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 Repaso2 where Nombre like "%carlos%"; +----------+ | count(*) | +----------+ | 2 | +----------+ 1 row in set (0.000 sec) MariaDB [Practica2]> select count(*) from Repaso2 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 Repaso2 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 Repaso2 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