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.001 sec) MariaDB [createinsert]> select DetalleArea from primer_ejercicio; +--------------------+ | DetalleArea | +--------------------+ | Matematicas | | Matematicas | | Informatica | | Informatica | | Sociales | | Ciencias Naturales | | Humanidades | +--------------------+ 7 rows in set (0.000 sec) MariaDB [createinsert]> select distinct DetalleArea from primer_ejercicio; +--------------------+ | DetalleArea | +--------------------+ | Matematicas | | Informatica | | Sociales | | Ciencias Naturales | | Humanidades | +--------------------+ 5 rows in set (0.000 sec) MariaDB [createinsert]> Create table ejemplararea -> select distinct DetalleArea as nombre -> from primer_ejercicio; Query OK, 5 rows affected (0.020 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [createinsert]> select * from ejemplararea; +--------------------+ | nombre | +--------------------+ | Matematicas | | Informatica | | Sociales | | Ciencias Naturales | | Humanidades | +--------------------+ 5 rows in set (0.000 sec) MariaDB [createinsert]> describe ejemplararea; +--------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | nombre | varchar(30) | NO | | NULL | | +--------+-------------+------+-----+---------+-------+ 1 row in set (0.008 sec) MariaDB [createinsert]> describe primer_ejercicio; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | id | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(40) | NO | | NULL | | | DetalleArea | varchar(30) | NO | | NULL | | | Valor | float | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 4 rows in set (0.010 sec) MariaDB [createinsert]> select DetalleArea as nombre, count(*) as cantidad -> from primer_ejercicio -> group by DetalleArea; +--------------------+----------+ | nombre | cantidad | +--------------------+----------+ | Ciencias Naturales | 1 | | Humanidades | 1 | | Informatica | 2 | | Matematicas | 2 | | Sociales | 1 | +--------------------+----------+ 5 rows in set (0.000 sec) MariaDB [createinsert]> select DetalleArea as nombre, count(*) as cantidad; ERROR 1054 (42S22): Unknown column 'DetalleArea' in 'field list' MariaDB [createinsert]> select DetalleArea as nombre, count(*) as cantidad from primer_ejercicio; +-------------+----------+ | nombre | cantidad | +-------------+----------+ | Matematicas | 7 | +-------------+----------+ 1 row in set (0.000 sec) MariaDB [createinsert]> select DetalleArea as nombre, count(*) as cantidad -> from primer_ejercicio -> group by DetalleArea; +--------------------+----------+ | nombre | cantidad | +--------------------+----------+ | Ciencias Naturales | 1 | | Humanidades | 1 | | Informatica | 2 | | Matematicas | 2 | | Sociales | 1 | +--------------------+----------+ 5 rows in set (0.000 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.019 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.000 sec) MariaDB [createinsert]> describe cantidadejemplares; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | nombre | varchar(30) | NO | | NULL | | | cantidad | bigint(21) | NO | | NULL | | +----------+-------------+------+-----+---------+-------+ 2 rows in set (0.008 sec) MariaDB [createinsert]> create table cantidadejemplares -> select DetalleArea as nombre, count(*) as cantidad -> from primer_ejercicio -> group by DetalleArea;create table cantidadejemplares ERROR 1050 (42S01): Table 'cantidadejemplares' already exists -> select DetalleArea as nombre, count(*) as cantidad -> from primer_ejercicio -> group by DetalleArea; ERROR 1050 (42S01): Table 'cantidadejemplares' already exists MariaDB [createinsert]> select * from primerejercicio; ERROR 1146 (42S02): Table 'createinsert.primerejercicio' doesn't exist MariaDB [createinsert]> ; ERROR: No query specified MariaDB [createinsert]> select * from primerejercicio; ERROR 1146 (42S02): Table 'createinsert.primerejercicio' doesn't exist 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.000 sec) MariaDB [createinsert]> select detalleArea, sum(valor) 'Valor Total' from primer_ejercicio group by detalleArea; +--------------------+-------------+ | detalleArea | Valor Total | +--------------------+-------------+ | Ciencias Naturales | 60000 | | Humanidades | 150000 | | Informatica | 185000 | | Matematicas | 170000 | | Sociales | 60000 | +--------------------+-------------+ 5 rows in set (0.000 sec) MariaDB [createinsert]> create table valortotal -> select detalleArea, sum(valor) 'Valor Total' from primer_ejercicio group by detalleArea; Query OK, 5 rows affected (0.018 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [createinsert]> select * from valortotal; +--------------------+-------------+ | detalleArea | Valor Total | +--------------------+-------------+ | Ciencias Naturales | 60000 | | Humanidades | 150000 | | Informatica | 185000 | | Matematicas | 170000 | | Sociales | 60000 | +--------------------+-------------+ 5 rows in set (0.000 sec) MariaDB [createinsert]> describe valortotal; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | detalleArea | varchar(30) | NO | | NULL | | | Valor Total | double | YES | | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.008 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.001 sec) MariaDB [createinsert]> select * from area; +---------+--------------------+ | CodArea | Descripcion | +---------+--------------------+ | 001 | Matematicas | | 002 | Informatica | | 003 | Ciencias Naturales | | 004 | Sociales | | 005 | Humanidades | +---------+--------------------+ 5 rows in set (0.001 sec) MariaDB [createinsert]> describe ejemplar; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | id | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(40) | NO | | NULL | | | CodArea | varchar(5) | NO | MUL | NULL | | | valor | float | NO | | NULL | | | NroPag | int(11) | NO | | NULL | | +---------+-------------+------+-----+---------+-------+ 5 rows in set (0.008 sec) MariaDB [createinsert]> show create table ejemplar; +----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ejemplar | CREATE TABLE `ejemplar` ( `id` varchar(10) NOT NULL, `Nombre` varchar(40) NOT NULL, `CodArea` varchar(5) NOT NULL, `valor` float NOT NULL, `NroPag` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `CodArea` (`CodArea`), CONSTRAINT `ejemplar_ibfk_1` FOREIGN KEY (`CodArea`) REFERENCES `area` (`CodArea`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [createinsert]> describe area; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | CodArea | varchar(5) | NO | PRI | NULL | | | Descripcion | varchar(25) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.008 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.000 sec) MariaDB [createinsert]> create table numerodeejemplaresporarea -> select a.descripcion,count(*) as cantidad -> from ejemplar as e -> join area as a -> on e.CodArea=a.CodArea -> group by a.descripcion; Query OK, 5 rows affected (0.019 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [createinsert]> select * from numerodeejemplaresporarea; +--------------------+----------+ | descripcion | cantidad | +--------------------+----------+ | Ciencias Naturales | 1 | | Humanidades | 1 | | Informatica | 2 | | Matematicas | 2 | | Sociales | 1 | +--------------------+----------+ 5 rows in set (0.000 sec) MariaDB [createinsert]> describe numerodeejemplaresporarea; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | descripcion | varchar(25) | NO | | NULL | | | cantidad | bigint(21) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.010 sec) MariaDB [createinsert]> show create table numerodeejemplaresporarea; +---------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+ | numerodeejemplaresporarea | CREATE TABLE `numerodeejemplaresporarea` ( `descripcion` varchar(25) NOT NULL, `cantidad` bigint(21) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +---------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 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.000 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.002 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.000 sec) MariaDB [createinsert]>