I do not know how to resolve these two queries:
The first query would be like this? there is no other way to put it that lasts 3 months exact, I say it by 30.31s
SELECT ID_PRODUCTO FROM PRODUCTOS
WHERE ID_PRODUCTO IN ( SELECT ID_PRODUCTO FROM PEDIDOS
WHERE FECHA>SYSDATE-90)
The 6 would be something like this:
select * from PRODUCTOS left join PEDIDOS on PRODUCTOS.ID_PRODUCTO = PEDIDOS.ID_PRODUCTO where month(PEDIDOS.FECHA)>9;
La 7:
select sum(PEDIDOS.CANT), count(PEDIDOS.ID_PEDIDO) from PEDIDOS inner join PRODUCTOS on PEDIDOS.ID_PRODUCTO = PRODUCTOS.ID_PRODUCTO where PRODUCTOS.DESCRIPCION = "Televisor M1";