mysql> select * from estudiantes where edad>20;
+-------------------+-----------------------------+-------------------+------------+---------------------+------+-----------------+
| codigo_estudiante | nombre                      | direccion         | telefono   | email               | edad | valor_matricula |
+-------------------+-----------------------------+-------------------+------------+---------------------+------+-----------------+
| est03             | Carlos Mario Oquendo        | Cll 5 # 32 - 20   | 2145368742 | camaque@hotmail.com |   25 |           50000 |
| est05             | Juan Esteban Cardona Osorio | Cra 21 # 150 - 10 | 2147483647 | jucae@hotmail.com   |   22 |          300000 |
+-------------------+-----------------------------+-------------------+------------+---------------------+------+-----------------+
2 rows in set (0.00 sec)

mysql> select * from estudiantes where edad<20;
+-------------------+-------------------+----------------------+------------+--------------------+------+-----------------+
| codigo_estudiante | nombre            | direccion            | telefono   | email              | edad | valor_matricula |
+-------------------+-------------------+----------------------+------------+--------------------+------+-----------------+
| est02             | Melani Suarez     | Cra 20 # 15 - 46     | 2147483647 | melona@hotmail.com |   15 |           25000 |
| est04             | Felipe Cardona    | Calle 11 # 15 - 30   |    2154123 | feca15@gmail.com   |   17 |          150000 |
| est06             | Maria Camila Pe¤a | Transversal 5ta      |    3205489 | mariaca@live.com   |   16 |           10000 |
| est08             | Santiago Hurtado  | Cra 8 # 5 - 3        | 2147483647 | hurtasa@gmail.com  |   12 |           98500 |
| est10             | Liliana Mejia     | Cra 15 BB # 51 A - 3 |    3501423 | lili@hotmail.com   |   15 |          200000 |
+-------------------+-------------------+----------------------+------------+--------------------+------+-----------------+
5 rows in set (0.00 sec)

mysql> select codigo_estudiante,nombre,valor_matricula from estudiantes where valor_matricula>250000;
+-------------------+-----------------------------+-----------------+
| codigo_estudiante | nombre                      | valor_matricula |
+-------------------+-----------------------------+-----------------+
| est01             | Santiago Lopez              |          500000 |
| est05             | Juan Esteban Cardona Osorio |          300000 |
+-------------------+-----------------------------+-----------------+
2 rows in set (0.02 sec)

mysql> delete from estudiantes codigo_estudiante="est01";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'codigo_estudiante="est01"' at line 1
mysql> delete from estudiantes codigo_estudiante="est10";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'codigo_estudiante="est10"' at line 1
mysql> delete from estudiantes where codigo_estudiante="est10";
Query OK, 1 row affected (0.08 sec)

mysql> select * from estudiantes;
+-------------------+-----------------------------+-------------------------+------------+---------------------+------+-----------------+
| codigo_estudiante | nombre                      | direccion               | telefono   | email               | edad | valor_matricula |
+-------------------+-----------------------------+-------------------------+------------+---------------------+------+-----------------+
| est01             | Santiago Lopez              | Cll 15 # 25 - 30        |    2547895 | salo@colegio.com    |   20 |          500000 |
| est02             | Melani Suarez               | Cra 20 # 15 - 46        | 2147483647 | melona@hotmail.com  |   15 |           25000 |
| est03             | Carlos Mario Oquendo        | Cll 5 # 32 - 20         | 2145368742 | camaque@hotmail.com |   25 |           50000 |
| est04             | Felipe Cardona              | Calle 11 # 15 - 30      |    2154123 | feca15@gmail.com    |   17 |          150000 |
| est05             | Juan Esteban Cardona Osorio | Cra 21 # 150 - 10       | 2147483647 | jucae@hotmail.com   |   22 |          300000 |
| est06             | Maria Camila Pe¤a           | Transversal 5ta         |    3205489 | mariaca@live.com    |   16 |           10000 |
| est07             | Sonia Carolina Aristizabal  | Diagonal B 50 # 15 - 15 |    4568721 | laquesonia@live.com |   20 |           75000 |
| est08             | Santiago Hurtado            | Cra 8 # 5 - 3           | 2147483647 | hurtasa@gmail.com   |   12 |           98500 |
| est09             | Sandra Caceres              | Cll 80 # 51 - 13        |    2156598 | cacerita@gmail.com  |   20 |           34300 |
+-------------------+-----------------------------+-------------------------+------------+---------------------+------+-----------------+
9 rows in set (0.00 sec)

mysql> select sum(valor_matricula) from estudiantes;
+----------------------+
| sum(valor_matricula) |
+----------------------+
|              1242800 |
+----------------------+
1 row in set (0.02 sec)

mysql> select sum(valor_matricula) as "Total pago por la matricula" from estudiantes;
+-----------------------------+
| Total pago por la matricula |
+-----------------------------+
|                     1242800 |
+-----------------------------+
1 row in set (0.02 sec)

mysql> select max(edad) as "La mayor edad es:" from estdiantes;
ERROR 1146 (42S02): Table 'matriculas.estdiantes' doesn't exist
mysql> select max(edad) as "La mayor edad es:" from estudiantes;
+-------------------+
| La mayor edad es: |
+-------------------+
|                25 |
+-------------------+
1 row in set (0.00 sec)

mysql> select min(edad as "La menor edad es:" from estudiantes;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as "La menor edad es:" from estudiantes' at line 1
mysql> select min(edad) as "La menor edad es:" from estudiantes;
+-------------------+
| La menor edad es: |
+-------------------+
|                12 |
+-------------------+
1 row in set (0.00 sec)

mysql> select avg(edad) as "La edad promedio es:" from estudiantes;
+----------------------+
| La edad promedio es: |
+----------------------+
|              18.5556 |
+----------------------+
1 row in set (0.00 sec)

mysql> select avg(valor_matricula) as "El promedio de pagos es de:" from estudiantes;
+-----------------------------+
| El promedio de pagos es de: |
+-----------------------------+
|          138088.88888888888 |
+-----------------------------+
1 row in set (0.00 sec)

mysql> select count(edad) as "El total de registros" from estudiantes;
+-----------------------+
| El total de registros |
+-----------------------+
|                     9 |
+-----------------------+
1 row in set (0.00 sec)

mysql> select count(nombre) as "El total de registros es de:" from estudiantes;
+------------------------------+
| El total de registros es de: |
+------------------------------+
|                            9 |
+------------------------------+
1 row in set (0.00 sec)

mysql> exit