CREATE VIEW dbo.TOPLAM_SATIS_ADETLERI_VE_FATURA_SAYILARI_21
AS
SELECT        QQ.STOCKREF, QQ.YEAR_, QQ.ADET, QQ.FAT
FROM            ((SELECT        STOCKREF, YEAR_, SUM(AMOUNT) AS ADET, COUNT(INVOICEREF) AS FAT
                            FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                            WHERE        CANCELLED = 0 AND TRCODE = 8 AND LINETYPE = 0
                            GROUP BY STOCKREF, YEAR_)) QQ