Tarea. Vistas

1.- create view toreropre as select a.Nombre,b.Nom_feria,
b.Orejas,b.Rabo,b.Salida from torero a, premio b where a.RFC_torero=b.RFC_torero order by b.Nom_feria;

2.-create view ganade as select a.Cod_ganaderia,b.Nom_ganaderia,a.Nom_feria,count(*) as Total from toro a, ganaderia b where a.Cod_ganaderia=b.Cod_ganaderia
group by a.Cod_ganaderia,a.Nom_feria order by a.Nom_feria;

3.-create view apodado as select c.RFC_apoderado,c.Nombre,a.Nom_feria,count(*) as Total from premio a, torero b, apoderado c
where a.RFC_torero=b.RFC_torero and b.RFC_apoderado=c.RFC_apoderado group by a.Nom_feria, c.RFC_apoderado order by a.Nom_feria;

4.- create view edad as select Nombre,
(year(Anio)- year (Anio_nacimiento)) -(right(Anio,5) as Edad,month(Anio_nacimiento) as Mes from toro;

5.-create view padrino as select a.RFC_torero,a.Nombre,b.Nombre as Nombre_padrino from torero a, torero b where
b.RFC_torero=a.RFC_padrino group by a.Nombre,b.RFC_torero;