Microsoft Windows [Versión 10.0.22621.2506]
(c) Microsoft Corporation. Todos los derechos reservados.

C:\Users\Harold Martinez>cd/xampp/mysql/bin

C:\xampp\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.4.24-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

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

MariaDB [(none)]> use Academia;
Database changed
MariaDB [Academia]> create table estudiante(identificacion varchar(10) not null primary key, 
    -> nombre varchar(30) not null,     
    -> estadocivil enum('soltero','casado', 'union libre', 'divorciado', 'viudo') not null,  
    -> fechamatrucula date);
Query OK, 0 rows affected (0.007 sec)

MariaDB [Academia]> insert into estudiante(identificacion, nombre, estadocivil, fechamatrucula) values('2040','Elizabeth Cano','casado','2013-01-01');
Query OK, 1 row affected (0.002 sec)

MariaDB [Academia]> insert into estudiante(identificacion, nombre, estadocivil, fechamatrucula) values('2140','Denis Rico','divorciado','2013-02-18');
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into estudiante(identificacion, nombre, estadocivil, fechamatrucula) values('2341','Alfredo Lara','casado','2014-06-20');
Query OK, 1 row affected (0.002 sec)

MariaDB [Academia]> insert into estudiante(identificacion, nombre, estadocivil, fechamatrucula) values('1840','Armando Casas','viudo','2014-01-28');
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into estudiante(identificacion, nombre, estadocivil, fechamatrucula) values('2044','Eliodoro Puerta','casado','2015-07-20');
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into estudiante(identificacion, nombre, estadocivil, fechamatrucula) values('2314','Mariana Salinas','casado','2016-06-06');
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into estudiante(identificacion, nombre, estadocivil, fechamatrucula) values('2318','Benito Céspedes','casado','2016-06-30');
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into estudiante(identificacion, nombre, estadocivil, fechamatrucula) values('2045','Roberto Jiménez','soltero','2017-01-30');
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> select fechamatrucula as Fecha, count(*) as Cantidad from estudiante group by fechamatrucula;
+------------+----------+
| Fecha      | Cantidad |
+------------+----------+
| 2013-01-01 |        1 |
| 2013-02-18 |        1 |
| 2014-01-28 |        1 |
| 2014-06-20 |        1 |
| 2015-07-20 |        1 |
| 2016-06-06 |        1 |
| 2016-06-30 |        1 |
| 2017-01-30 |        1 |
+------------+----------+
8 rows in set (0.001 sec)

MariaDB [Academia]> Create table registrocursos
    -> select fechamatrucula as Fecha, count(*) as Cantidad from estudiante group by fechamatrucula;
Query OK, 8 rows affected (0.010 sec)
Records: 8  Duplicates: 0  Warnings: 0

MariaDB [Academia]> create table planilla(codigo varchar(12) not null primary key,      
    -> carnet varchar(12) not null,     
    -> nombre varchar(30) not null,    
    -> nota decimal (4,2) unsigned );
Query OK, 0 rows affected (0.006 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('1','010','Soledad Ospina',4.0);
Query OK, 1 row affected (0.002 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('2','011','Marta Salazar',1.5);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('3','012','Margarita Sol',1.5);
Query OK, 1 row affected (0.002 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('4','013','Fabian Juda',4.0);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('5','010','Soledad Ospina',2.5);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('6','011','Marta Salazar',1.0);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('7','012','Margarita Sol',5.0);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('8','013','Fabian Juda',4.5);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('9','010','Soledad Ospina',2.0);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('10','010','Soledad Ospina',3.8);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('11','011','Marta Salazar',3.8);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into planilla(codigo, carnet, nombre, nota) values('12','013','Fabian Juda',5.0);
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> select carnet as Carnet, avg(nota)as Promedio from planilla group by Carnet;
+--------+----------+
| Carnet | Promedio |
+--------+----------+
| 010    | 3.075000 |
| 011    | 2.100000 |
| 012    | 3.250000 |
| 013    | 4.500000 |
+--------+----------+
4 rows in set (0.000 sec)

MariaDB [Academia]> Create table promedio
    -> select carnet as Carnet, avg(nota)as Promedio from planilla group by Carnet;
Query OK, 4 rows affected (0.009 sec)
Records: 4  Duplicates: 0  Warnings: 0

MariaDB [Academia]> select carnet as Carnet, nombre as Nombre, avg(nota) >= 4.0 as Aprobados from planilla group by Carnet;
+--------+----------------+-----------+
| Carnet | Nombre         | Aprobados |
+--------+----------------+-----------+
| 010    | Soledad Ospina |         0 |
| 011    | Marta Salazar  |         0 |
| 012    | Margarita Sol  |         0 |
| 013    | Fabian Juda    |         1 |
+--------+----------------+-----------+
4 rows in set (0.000 sec)

MariaDB [Academia]> select carnet as Carnet, nombre as Nombre from planilla group by Carnet;
+--------+----------------+
| Carnet | Nombre         |
+--------+----------------+
| 010    | Soledad Ospina |
| 011    | Marta Salazar  |
| 012    | Margarita Sol  |
| 013    | Fabian Juda    |
+--------+----------------+
4 rows in set (0.000 sec)

MariaDB [Academia]> SELECT carnet AS Carnet, nombre AS Nombre, AVG(nota) >= 4.0 AS Aprobados
    -> FROM planilla
    -> GROUP BY carnet, nombre
    -> HAVING AVG(nota) >= 4.0;
+--------+-------------+-----------+
| Carnet | Nombre      | Aprobados |
+--------+-------------+-----------+
| 013    | Fabian Juda |         1 |
+--------+-------------+-----------+
1 row in set (0.001 sec)

MariaDB [Academia]> show tables;
+--------------------+
| Tables_in_academia |
+--------------------+
| estudiante         |
| planilla           |
| promedio           |
| registrocursos     |
+--------------------+
4 rows in set (0.001 sec)

MariaDB [Academia]> Create table alumno_aprobado
    -> SELECT carnet AS Carnet, nombre AS Nombre, AVG(nota) >= 4.0 AS Aprobados
    -> FROM planilla
    -> GROUP BY carnet, nombre
    -> HAVING AVG(nota) >= 4.0;
Query OK, 1 row affected (0.008 sec)
Records: 1  Duplicates: 0  Warnings: 0

MariaDB [Academia]> show tables;
+--------------------+
| Tables_in_academia |
+--------------------+
| alumno_aprobado    |
| estudiante         |
| planilla           |
| promedio           |
| registrocursos     |
+--------------------+
5 rows in set (0.001 sec)

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

MariaDB [Academia]> insert into porcentaje_calificacion(codpor, descrip) values('01','Parcial 1');
Query OK, 1 row affected (0.002 sec)

MariaDB [Academia]> insert into porcentaje_calificacion(codpor, descrip) values('02','Parcial 2');
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into porcentaje_calificacion(codpor, descrip) values('03','Seguimiento');
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> insert into porcentaje_calificacion(codpor, descrip) values('04','Parcial final');
Query OK, 1 row affected (0.001 sec)

MariaDB [Academia]> exit
Bye

C:\xampp\mysql\bin>mysqldump -B -uroot -p Academia>c:/xampp/Academia.sql
Enter password:

C:\xampp\mysql\bin>