MariaDB [(none)]> source C:\Users\sebas\Downloads\matricula2.sql
Query OK, 0 rows affected (0.054 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.004 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 1 row affected (0.005 sec)

Database changed
Query OK, 0 rows affected (0.009 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.051 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.003 sec)

Query OK, 4 rows affected (0.003 sec)
Records: 4  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.013 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.003 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 6 rows affected (0.002 sec)
Records: 6  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.011 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 8 rows affected (0.002 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.014 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 6 rows affected (0.002 sec)
Records: 6  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.017 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.006 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.009 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 6 rows affected (0.002 sec)
Records: 6  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

MariaDB [matricula2]> show databases;
+--------------------+
| Database           |
+--------------------+
| bdbiblioteca       |
| information_schema |
| libreria           |
| libro              |
| matricula          |
| matricula1         |
| matricula2         |
| mysql              |
| performance_schema |
| phpmyadmin         |
| prueba             |
| test               |
+--------------------+
12 rows in set (0.054 sec)

MariaDB [matricula2]>  describe Alumno;
+-----------+----------+------+-----+---------+-------+
| Field     | Type     | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+-------+
| codestu   | char(3)  | NO   | PRI | NULL    |       |
| nombre    | char(60) | NO   |     | NULL    |       |
| direccion | char(50) | NO   |     | NULL    |       |
| telefono  | char(10) | NO   |     | NULL    |       |
+-----------+----------+------+-----+---------+-------+
4 rows in set (0.059 sec)

MariaDB [matricula2]> describe carrera;
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| codcarre | char(3)  | NO   | PRI | NULL    |       |
| carrera  | char(30) | NO   |     | NULL    |       |
+----------+----------+------+-----+---------+-------+
2 rows in set (0.004 sec)

MariaDB [matricula2]> describe profesor;
+-----------+----------+------+-----+---------+-------+
| Field     | Type     | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+-------+
| codprofe  | char(3)  | NO   | PRI | NULL    |       |
| nombre    | char(60) | NO   |     | NULL    |       |
| direccion | char(50) | NO   |     | NULL    |       |
| telefono  | char(10) | NO   |     | NULL    |       |
+-----------+----------+------+-----+---------+-------+
4 rows in set (0.006 sec)

MariaDB [matricula2]> describe alumcar;
+----------+---------+------+-----+---------+-------+
| Field    | Type    | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+-------+
| codestu  | char(3) | NO   | MUL | NULL    |       |
| codcarre | char(3) | NO   | MUL | NULL    |       |
+----------+---------+------+-----+---------+-------+
2 rows in set (0.057 sec)

MariaDB [matricula2]> describe Matricula;
+---------------+-----------------+------+-----+---------+-------+
| Field         | Type            | Null | Key | Default | Extra |
+---------------+-----------------+------+-----+---------+-------+
| codmatri      | char(3)         | NO   | PRI | NULL    |       |
| codestu       | char(3)         | NO   | MUL | NULL    |       |
| codcarre      | char(3)         | NO   |     | NULL    |       |
| codprofe      | char(3)         | NO   |     | NULL    |       |
| valorsemestre | double unsigned | NO   |     | NULL    |       |
+---------------+-----------------+------+-----+---------+-------+
5 rows in set (0.057 sec)

MariaDB [matricula2]> describe profcar;
+----------+---------+------+-----+---------+-------+
| Field    | Type    | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+-------+
| codprofe | char(3) | NO   | MUL | NULL    |       |
| codcarre | char(3) | NO   | MUL | NULL    |       |
+----------+---------+------+-----+---------+-------+
2 rows in set (0.059 sec)

MariaDB [matricula2]> select * from alumno;
+---------+------------------+-----------+----------+
| codestu | nombre           | direccion | telefono |
+---------+------------------+-----------+----------+
| 001     | Juan Tobon       | Cra 59    | 2335698  |
| 002     | Mario Gonzales   | Cra 89    | 6325984  |
| 003     | Federico Aguilar | Cra 26    | 4569782  |
| 004     | Angel Cuadrado   | Cra 44    | 6398521  |
| 005     | Catalina Escobar | Cra 78    | 4652300  |
| 006     | Paulina Borja    | Cra 45    | 4599632  |
+---------+------------------+-----------+----------+
6 rows in set (0.001 sec)

MariaDB [matricula2]> select * from carrera;
+----------+-------------------------+
| codcarre | carrera                 |
+----------+-------------------------+
| 001      | Ingenieria de Sistemas  |
| 002      | Contaduria              |
| 003      | Economia                |
| 004      | Derecho                 |
| 005      | Ingenieria Agropecuaria |
| 006      | Agronomia               |
| 007      | Ciencias de la salud    |
| 008      | Veterinaria             |
+----------+-------------------------+
8 rows in set (0.001 sec)

MariaDB [matricula2]> select * from profesor;
+----------+----------------------+-----------+----------+
| codprofe | nombre               | direccion | telefono |
+----------+----------------------+-----------+----------+
| 001      | Pablo Juan Gutierrez | cra 45-96 | 2569856  |
| 002      | Enrique Saltamontes  | cra 25-63 | 2365914  |
| 003      | Portacio Cartagena   | cra 36-01 | 4596321  |
| 004      | Federico Aguilar     | cra 56-41 | 7895624  |
| 005      | Alberto Cifuentes    | cra 20-30 | 7895002  |
| 006      | Pascual Bravo        | cra 56-41 | 5698741  |
+----------+----------------------+-----------+----------+
6 rows in set (0.001 sec)

MariaDB [matricula2]> select * from alumcar;
+---------+----------+
| codestu | codcarre |
+---------+----------+
| 001     | 002      |
| 003     | 005      |
| 005     | 001      |
| 001     | 005      |
+---------+----------+
4 rows in set (0.000 sec)

MariaDB [matricula2]> select * from matricula;
+----------+---------+----------+----------+---------------+
| codmatri | codestu | codcarre | codprofe | valorsemestre |
+----------+---------+----------+----------+---------------+
| 001      | 003     | 004      | 004      |       1800000 |
| 002      | 001     | 008      | 003      |       3500000 |
| 003      | 004     | 007      | 006      |       2800000 |
| 004      | 002     | 007      | 006      |       1950000 |
| 005      | 005     | 004      | 001      |       1800000 |
| 006      | 003     | 008      | 003      |       3500000 |
+----------+---------+----------+----------+---------------+
6 rows in set (0.053 sec)

MariaDB [matricula2]> select * from profcar;
+----------+----------+
| codprofe | codcarre |
+----------+----------+
| 005      | 003      |
| 002      | 006      |
| 005      | 005      |
| 003      | 008      |
| 005      | 001      |
| 004      | 002      |
| 003      | 001      |
| 004      | 004      |
| 001      | 004      |
| 006      | 007      |
+----------+----------+
10 rows in set (0.001 sec)

MariaDB [matricula2]> SELECT p.nombre AS profesor FROM profesor p JOIN profcar pc ON p.codprofe = pc.codprofe JOIN carrera c ON pc.codcarre = c.codcarre WHERE c.carrera = 'Ingenieria de Sistemas';
+--------------------+
| profesor           |
+--------------------+
| Alberto Cifuentes  |
| Portacio Cartagena |
+--------------------+
2 rows in set (0.001 sec)

MariaDB [matricula2]>  select alumno.nombre as 'alumno', profesor.nombre as 'profesor', carrera.carrera as 'carerra' from alumno join matricula on matricula.codestu=alumno.codestu join carrera on matricula.codcarre=carrera.codcarre join profcar on matricula.codprofe = profcar.codprofe join profesor on profcar.codprofe = profesor.codprofe where carrera.carrera ='Derecho';
+------------------+----------------------+---------+
| alumno           | profesor             | carerra |
+------------------+----------------------+---------+
| Federico Aguilar | Federico Aguilar     | Derecho |
| Federico Aguilar | Federico Aguilar     | Derecho |
| Catalina Escobar | Pablo Juan Gutierrez | Derecho |
+------------------+----------------------+---------+
3 rows in set (0.002 sec)

MariaDB [matricula2]> select alumno.nombre as 'alumno', carrera.carrera as 'carerra', matricula.valorSemestre as 'valor semestre' from alumno join matricula on matricula.codestu = alumno.codestu join carrera on matricula.codCarre = carrera.codCarre where carrera.carrera = 'Veterinaria';
+------------------+-------------+----------------+
| alumno           | carerra     | valor semestre |
+------------------+-------------+----------------+
| Juan Tobon       | Veterinaria |        3500000 |
| Federico Aguilar | Veterinaria |        3500000 |
+------------------+-------------+----------------+
2 rows in set (0.001 sec)

MariaDB [matricula2]> SELECT a.nombre FROM alumno a JOIN alumcar ac ON a.codestu = ac.codestu JOIN matricula m ON a.codestu = m.codestu JOIN profcar pc ON m.codcarre = pc.codcarre JOIN profesor p ON pc.codprofe = p.codprofe WHERE p.nombre = 'Portacio Cartagena';
+------------------+
| nombre           |
+------------------+
| Juan Tobon       |
| Juan Tobon       |
| Federico Aguilar |
+------------------+
3 rows in set (0.024 sec)

MariaDB [matricula2]> SELECT MAX(valorsemestre) AS" semestre mas alto" FROM matricula;
+-------------------+
| semestre mas alto |
+-------------------+
|           3500000 |
+-------------------+
1 row in set, 1 warning (0.059 sec)

MariaDB [matricula2]> select avg(valorsemestre)"Valor promedio matricula bb" from matricula;
+-----------------------------+
| Valor promedio matricula bb |
+-----------------------------+
|          2558333.3333333335 |
+-----------------------------+
1 row in set (0.054 sec)

MariaDB [matricula2]> SELECT nombre FROM alumno WHERE nombre LIKE 'A%' OR nombre LIKE '%r';
+------------------+
| nombre           |
+------------------+
| Federico Aguilar |
| Angel Cuadrado   |
| Catalina Escobar |
+------------------+
3 rows in set (0.055 sec)

MariaDB [matricula2]> SELECT c.carrera, SUM(m.valorsemestre) AS total_valor_semestre FROM matricula m JOIN alumcar ac ON m.codestu = ac.codestu JOIN carrera c ON ac.codcarre = c.codcarre GROUP BY c.carrera;
+-------------------------+----------------------+
| carrera                 | total_valor_semestre |
+-------------------------+----------------------+
| Contaduria              |              3500000 |
| Ingenieria Agropecuaria |              8800000 |
| Ingenieria de Sistemas  |              1800000 |
+-------------------------+----------------------+
3 rows in set (0.053 sec)

MariaDB [matricula2]>  SELECT a.nombre FROM alumno a LEFT JOIN alumcar ac ON a.codestu = ac.codestu WHERE ac.codestu IS NULL;
+----------------+
| nombre         |
+----------------+
| Mario Gonzales |
| Angel Cuadrado |
| Paulina Borja  |
+----------------+
3 rows in set (0.001 sec)

MariaDB [matricula2]> exit