MariaDB [libreria]> select descripcion,nropaginas,precio from libro where precio > 5000;
ERROR 1054 (42S22): Unknown column 'nropaginas' in 'field list'
MariaDB [libreria]> select descripcion,nropagina,precio from libro where precio > 5000;
+---------------------+-----------+--------+
| descripcion         | nropagina | precio |
+---------------------+-----------+--------+
| Calculo II          |       120 |  55000 |
| BD II               |       150 |  65000 |
| Estructura de datos |       180 |  85000 |
| Ingles              |       280 | 105000 |
| Admon en una pagina |        70 |   7500 |
| Contabilidad I      |       170 |  27500 |
| Redes               |       370 |  32500 |
| Diagramacion        |        85 |  45000 |
+---------------------+-----------+--------+
8 rows in set (0.000 sec)

MariaDB [libreria]> select descripcion,nropagina,precio from libro where precio > 50000;
+---------------------+-----------+--------+
| descripcion         | nropagina | precio |
+---------------------+-----------+--------+
| Calculo II          |       120 |  55000 |
| BD II               |       150 |  65000 |
| Estructura de datos |       180 |  85000 |
| Ingles              |       280 | 105000 |
+---------------------+-----------+--------+
4 rows in set (0.001 sec)

MariaDB [libreria]> select descripcion,nropagina,precio from libro where precio > 35000;
+---------------------+-----------+--------+
| descripcion         | nropagina | precio |
+---------------------+-----------+--------+
| Calculo II          |       120 |  55000 |
| BD II               |       150 |  65000 |
| Estructura de datos |       180 |  85000 |
| Ingles              |       280 | 105000 |
| Diagramacion        |        85 |  45000 |
+---------------------+-----------+--------+
5 rows in set (0.000 sec)

MariaDB [libreria]> select descripcion,nropagina,precio from libro where precio < 30000;
+---------------------+-----------+--------+
| descripcion         | nropagina | precio |
+---------------------+-----------+--------+
| Admon en una pagina |        70 |   7500 |
| Contabilidad I      |       170 |  27500 |
+---------------------+-----------+--------+
2 rows in set (0.000 sec)

MariaDB [libreria]> select * from libro where descripcion = 'Base de datos II';
Empty set (0.001 sec)

MariaDB [libreria]> select * from libro where descripcion = 'BD II';
+---------+-------------+-----------+--------+-----------+
| idlibro | descripcion | nropagina | precio | codigomat |
+---------+-------------+-----------+--------+-----------+
| L02     | BD II       |       150 |  65000 | M09       |
+---------+-------------+-----------+--------+-----------+
1 row in set (0.001 sec)

MariaDB [libreria]> select * from libro where nropagina >= 100 && precio >= 10000;
+---------+---------------------+-----------+--------+-----------+
| idlibro | descripcion         | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L01     | Calculo II          |       120 |  55000 | M01       |
| L02     | BD II               |       150 |  65000 | M09       |
| L03     | Estructura de datos |       180 |  85000 | M03       |
| L04     | Ingles              |       280 | 105000 | M04       |
| L06     | Contabilidad I      |       170 |  27500 | M06       |
| L07     | Redes               |       370 |  32500 | M07       |
+---------+---------------------+-----------+--------+-----------+
6 rows in set (0.001 sec)

MariaDB [libreria]> select * from libro where idlibro = 'L01' || idlibro = 'L02' || idlibro = 'L03';
+---------+---------------------+-----------+--------+-----------+
| idlibro | descripcion         | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L01     | Calculo II          |       120 |  55000 | M01       |
| L02     | BD II               |       150 |  65000 | M09       |
| L03     | Estructura de datos |       180 |  85000 | M03       |
+---------+---------------------+-----------+--------+-----------+
3 rows in set (0.001 sec)

MariaDB [libreria]> select * from libro beetwen idlibro = 'L01','L05' ;
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 'idlibro = 'L01','L05'' at line 1
MariaDB [libreria]> select * from libro WHERE idlibro BETWEEN 'L01' AND 'L02';
+---------+-------------+-----------+--------+-----------+
| idlibro | descripcion | nropagina | precio | codigomat |
+---------+-------------+-----------+--------+-----------+
| L01     | Calculo II  |       120 |  55000 | M01       |
| L02     | BD II       |       150 |  65000 | M09       |
+---------+-------------+-----------+--------+-----------+
2 rows in set (0.000 sec)

MariaDB [libreria]> select * from libro WHERE idlibro BETWEEN 'L01' AND 'L05';
+---------+---------------------+-----------+--------+-----------+
| idlibro | descripcion         | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L01     | Calculo II          |       120 |  55000 | M01       |
| L02     | BD II               |       150 |  65000 | M09       |
| L03     | Estructura de datos |       180 |  85000 | M03       |
| L04     | Ingles              |       280 | 105000 | M04       |
| L05     | Admon en una pagina |        70 |   7500 | M05       |
+---------+---------------------+-----------+--------+-----------+
5 rows in set (0.000 sec)

MariaDB [libreria]> select * from libro where idlibro like 'c%';
Empty set (0.001 sec)

MariaDB [libreria]> select * from libro where idlibro like 'C%';
Empty set (0.000 sec)

MariaDB [libreria]> select * from libro where descripcion like 'C%';
+---------+----------------+-----------+--------+-----------+
| idlibro | descripcion    | nropagina | precio | codigomat |
+---------+----------------+-----------+--------+-----------+
| L01     | Calculo II     |       120 |  55000 | M01       |
| L06     | Contabilidad I |       170 |  27500 | M06       |
+---------+----------------+-----------+--------+-----------+
2 rows in set (0.000 sec)

MariaDB [libreria]> select * from libro where descripcion like '%s';
+---------+---------------------+-----------+--------+-----------+
| idlibro | descripcion         | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L03     | Estructura de datos |       180 |  85000 | M03       |
| L04     | Ingles              |       280 | 105000 | M04       |
| L07     | Redes               |       370 |  32500 | M07       |
+---------+---------------------+-----------+--------+-----------+
3 rows in set (0.000 sec)

MariaDB [libreria]> select * from libro where descripcion like '%t%';
+---------+---------------------+-----------+--------+-----------+
| idlibro | descripcion         | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L03     | Estructura de datos |       180 |  85000 | M03       |
| L06     | Contabilidad I      |       170 |  27500 | M06       |
+---------+---------------------+-----------+--------+-----------+
2 rows in set (0.000 sec)

MariaDB [libreria]> select * from libro where descripcion like '%datos%';
+---------+---------------------+-----------+--------+-----------+
| idlibro | descripcion         | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L03     | Estructura de datos |       180 |  85000 | M03       |
+---------+---------------------+-----------+--------+-----------+
1 row in set (0.001 sec)

MariaDB [libreria]> describe liautedi;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| idlibro  | varchar(10) | NO   | MUL | NULL    |       |
| codautor | varchar(10) | NO   | MUL | NULL    |       |
| codedit  | varchar(10) | NO   | MUL | NULL    |       |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.011 sec)

MariaDB [libreria]> describe libro;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| idlibro     | varchar(10) | NO   | PRI | NULL    |       |
| descripcion | varchar(50) | NO   |     | NULL    |       |
| nropagina   | int(8)      | NO   |     | NULL    |       |
| precio      | int(8)      | NO   |     | NULL    |       |
| codigomat   | varchar(10) | NO   |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
5 rows in set (0.010 sec)

MariaDB [libreria]> describe autor;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| codautor | varchar(10) | NO   | PRI | NULL    |       |
| nombre   | varchar(50) | NO   |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
2 rows in set (0.013 sec)

MariaDB [libreria]> select * from libro;
+---------+---------------------+-----------+--------+-----------+
| idlibro | descripcion         | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L01     | Calculo II          |       120 |  55000 | M01       |
| L02     | BD II               |       150 |  65000 | M09       |
| L03     | Estructura de datos |       180 |  85000 | M03       |
| L04     | Ingles              |       280 | 105000 | M04       |
| L05     | Admon en una pagina |        70 |   7500 | M05       |
| L06     | Contabilidad I      |       170 |  27500 | M06       |
| L07     | Redes               |       370 |  32500 | M07       |
| L08     | Diagramacion        |        85 |  45000 | M08       |
+---------+---------------------+-----------+--------+-----------+
8 rows in set (0.000 sec)

MariaDB [libreria]> select * from autor;
+----------+----------------------+
| codautor | nombre               |
+----------+----------------------+
| A01      | Luis Joyanes         |
| A02      | Jorge Vasquez Posada |
| A03      | Jhon Soars           |
| A04      | Riaz Khadem          |
| A05      | Robert Lorber        |
| A06      | Mario Dream          |
+----------+----------------------+
6 rows in set (0.000 sec)

MariaDB [libreria]> describe 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 'table' at line 1
MariaDB [libreria]> show tables;
+--------------------+
| Tables_in_libreria |
+--------------------+
| asignatura         |
| autor              |
| editorial          |
| liautedi           |
| libro              |
+--------------------+
5 rows in set (0.000 sec)

MariaDB [libreria]> describe asignatura;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| codigomat | varchar(10) | NO   | PRI | NULL    |       |
| nombre    | varchar(50) | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.013 sec)



MariaDB [libreria]> select libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro,autor,liautedi
    -> where libro.idlibro=liautedi.idlibro && liautedi.codautor=autor.codautor;
+---------+----------------+----------+----------------------+
| idlibro | descripcion    | codautor | nombre               |
+---------+----------------+----------+----------------------+
| L02     | BD II          | A01      | Luis Joyanes         |
| L02     | BD II          | A05      | Robert Lorber        |
| L06     | Contabilidad I | A02      | Jorge Vasquez Posada |
| L07     | Redes          | A05      | Robert Lorber        |
| L04     | Ingles         | A04      | Riaz Khadem          |
| L04     | Ingles         | A04      | Riaz Khadem          |
| L04     | Ingles         | A04      | Riaz Khadem          |
+---------+----------------+----------+----------------------+
7 rows in set (0.001 sec)

MariaDB [libreria]> select distinct libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro,autor,liautedi
    -> where libro.idlibro=liautedi.idlibro && liautedi.codautor=autor.codautor;
+---------+----------------+----------+----------------------+
| idlibro | descripcion    | codautor | nombre               |
+---------+----------------+----------+----------------------+
| L02     | BD II          | A01      | Luis Joyanes         |
| L02     | BD II          | A05      | Robert Lorber        |
| L06     | Contabilidad I | A02      | Jorge Vasquez Posada |
| L07     | Redes          | A05      | Robert Lorber        |
| L04     | Ingles         | A04      | Riaz Khadem          |
+---------+----------------+----------+----------------------+
5 rows in set (0.001 sec)

MariaDB [libreria]> exit