Exercício Prático do Nível 2G - Banco de Dados Básico

Azul = Select
Verde = View

CREATE VIEW VGFTRE_ESTOQUE
AS
SELECT EST.CODPROD,PRO.DESCRPROD,EST.CONTROLE,SUM(EST.ESTOQUE) AS QTD_EST
FROM TGFEST EST,TGFPRO PRO
WHERE EST.CODPROD=PRO.CODPROD
GROUP BY EST.CODPROD,PRO.DESCRPROD,EST.CONTROLE
HAVING SUM(EST.ESTOQUE) >= 100 
ORDER BY CODPROD ASC
WITH READ ONLY




SELECT * 
FROM VGFTRE_ESTOQUE
ORDER BY QTD_EST ASC

DROP VIEW VGFTRE_ESTOQUE