Secuencias en base de datos

select * from inventarios;

select *from productos;

select p.pronombre as producto,sum(i.inventrada)as entrada from productos p

inner join inventarios i on p.procodigo=i.procodigo group by p.pronombre;

select p.pronombre as producto,sum(i.invsalida)as salida from productos p

inner join inventarios i on p.procodigo=i.procodigo group by p.pronombre;

select p.promarca as producto,avg(i.inventrada)as promedio_entrada from productos p

inner join inventarios i on p.procodigo=i.procodigo group by p.promarca;

select count(invtipfac)as ventas from inventarios where invtipfac like'Fv%';

select p.promarca as marca ,max(i.inventrada)as maxima_entrada from productos p

inner join inventarios i  on promarca='kingson' and p.procodigo=i.procodigo group by p.promarca;

select p.pronombre  as nombre ,min(i.invsalida) as minima_salida from productos p

inner join inventarios i on p.procodigo=i.procodigo group by p.pronombre;

select sum(i.inventrada) as total_entrada,p.pronombre  as memoria_ram from inventarios i

inner join productos p on i.procodigo=p.procodigo where p.pronombre like'mem%' group by p.pronombre;

select p.pronombre as producto ,sum(i.inventrada) as entrada ,sum(i.invsalida) as salida ,(sum(i.inventrada)-sum(i.invsalida)) as saldo

from productos p inner join inventarios i on p.procodigo=i.procodigo group by p.pronombre;

select count(invtipfac)as total_De_compra from inventarios where invtipfac like'Fc%';

describe productos;

alter table productos modify pronombre varchar2(50);

create sequence sec_inventarios start with 1 increment by 1;

select  sec_inventarios .nextval from dual;

insert into inventarios values(sec_inventarios.nextval,'Fc-002','30/10/2018','1','17','');

describe inventarios;

select *from productos;

select *from inventarios;

insert into inventarios values(sec_inventarios.nextval,'Fc-001','30/10/2018','1','35','');

insert into inventarios values(sec_inventarios.nextval,'Fc-001','30/10/2018','3','26','');

insert into inventarios values(sec_inventarios.nextval,'Fc-001','30/10/2018','4','30','');

insert into inventarios values(sec_inventarios.nextval,'Fv-001','31/10/2018','1','','3');

insert into inventarios values(sec_inventarios.nextval,'Fv-001','31/10/2018','3','','1');

insert into inventarios values(sec_inventarios.nextval,'Fv-002','31/10/2018','4','','3');

insert into inventarios values(sec_inventarios.nextval,'Fc-002','01/11/2018','5','60','');

insert into inventarios values(sec_inventarios.nextval,'Fc-002','01/11/2018','6','100','');

insert into inventarios values(sec_inventarios.nextval,'Fc-002','01/11/2018','2','36','');

insert into inventarios values(sec_inventarios.nextval,'Fv-003','02/01/2018','1','','1');

insert into inventarios values(sec_inventarios.nextval,'Fv-004','03/01/2018','5','','10');

insert into inventarios values(sec_inventarios.nextval,'Fv-005','03/11/2018','6','','47');

insert into inventarios values(sec_inventarios.nextval,'Fv-006','03/11/2018','1','','2');

select *from clientes;

select * from alquier;

select*from prendas;

select c.clinombre as nombre , c.cliapelldio as apellido , a.preprecio as precio from clientes c

inner join alquier a on c.cliid=a.cliid group by c.clinombre,c.cliapelldio,a.preprecio;

select c.clinombre as nombre , c.cliapelldio as apellido , a.alqfechasalida as "fecha de salida"

...