MariaDB [createinsert]> show tables; +------------------------+ | Tables_in_createinsert | +------------------------+ | area | | ejemplar | | primer_ejercicio | +------------------------+ 3 rows in set (0.04 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.08 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.01 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.04 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]> 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]> select distict DetalleArea from primer_ejercicio -> ; ERROR 1054 (42S22): Unknown column 'distict' in 'field list' MariaDB [createinsert]> select distinct DetalleArea from primer_ejercicio; +--------------------+ | DetalleArea | +--------------------+ | Matematicas | | Informatica | | Sociales | | Ciencias Naturales | | Humanidades | +--------------------+ 5 rows in set (0.00 sec) MariaDB [createinsert]> create table ejemplar_tabla -> -> select distinct DetalleArea as Nombre -> from primer_ejercicio; Query OK, 5 rows affected (0.19 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [createinsert]> select *from ejemplar_tabla; +--------------------+ | Nombre | +--------------------+ | Matematicas | | Informatica | | Sociales | | Ciencias Naturales | | Humanidades | +--------------------+ 5 rows in set (0.00 sec) MariaDB [createinsert]> describe ejemplar_tabla; +--------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | Nombre | varchar(30) | NO | | NULL | | +--------+-------------+------+-----+---------+-------+ 1 row in set (0.02 sec) MariaDB [createinsert]> tag c:/xampp/clase10marzo.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 'tag c:/xampp/clase10marzo.txt' at line 1 MariaDB [createinsert]> select DetalleArea as Nombre, count(*) as Cantidad; ERROR 1054 (42S22): Unknown column 'DetalleArea' in 'field list' MariaDB [createinsert]> MariaDB [createinsert]> select DetalleArea as Nombre, count(*) as Cantidad from primer_ejercicio; +-------------+----------+ | Nombre | Cantidad | +-------------+----------+ | Matematicas | 7 | +-------------+----------+ 1 row in set (0.00 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.00 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.07 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 Cantidad_ejemplar -> select DetalleArea as Nombre, count(*) as Cantidad from primer_ejercicio -> group by DetalleArea; Query OK, 5 rows affected (0.16 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [createinsert]> describe Cantidad_ejemplar; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | Nombre | varchar(30) | NO | | NULL | | | Cantidad | bigint(21) | NO | | NULL | | +----------+-------------+------+-----+---------+-------+ 2 rows in set (0.01 sec) MariaDB [createinsert]> select *from Cantidad_ejemplar; +--------------------+----------+ | Nombre | Cantidad | +--------------------+----------+ | Ciencias Naturales | 1 | | Humanidades | 1 | | Informatica | 2 | | Matematicas | 2 | | Sociales | 1 | +--------------------+----------+ 5 rows in set (0.00 sec) MariaDB [createinsert]> select DetalleArea as Nombre, count(*) as Cantidad,sum(Valor) as Valor_Total from primer_ejercicio -> ; +-------------+----------+-------------+ | Nombre | Cantidad | Valor_Total | +-------------+----------+-------------+ | Matematicas | 7 | 625000 | +-------------+----------+-------------+ 1 row in set (0.00 sec) MariaDB [createinsert]> select DetalleArea as Nombre, count(*) as Cantidad,sum(Valor) as Valor_Total from primer_ejercicio -> group by DetalleArea; +--------------------+----------+-------------+ | Nombre | Cantidad | Valor_Total | +--------------------+----------+-------------+ | Ciencias Naturales | 1 | 60000 | | Humanidades | 1 | 150000 | | Informatica | 2 | 185000 | | Matematicas | 2 | 170000 | | Sociales | 1 | 60000 | +--------------------+----------+-------------+ 5 rows in set (0.00 sec) MariaDB [createinsert]> create table ValorTotalLibros -> select DetalleArea as Nombre, count(*) as Cantidad,sum(Valor) as Valor_Total from primer_ejercicio -> group by DetalleArea; Query OK, 5 rows affected (0.16 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [createinsert]> describe ValorTotalLibros; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Nombre | varchar(30) | NO | | NULL | | | Cantidad | bigint(21) | NO | | NULL | | | Valor_Total | double | YES | | NULL | | +-------------+-------------+------+-----+---------+-------+ 3 rows in set (0.01 sec) MariaDB [createinsert]> select *from ValorTotalLibros; +--------------------+----------+-------------+ | Nombre | Cantidad | Valor_Total | +--------------------+----------+-------------+ | Ciencias Naturales | 1 | 60000 | | Humanidades | 1 | 150000 | | Informatica | 2 | 185000 | | Matematicas | 2 | 170000 | | Sociales | 1 | 60000 | +--------------------+----------+-------------+ 5 rows in set (0.00 sec) MariaDB [createinsert]> select sum(Valor)as Valor_Total from primer_ejercicio -> ; +-------------+ | Valor_Total | +-------------+ | 625000 | +-------------+ 1 row in set (0.00 sec) MariaDB [createinsert]> select sum(Valor)as Valor_Total from primer_ejercicio -> group by DetalleArea; +-------------+ | Valor_Total | +-------------+ | 60000 | | 150000 | | 185000 | | 170000 | | 60000 | +-------------+ 5 rows in set (0.00 sec) MariaDB [createinsert]> drop ValorTotalLibros; 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 'ValorTotalLibros' at line 1 MariaDB [createinsert]> drop table ValorTotalLibros; Query OK, 0 rows affected (0.11 sec) MariaDB [createinsert]> create table ValorTotalLibros -> select sum(Valor)as Valor_Total from primer_ejercicio -> group by DetalleArea; Query OK, 5 rows affected (0.33 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [createinsert]> create table ValorTotalArea -> select DetalleArea as Nombre, count(*) as Cantidad,sum(Valor) as Valor_Total from primer_ejercicio -> gruop by DetalleArea; 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 'by DetalleArea' at line 3 MariaDB [createinsert]> create table ValorTotalArea -> select DetalleArea as Nombre, count(*) as Cantidad,sum(Valor) as Valor_Total from primer_ejercicio -> group by DetalleArea; Query OK, 5 rows affected (0.18 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [createinsert]> select *from ValotTotalArea; ERROR 1146 (42S02): Table 'createinsert.valottotalarea' doesn't exist MariaDB [createinsert]> select *from ValoRTotalArea; +--------------------+----------+-------------+ | Nombre | Cantidad | Valor_Total | +--------------------+----------+-------------+ | Ciencias Naturales | 1 | 60000 | | Humanidades | 1 | 150000 | | Informatica | 2 | 185000 | | Matematicas | 2 | 170000 | | Sociales | 1 | 60000 | +--------------------+----------+-------------+ 5 rows in set (0.00 sec) MariaDB [createinsert]> select *from ValorTotalLibro; ERROR 1146 (42S02): Table 'createinsert.valortotallibro' doesn't exist MariaDB [createinsert]> select *from ValorTotalLibros; +-------------+ | Valor_Total | +-------------+ | 60000 | | 150000 | | 185000 | | 170000 | | 60000 | +-------------+ 5 rows in set (0.00 sec) MariaDB [createinsert]> drop table ValorTotalLibros; Query OK, 0 rows affected (0.09 sec) MariaDB [createinsert]> create table ValorTotalLibros -> select sum(Valor)as Valor_Total from primer_ejercicio; Query OK, 1 row affected (0.15 sec) Records: 1 Duplicates: 0 Warnings: 0 MariaDB [createinsert]> select *from ValorTotalLibros; +-------------+ | Valor_Total | +-------------+ | 625000 | +-------------+ 1 row 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; +----+-----------------------+---------+--------+--------+ | 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]> 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.00 sec) MariaDB [createinsert]> show create table area; +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ | area | CREATE TABLE `area` ( `CodArea` varchar(5) NOT NULL, `Descripcion` varchar(25) NOT NULL, PRIMARY KEY (`CodArea`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [createinsert]> select a.Descripcion as Nombre,count(*) as cantidad -> from area as a -> join ejemplar as e -> on a.CodArea=e.CodArea -> group by DetalleArea; ERROR 1054 (42S22): Unknown column 'DetalleArea' in 'group statement' MariaDB [createinsert]> select a.Descripcion as Nombre,count(*) as cantidad -> from area as a -> join ejemplar as e -> on a.CodArea=e.CodArea -> group by a.DetalleArea; ERROR 1054 (42S22): Unknown column 'a.DetalleArea' in 'group statement' MariaDB [createinsert]> select a.Descripcion as Nombre,count(*) as cantidad -> from area as a -> join ejemplar as e -> on a.CodArea=e.CodArea -> group by a.DetalleArea; ERROR 1054 (42S22): Unknown column 'a.DetalleArea' in 'group statement' MariaDB [createinsert]> select area.Descripcion as Nombre,count(*) as cantidad -> from area -> join ejemplar -> on area.CodArea=ejemplar.CodArea -> group by area.DetalleArea; ERROR 1054 (42S22): Unknown column 'area.DetalleArea' in 'group statement' MariaDB [createinsert]> select a.Descripcion as Nombre,count(*) as cantidad -> from area as a -> join ejemplar as e -> on a.CodArea=e.CodArea -> group by a.Descripcion; +--------------------+----------+ | Nombre | cantidad | +--------------------+----------+ | Ciencias Naturales | 1 | | Humanidades | 1 | | Informatica | 2 | | Matematicas | 2 | | Sociales | 1 | +--------------------+----------+ 5 rows in set (0.00 sec) MariaDB [createinsert]> create table NumeroEjemplaresArea -> select a.Descripcion as Nombre,count(*) as cantidad -> from area as a -> join ejemplar as e -> on a.CodArea=e.CodArea -> group by a.Descripcion; Query OK, 5 rows affected (0.42 sec) Records: 5 Duplicates: 0 Warnings: 0 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; +----+-----------------------+---------+--------+--------+ | 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]> insert into ejemplar(id,nombre,codarea,valor,nropag) -> select '8','Base de datos II','002',45000,'110' -> 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 | Base de datos II | 002 | 45000 | 110 | +----+-----------------------+---------+--------+--------+ 8 rows in set (0.00 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.02 sec) MariaDB [createinsert]> select a.Descripcion as Nombre,count(*) as cantidad -> group by a.Descripcion; 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 'group by a.Descripcion' at line 2 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)