MariaDB [(none)]> create database academia1;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| academia           |
| academia1          |
| academico          |
| aplicacion_cadena  |
| comercial          |
| consulta_externa   |
| facturacion        |
| fechas             |
| fechas001          |
| information_schema |
| institucion        |
| institucion1       |
| libreria           |
| matricula2         |
| mysql              |
| performance_schema |
| phpmyadmin         |
| secundaria         |
| test               |
| urgencias          |
+--------------------+
20 rows in set (0.00 sec)

MariaDB [(none)]> use academia1;
Database changed
MariaDB [academia1]> create table estudiante
    -> (identificacion char(10) primary key,
    -> nombre char(30),
    -> estadocivil enum(soltero,casado,union libre, divorciado,viudo)
    -> fechamatricula date);
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 'soltero,casado,union libre, divorciado,viudo)
fechamatricula date)' at line 4
MariaDB [academia1]> create table estudiante
    -> (identificacion char(10) primary key,
    -> nombre char(30),
    -> estadocivil enum(soltero,casado,union libre, divorciado,viudo),
    -> fechamatricula date);
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 'soltero,casado,union libre, divorciado,viudo),
fechamatricula date)' at line 4
MariaDB [academia1]> create table estudiante
    -> (identificacion char(10) primary key,
    -> nombre char(30),
    -> estadocivil enum('soltero','casado','union libre','divorciado','viudo'),
    -> fechamatricula date);
Query OK, 0 rows affected (0.37 sec)

MariaDB [academia1]> describe estudiante;
+----------------+-------------------------------------------------------------+------+-----+---------+-------+
| Field          | Type                                                        | Null | Key | Default | Extra |
+----------------+-------------------------------------------------------------+------+-----+---------+-------+
| identificacion | char(10)                                                    | NO   | PRI | NULL    |       |
| nombre         | char(30)                                                    | YES  |     | NULL    |       |
| estadocivil    | enum('soltero','casado','union libre','divorciado','viudo') | YES  |     | NULL    |       |
| fechamatricula | date                                                        | YES  |     | NULL    |       |
+----------------+-------------------------------------------------------------+------+-----+---------+-------+
4 rows in set (0.07 sec)

MariaDB [academia1]> insert into estudiante values('2040','Elizabeth Cano','casado','2013/1/1');
Query OK, 1 row affected (0.06 sec)

MariaDB [academia1]> insert into estudiante values('2140','Denis Rico','divorciado','2013/2/18');
Query OK, 1 row affected (0.10 sec)

MariaDB [academia1]> insert into estudiante values('2341','Alfredo Lara','casado','2014/6/20');
Query OK, 1 row affected (0.08 sec)

MariaDB [academia1]> insert into estudiante values('1840','Armando Casas','viudo','2014/1/28');
Query OK, 1 row affected (0.07 sec)

MariaDB [academia1]> insert into estudiante values('2044','Eliodoro Puerta','casado','2015/7/20');
Query OK, 1 row affected (0.06 sec)

MariaDB [academia1]>  insert into estudiante values('2314','Mariana Salinas','casado','2016/6/6');
Query OK, 1 row affected (0.10 sec)

MariaDB [academia1]>  insert into estudiante values('2318','Benito C‚spedes','casado','2016/6/30');
Query OK, 1 row affected (0.10 sec)

MariaDB [academia1]> insert into estudiante values('2045','Roberto Jim‚nez','soltero','2017/1/30');
Query OK, 1 row affected (0.10 sec)

MariaDB [academia1]> select * from estudiante;
+----------------+-----------------+-------------+----------------+
| identificacion | nombre          | estadocivil | fechamatricula |
+----------------+-----------------+-------------+----------------+
| 1840           | Armando Casas   | viudo       | 2014-01-28     |
| 2040           | Elizabeth Cano  | casado      | 2013-01-01     |
| 2044           | Eliodoro Puerta | casado      | 2015-07-20     |
| 2045           | Roberto Jim‚nez | soltero     | 2017-01-30     |
| 2140           | Denis Rico      | divorciado  | 2013-02-18     |
| 2314           | Mariana Salinas | casado      | 2016-06-06     |
| 2318           | Benito C‚spedes | casado      | 2016-06-30     |
| 2341           | Alfredo Lara    | casado      | 2014-06-20     |
+----------------+-----------------+-------------+----------------+
8 rows in set (0.00 sec)

MariaDB [academia1]> create table registrocursos
    -> select count(fechamatricula) as registrospora¤o
    -> from estudiante;
Query OK, 1 row affected (0.36 sec)
Records: 1  Duplicates: 0  Warnings: 0

MariaDB [academia1]> describe registrocursos;
+-----------------+------------+------+-----+---------+-------+
| Field           | Type       | Null | Key | Default | Extra |
+-----------------+------------+------+-----+---------+-------+
| registrospora¤o | bigint(21) | NO   |     | NULL    |       |
+-----------------+------------+------+-----+---------+-------+
1 row in set (0.03 sec)

MariaDB [academia1]> show tables;
+---------------------+
| Tables_in_academia1 |
+---------------------+
| estudiante          |
| registrocursos      |
+---------------------+
2 rows in set (0.00 sec)

MariaDB [academia1]> drop table registrocursos;
Query OK, 0 rows affected (0.28 sec)

MariaDB [academia1]> show tables;
+---------------------+
| Tables_in_academia1 |
+---------------------+
| estudiante          |
+---------------------+
1 row in set (0.00 sec)

MariaDB [academia1]> select year(fechamatricula) as a¤o,
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> 
    -> ;
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 [academia1]> create table registrocursos
    -> select year(fechamatricula) as a¤o,
    -> count(year(fechamatricula)) as cantidad;
ERROR 1054 (42S22): Unknown column 'fechamatricula' in 'field list'
MariaDB [academia1]> create table registrocursos
    -> select year(fechamatricula) as a¤o,
    -> count(year(fechamatricula)) as cantidad
    -> from estudiante
    -> group by year(fechamatricula);
Query OK, 5 rows affected (0.33 sec)
Records: 5  Duplicates: 0  Warnings: 0

MariaDB [academia1]> select * from registrocursos;
+------+----------+
| a¤o  | cantidad |
+------+----------+
| 2013 |        2 |
| 2014 |        2 |
| 2015 |        1 |
| 2016 |        2 |
| 2017 |        1 |
+------+----------+
5 rows in set (0.00 sec)

MariaDB [academia1]> create table planilla
    -> (carnet(12),
    -> nombre char(30),
    -> nota decimal unsigned);
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 '(12),
nombre char(30),
nota decimal unsigned)' at line 2
MariaDB [academia1]> create table planilla
    -> (carnet char(12),
    -> nombre char(30),
    -> nota decimal unsigned);
Query OK, 0 rows affected (0.24 sec)

MariaDB [academia1]> show planilla;
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 'planilla' at line 1
MariaDB [academia1]> show tables;
+---------------------+
| Tables_in_academia1 |
+---------------------+
| estudiante          |
| planilla            |
| registrocursos      |
+---------------------+
3 rows in set (0.00 sec)

MariaDB [academia1]> insert into planilla values('010','Soledad Ospina',4.0);
Query OK, 1 row affected (0.05 sec)

MariaDB [academia1]> insert into planilla values('011','Marta Salazar',1.5);
Query OK, 1 row affected, 1 warning (0.08 sec)

MariaDB [academia1]> insert into planilla values('012','Margarita Sol',1.5);
Query OK, 1 row affected, 1 warning (0.07 sec)

MariaDB [academia1]> insert into planilla values('013','Fabian Juda',4.0);
Query OK, 1 row affected (0.09 sec)

MariaDB [academia1]> insert into planilla values('010','Soledad Ospina',2.5);
Query OK, 1 row affected, 1 warning (0.08 sec)

MariaDB [academia1]> insert into planilla values('011','Marta Salazar',1.0);
Query OK, 1 row affected (0.09 sec)

MariaDB [academia1]> insert into planilla values('012','Margarita Sol',5.0);
Query OK, 1 row affected (0.08 sec)

MariaDB [academia1]> insert into planilla values('013','Fabian Juda',4.5);
Query OK, 1 row affected, 1 warning (0.09 sec)

MariaDB [academia1]> insert into planilla values('010','Soledad Ospina',2.0);
Query OK, 1 row affected (0.07 sec)

MariaDB [academia1]> insert into planilla values('010','Soledad Ospina',3.8);
Query OK, 1 row affected, 1 warning (0.05 sec)

MariaDB [academia1]> insert into planilla values('011','Marta Salazar',3.8);
Query OK, 1 row affected, 1 warning (0.04 sec)

MariaDB [academia1]> insert into planilla values('013','Fabian Juda',5.0);
Query OK, 1 row affected (0.09 sec)

MariaDB [academia1]> describe planilla;
+--------+------------------------+------+-----+---------+-------+
| Field  | Type                   | Null | Key | Default | Extra |
+--------+------------------------+------+-----+---------+-------+
| carnet | char(12)               | YES  |     | NULL    |       |
| nombre | char(30)               | YES  |     | NULL    |       |
| nota   | decimal(10,0) unsigned | YES  |     | NULL    |       |
+--------+------------------------+------+-----+---------+-------+
3 rows in set (0.07 sec)

MariaDB [academia1]> select * from promedio;
ERROR 1146 (42S02): Table 'academia1.promedio' doesn't exist
MariaDB [academia1]> create table promedio
    -> select carnet, avg(nota) as promedio
    -> from planilla
    -> group by carnet;
Query OK, 4 rows affected, 2 warnings (0.22 sec)
Records: 4  Duplicates: 0  Warnings: 2

MariaDB [academia1]> select * from promedio;
+--------+----------+
| carnet | promedio |
+--------+----------+
| 010    |   3.2500 |
| 011    |   2.3333 |
| 012    |   3.5000 |
| 013    |   4.6667 |
+--------+----------+
4 rows in set (0.00 sec)

MariaDB [academia1]>  create table alumno_aprobado
    -> select pl.carnet, pl.nombre, avg(nota)
    -> from planilla as pl
    -> join promedio as pro
    -> on pl.carnet=pro.carnet
    -> where pro.promedio>=4
    -> group by carnet;
Query OK, 1 row affected, 1 warning (0.35 sec)
Records: 1  Duplicates: 0  Warnings: 1

MariaDB [academia1]> describe table alumno_aprobado;
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 alumno_aprobado' at line 1
MariaDB [academia1]> describe alumno_aprobado;
+-----------+---------------+------+-----+---------+-------+
| Field     | Type          | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------+-------+
| carnet    | char(12)      | YES  |     | NULL    |       |
| nombre    | char(30)      | YES  |     | NULL    |       |
| avg(nota) | decimal(14,4) | YES  |     | NULL    |       |
+-----------+---------------+------+-----+---------+-------+
3 rows in set (0.06 sec)

MariaDB [academia1]> select * from alumno_aprobado;
+--------+-------------+-----------+
| carnet | nombre      | avg(nota) |
+--------+-------------+-----------+
| 013    | Fabian Juda |    4.6667 |
+--------+-------------+-----------+
1 row in set (0.00 sec)

MariaDB [academia1]> create table porcentaje_calificacion
    -> (codpor varchar(5)not null primary key,
    -> descrip varchar(30)not null);
Query OK, 0 rows affected (0.29 sec)

MariaDB [academia1]> describe porcentaje_calificacion;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| codpor  | varchar(5)  | NO   | PRI | NULL    |       |
| descrip | varchar(30) | NO   |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
2 rows in set (0.07 sec)

MariaDB [academia1]> insert into porcentaje_calificacion values('01','Parcial 1');
Query OK, 1 row affected (0.05 sec)

MariaDB [academia1]> insert into porcentaje_calificacion values('02','Parcial 2');
Query OK, 1 row affected (0.05 sec)

MariaDB [academia1]> insert into porcentaje_calificacion values('03','Seguimiento');
Query OK, 1 row affected (0.08 sec)

MariaDB [academia1]> insert into porcentaje_calificacion values('04','Parcial Final');
Query OK, 1 row affected (0.09 sec)

MariaDB [academia1]> select * from porcentaje_calificacion;
+--------+---------------+
| codpor | descrip       |
+--------+---------------+
| 01     | Parcial 1     |
| 02     | Parcial 2     |
| 03     | Seguimiento   |
| 04     | Parcial Final |
+--------+---------------+
4 rows in set (0.00 sec)

MariaDB [academia1]> create table planilla1
    -> (carnet char(12),nombrechar(30),
    -> notapromedio decimal(4,1)unsigned,
    -> codpor varchar(5)not null);
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 '(30),
notapromedio decimal(4,1)unsigned,
codpor varchar(5)not null)' at line 2
MariaDB [academia1]> create table planilla1
    -> (carnet char(12),nombre char(30),
    -> notapromedio decimal(4,1)unsigned,
    -> codpor varchar(5)not null);
Query OK, 0 rows affected (0.31 sec)

MariaDB [academia1]> describe planilla1;
+--------------+-----------------------+------+-----+---------+-------+
| Field        | Type                  | Null | Key | Default | Extra |
+--------------+-----------------------+------+-----+---------+-------+
| carnet       | char(12)              | YES  |     | NULL    |       |
| nombre       | char(30)              | YES  |     | NULL    |       |
| notapromedio | decimal(4,1) unsigned | YES  |     | NULL    |       |
| codpor       | varchar(5)            | NO   |     | NULL    |       |
+--------------+-----------------------+------+-----+---------+-------+
4 rows in set (0.07 sec)

MariaDB [academia1]> insert into planilla1(carnet,nombre,notapromedio,codpor)
    -> select '05','Edilberto Parra',3.8,codpor
    -> from porcentaje_calificacion
    -> where descrip='Parcial Final';
Query OK, 1 row affected (0.08 sec)
Records: 1  Duplicates: 0  Warnings: 0

MariaDB [academia1]> select * from planilla1;
+--------+-----------------+--------------+--------+
| carnet | nombre          | notapromedio | codpor |
+--------+-----------------+--------------+--------+
| 05     | Edilberto Parra |          3.8 | 04     |
+--------+-----------------+--------------+--------+
1 row in set (0.00 sec)

MariaDB [academia1]> exit