MariaDB [matricula]> select e.* from estudiante as e left join matricular as m on e.carnet=m.carnet where e.estado_civil='soltero'group by carnet;
+--------+------------------+------+--------------+-----------+--------+-----------------------+
| carnet | nombre           | edad | estado_civil | sexo      | hobby  | dias_estudio          |
+--------+------------------+------+--------------+-----------+--------+-----------------------+
| 004    | Carlos Agudelo   |   30 | soltero      | masculino | leer   | Lunes,Viernes         |
| 006    | Javier Montesino |   38 | soltero      | masculino | viajar | Lunes,Jueves,Viernes  |
| 007    | Luis Alvarez     |   38 | soltero      | masculino | bailar | Martes,Jueves,Viernes |
+--------+------------------+------+--------------+-----------+--------+-----------------------+
3 rows in set (0.001 sec)

MariaDB [matricula]> Select e.nombre 'Nombre Estudiante' , a.nombre 'Asignatura', j.descripcion 'jornada' from estudiante e inner join asignatura a inner join jornada j inner join matricular m inner join estudiante_asignatura ea inner join estudiante_jornada ej on e.carnet=ea.carnet and e.carnet=ej.carnet and e.carnet=m.carnet and j.idj=m.idj where a.nombre='java' and j.descripcion='Ma ana'group by e.carnet;
+-------------------+------------+---------+
| Nombre Estudiante | Asignatura | jornada |
+-------------------+------------+---------+
| Juan D az         | Java       | Ma ana  |
| Mar a Parra       | Java       | Ma ana  |
| Hern n R os       | Java       | Ma ana  |
| Javier Montesino  | Java       | Ma ana  |
| Luis Alvarez      | Java       | Ma ana  |
| Rosa Pereira      | Java       | Ma ana  |
+-------------------+------------+---------+
6 rows in set (0.001 sec)

MariaDB [matricula]> select e.nombre, e.estado_civil'Estado Civil', e.hobby from estudiante as e right join matricular as m on e.carnet=m.carnet where e.estado_civil='viudo' and e.hobby='leer' group by e.carnet;
+--------------+--------------+-------+
| nombre       | Estado Civil | hobby |
+--------------+--------------+-------+
| Gloria Aroma | viudo        | leer  |
+--------------+--------------+-------+
1 row in set (0.000 sec)

MariaDB [matricula]> Select p.nombre 'Nombre Profesor', a.nombre 'Asignatura' from matricular m join profesor p join asignatura a on m.cod=p.cod and a.id=m.id  where a.nombre='Base de Datos' group by p.nombre;
+----------------------+---------------+
| Nombre Profesor      | Asignatura    |
+----------------------+---------------+
| Javier Ospina Moreno | Base de Datos |
| M nica Mar a C rdoba | Base de Datos |
+----------------------+---------------+
2 rows in set (0.001 sec)

MariaDB [matricula]> select e.* from estudiante as e left join matricular as m on e.carnet = m.carnet where e.estado_civil = 'casado' group by e.carnet;
+--------+--------------+------+--------------+-----------+---------+-----------------------+
| carnet | nombre       | edad | estado_civil | sexo      | hobby   | dias_estudio          |
+--------+--------------+------+--------------+-----------+---------+-----------------------+
| 001    | Juan D az    |   45 | casado       | masculino | caminar | Martes,Jueves,Viernes |
| 003    | Sof a L pez  |   35 | casado       | femenino  | caminar | Martes,Jueves,Viernes |
| 009    | Jazmin Aroma |   25 | casado       | femenino  | cantar  | Martes,Jueves,Viernes |
+--------+--------------+------+--------------+-----------+---------+-----------------------+
3 rows in set (0.001 sec)

MariaDB [matricula]> select e.nombre 'Nombre Estudiante', a.nombre 'Asignatura', j.descripcion 'Jornada' from estudiante e inner join asignatura a inner join jornada j inner join matricular m inner join estudiante_asignatura ea inner join estudiante_jornada ej on e.carnet = ea.carnet and e.carnet = ej.carnet and e.carnet = m.carnet and j.idj = m.idj where a.nombre = 'Redes' and j.descripcion = 'Tarde' group by e.carnet;
+-------------------+------------+---------+
| Nombre Estudiante | Asignatura | Jornada |
+-------------------+------------+---------+
| Sof a L pez       | Redes      | Tarde   |
| Jazmin Aroma      | Redes      | Tarde   |
| Gloria Aroma      | Redes      | Tarde   |
+-------------------+------------+---------+
3 rows in set (0.000 sec)

MariaDB [matricula]> MariaDB [matricula]> select e.nombre, e.estado_civil 'Estado Civil', e.hobby from estudiante as e right join matricular as m on e.carnet = m.carnet where e.estado_civil = 'divorciado' and e.hobby = 'escuchar m sica' group by e.carnet;
Empty set (0.002 sec)

MariaDB [matricula]> select p.nombre 'Nombre Profesor', a.nombre 'Asignatura' from matricular m join profesor p join asignatura a on m.cod = p.cod and a.id = m.id where a.nombre = 'Programaci n Web' group by p.nombre;
Empty set (0.002 sec)

MariaDB [matricula]> exit