consultas_BD



















PRACTICA 13
1.- mysql> select cod_mas, nom_prop,ap_prop,nom_mas,fn_mas from propietario,mascota
where propietario.id_prop=mascota.id_prop order by fn_mas;
+---------+----------+-----------+----------+------------+
| cod_mas | nom_prop | ap_prop | nom_mas | fn_mas |
+---------+----------+-----------+----------+------------+
| m_101 | valeria |luna | leopoldo | 2013-05-15 |
| m_102 | alfredo | morales | vicky | 2013-05-20 |
| m_103 | alfredo | morales | lola | 2013-07-12 |
| m_107 | lourdes | gomez | kitty | 2013-08-01 |
| m_105 | romina | hernandez | minnie | 2013-08-01 |
| m_104 | romina | hernandez | fausto | 2013-08-23 |
| m_106 | mireya | martinez | rambo | 2013-09-07 |+---------+----------+-----------+----------+------------+
7 rows in set (0.00 sec)


2.- mysql> select cod_mas,nom_prop,ap_prop,nom_mas,raza_mas,fn_mas from propietario,
mascota where propietario.id_prop=mascota.id_prop and month(fn_mas)=08;)
+---------+----------+-----------+---------+--------------+------------+
| cod_mas | nom_prop | ap_prop | nom_mas | raza_mas | fn_mas |+---------+----------+-----------+---------+--------------+------------+
| m_104 | romina | hernandez | fausto | pez beta | 2013-08-23 |
| m_105 | romina | hernandez | minnie | huron | 2013-08-01 |
| m_107 | lourdes | gomez | kitty | perro french | 2013-08-01 |
+---------+----------+-----------+---------+--------------+------------+
3 rows in set (0.00 sec)3.-mysql> select cod_mas,nom_mas,fecha_vac,costo_vac from mascota,vacuna_mascota wh
ere id_prop=id_prop and cod_mas=cod_masc;
+---------+----------+------------+-----------+
| cod_mas | nom_mas | fecha_vac | costo_vac |
+---------+----------+------------+-----------+
| m_101 | leopoldo | 2014-01-15 | 120.50 |
| m_101 | leopoldo | 2014-02-25 | 190.80 |
| m_102 | vicky | 2013-05-20| 150.45 |
| m_103 | lola | 2014-01-15 | 190.80 |
| m_104 | fausto | 2014-01-15 | 180.25 |
| m_105 | minnie | 2014-01-16 | 180.25 |
| m_105 | minnie | 2014-02-06 | 190.80 |
| m_106 | rambo | 2013-09-20 | 150.45 |
| m_106 | rambo | 2014-02-16 | 120.50 |
| m_106 | rambo | 2014-02-27 | 190.80 |
| m_107 | kitty | 2013-08-10 |150.45 |
+---------+----------+------------+-----------+
11 rows in set (0.00 sec)



4.-mysql> select cod_mas,nom_mas,fecha_vac,costo_vac from mascota,vacuna_mascota wh
ere cod_mas=cod_masc and raza_mas like"perro%";
+---------+---------+------------+-----------+
| cod_mas | nom_mas | fecha_vac | costo_vac |
+---------+---------+------------+-----------+
| m_106 | rambo | 2013-09-20| 150.45 |
| m_106 | rambo | 2014-02-16 | 120.50 |
| m_106 | rambo | 2014-02-27 | 190.80 |
| m_107 | kitty | 2013-08-10 | 150.45 |
+---------+---------+------------+-----------+
4 rows in set (0.00 sec)



5.-mysql> select sum(costo_vac) from vacuna_mascota;
+----------------+
| sum(costo_vac) |
+----------------+
| 1816.05 |
+----------------+
1 rowin set (0.09 sec)

6.- mysql> select nom_prop,ap_prop,cod_mas,nom_mas from mascota,propietario where ma
scota.id_prop=propietario.id_prop and nom_prop like"romina%" and ap_prop like"he
rnandez%";
+----------+-----------+---------+---------+
| nom_prop | ap_prop | cod_mas | nom_mas |
+----------+-----------+---------+---------+
| romina | hernandez | m_104 | fausto |
| romina |hernandez | m_105 | minnie |
+----------+-----------+---------+---------+
2 rows in set (0.00 sec)

7.-mysql> select fecha_vac,nom_vac,nom_mas,nom_prop,ap_prop from vacuna_mascota,mas
cota,propietario where cod_mas=cod_masc and mascota.id_prop=propietario.id_prop;

+------------+-----------------+----------+----------+-----------+
| fecha_vac | nom_vac | nom_mas | nom_prop |...