Consultas De Base De Dato

/*CONSULTA DEL AUTOR QUE MAS ANIMES Y CUANTOS SON */
select p.nomb as autor,a.nomb as anime, ca.comen as comentario
from persona as p, creado as cr, anime as a, comentarioa as ca
wherep.cve_per=cr.cve_autor and cr.cve_anime=a.cve_anime and a.cve_anime=ca.cve_anime and cve_autor in (select MAX (cve_autor) from creado )

select p.nomb as autor,a.nomb as anime
from persona as p, creado asc, anime as a
where p.cve_per=c.cve_autor and c.cve_anime=a.cve_anime

/*UTILIZACION DE CATCH Y WHEN EN CULAQUIER TABLA*/
select case p.cve_per when 1 then 'm'
when 2 then 'm'
else 'null' endas nombre,
case c.cve_calle when 2 then 3
when 4 then 6 else 1
end as calle
from persona as p
inner join calle as c
on p.cve_calle=c.cve_calle

/*CREACION DE TRIGER EN LA TABLA PERSONA ,PRODUCTORA Y GENERO*/
select *from anime
select *from productora
select *from persona

--PRODUCTORA
create trigger delete_update
on productora after update,delete
as raiserror (1,1,1,1)

updatepersona
set nomb='marcos'
where nomb ='noris'

select * from persona
delete from productora

--PERSONA
create trigger update_delete_persona
on persona INSTEAD OF update,delete
as raiserror(1,1,1,'antigraviti','animax','word',12,5,5,8,3)

delete from persona

drop trigger actualiza

--GENERO
create trigger actualiza
on genero INSTEAD OF update,delete
as raiserror(1,1,1,'aventura')

DELETE FROM GENERO

drop trigger actualiza

/*CONSULTA DE NOMBRE COMPLETO DEL AUTOR, EDAD,ANIME Y MANGA QUE A CREADO Y DOMICILIO*/

select p.nomb+' '+p.ap_pa+' '+p.ap_ma asAutor,p.edad as edad, a.nomb as anime,m.nomb as manga,c.nomb+', '+col.nomb+', '+ci.nomb+', '+e.nomb as domicilio
from persona as p
inner join creado as cr on p.cve_per=cr.cve_autor
inner join anime as aon cr.cve_anime=a.cve_anime
inner join manga as m on cr.cve_manga=m.cve_manga
inner join calle as c on p.cve_calle=c.cve_calle
inner join colonia as col on p.cve_col=col.cve_col
inner join...