MariaDB [createinsert]> show databases;
+--------------------+
| Database           |
+--------------------+
| createinsert       |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.00 sec)

MariaDB [createinsert]> show table;
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 '' at line 1
MariaDB [createinsert]> show tables;
+------------------------+
| Tables_in_createinsert |
+------------------------+
| area                   |
| ejemplar               |
| primer_ejercicio       |
+------------------------+
3 rows in set (0.00 sec)

MariaDB [createinsert]> select * from area;
+---------+--------------------+
| CodArea | Descripcion        |
+---------+--------------------+
| 001     | Matematicas        |
| 002     | Informatica        |
| 003     | Ciencias Naturales |
| 004     | Sociales           |
| 005     | Humanidades        |
+---------+--------------------+
5 rows in set (0.00 sec)

MariaDB [createinsert]> select * from ejemplar
    -> '
    '> ;
    '> '
    -> ;
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 ''
;
'' at line 2
MariaDB [createinsert]> select * from ejemplar;
+----+-----------------------+---------+--------+--------+
| id | Nombre                | CodArea | valor  | NroPag |
+----+-----------------------+---------+--------+--------+
| 1  | Calculo 1             | 001     |  80000 |     42 |
| 2  | Matematicas Avanzadas | 001     |  90000 |     80 |
| 3  | Introducci¢n al Pc    | 002     | 120000 |    240 |
| 4  | Redes y Telematica    | 002     |  65000 |     58 |
| 5  | Goegrafia Colombiana  | 004     |  40000 |     82 |
| 6  | Ciencias Sexto        | 003     |  60800 |     46 |
| 7  | Etica y Valores       | 005     | 150000 |    100 |
+----+-----------------------+---------+--------+--------+
7 rows in set (0.00 sec)

MariaDB [createinsert]> select * from primer_ejercicio;
+----+----------------------+--------------------+--------+
| id | Nombre               | DetalleArea        | Valor  |
+----+----------------------+--------------------+--------+
| 1  | Calculo 1            | Matematicas        |  80000 |
| 2  | Matematicas Avanzada | Matematicas        |  90000 |
| 3  | Introduccion al Pc   | Informatica        | 120000 |
| 4  | Redes y Telematica   | Informatica        |  65000 |
| 5  | Geografia Colombiana | Sociales           |  60000 |
| 6  | Ciencias sextos      | Ciencias Naturales |  60000 |
| 7  | Etica y valores      | Humanidades        | 150000 |
+----+----------------------+--------------------+--------+
7 rows in set (0.00 sec)

MariaDB [createinsert]> create table ejemplararea
    -> select distinct DetalleArea as nombre
    -> from primer_ejercicio;
Query OK, 5 rows affected (0.21 sec)
Records: 5  Duplicates: 0  Warnings: 0

MariaDB [createinsert]> select * from ejemplararea;
+--------------------+
| nombre             |
+--------------------+
| Matematicas        |
| Informatica        |
| Sociales           |
| Ciencias Naturales |
| Humanidades        |
+--------------------+
5 rows in set (0.00 sec)

MariaDB [createinsert]> create table cantidadejemplares
    -> select DetalleArea as nombre,count(*) as cantidad
    -> from primer_ejercicio
    -> group by DetalleArea;
Query OK, 5 rows affected (0.25 sec)
Records: 5  Duplicates: 0  Warnings: 0

MariaDB [createinsert]> select * from cantidadejemplares;
+--------------------+----------+
| nombre             | cantidad |
+--------------------+----------+
| Ciencias Naturales |        1 |
| Humanidades        |        1 |
| Informatica        |        2 |
| Matematicas        |        2 |
| Sociales           |        1 |
+--------------------+----------+
5 rows in set (0.00 sec)

MariaDB [createinsert]> select a.descripcion,count(*)
    -> from ejemplar as e
    -> join area as a
    -> on e.CodArea=a.CodArea
    -> group by a.descripcion;
+--------------------+----------+
| descripcion        | count(*) |
+--------------------+----------+
| Ciencias Naturales |        1 |
| Humanidades        |        1 |
| Informatica        |        2 |
| Matematicas        |        2 |
| Sociales           |        1 |
+--------------------+----------+
5 rows in set (0.00 sec)

MariaDB [createinsert]> create table numerodeejemplaresporarea
    -> select a.descripcion,count(*)
    -> from ejemplar as e
    -> join area as a
    -> on e.CodArea=a.CodArea
    -> group by a.descripcion;
Query OK, 5 rows affected (0.24 sec)
Records: 5  Duplicates: 0  Warnings: 0

MariaDB [createinsert]> select * from numerodeejemplaresporarea;
+--------------------+----------+
| descripcion        | count(*) |
+--------------------+----------+
| Ciencias Naturales |        1 |
| Humanidades        |        1 |
| Informatica        |        2 |
| Matematicas        |        2 |
| Sociales           |        1 |
+--------------------+----------+
5 rows in set (0.00 sec)

MariaDB [createinsert]> show tables;
+---------------------------+
| Tables_in_createinsert    |
+---------------------------+
| area                      |
| cantidadejemplares        |
| ejemplar                  |
| ejemplararea              |
| numerodeejemplaresporarea |
| primer_ejercicio          |
+---------------------------+
6 rows in set (0.00 sec)

MariaDB [createinsert]> select * from ejemplar;
+----+-----------------------+---------+--------+--------+
| id | Nombre                | CodArea | valor  | NroPag |
+----+-----------------------+---------+--------+--------+
| 1  | Calculo 1             | 001     |  80000 |     42 |
| 2  | Matematicas Avanzadas | 001     |  90000 |     80 |
| 3  | Introducci¢n al Pc    | 002     | 120000 |    240 |
| 4  | Redes y Telematica    | 002     |  65000 |     58 |
| 5  | Goegrafia Colombiana  | 004     |  40000 |     82 |
| 6  | Ciencias Sexto        | 003     |  60800 |     46 |
| 7  | Etica y Valores       | 005     | 150000 |    100 |
+----+-----------------------+---------+--------+--------+
7 rows in set (0.00 sec)

MariaDB [createinsert]> select * from area;
+---------+--------------------+
| CodArea | Descripcion        |
+---------+--------------------+
| 001     | Matematicas        |
| 002     | Informatica        |
| 003     | Ciencias Naturales |
| 004     | Sociales           |
| 005     | Humanidades        |
+---------+--------------------+
5 rows in set (0.00 sec)

MariaDB [createinsert]> insert into ejemplar(id,nombre,codarea,valor,nropag)
    -> select '8','BD II',codarea,45000,120
    -> from area
    -> where descripcion='informatica';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

MariaDB [createinsert]> select * from ejemplar;
+----+-----------------------+---------+--------+--------+
| id | Nombre                | CodArea | valor  | NroPag |
+----+-----------------------+---------+--------+--------+
| 1  | Calculo 1             | 001     |  80000 |     42 |
| 2  | Matematicas Avanzadas | 001     |  90000 |     80 |
| 3  | Introducci¢n al Pc    | 002     | 120000 |    240 |
| 4  | Redes y Telematica    | 002     |  65000 |     58 |
| 5  | Goegrafia Colombiana  | 004     |  40000 |     82 |
| 6  | Ciencias Sexto        | 003     |  60800 |     46 |
| 7  | Etica y Valores       | 005     | 150000 |    100 |
| 8  | BD II                 | 002     |  45000 |    120 |
+----+-----------------------+---------+--------+--------+
8 rows in set (0.00 sec)

MariaDB [createinsert]> exit