SQL Sorgu Malzeme Stok Alış Satış Miktar ve Tutarları

SELECT "Ambar"."NAME" as "Ambar Adı", I."NAME" as "Malzeme Adı",
    Sum(ST."ONHAND") as "Fiili Stok", Sum(ST."PURAMNT") as "Satınalma Miktarı",
    Sum(ST."PURCASH") as "Satınalma Tutarı", Sum(ST."SALAMNT") as "Satış Miktarı",
    Sum(ST."SALCASH") as "Satış Tutarı"
FROM (SELECT STINVTOT.*, ORT_DEGER= CASE WHEN (SELECT ISNULL(SUM(ONHAND),0)
FROM LV_115_01_STINVTOT WHERE STOCKREF=ITEMS.LOGICALREF AND INVENNO=0) =0 THEN 0
ELSE ONHAND*AVGVALUE/(SELECT ISNULL(SUM(ONHAND),100000000000)
FROM LV_115_01_STINVTOT WHERE STOCKREF=ITEMS.LOGICALREF AND
(STINVTOT.DATE_<>'5-19-1919' AND INVENNO=0) AND STINVTOT.INVENNO IN (0,1,2,3,4,5))  END
FROM LG_115_ITEMS ITEMS LEFT OUTER JOIN LV_115_01_STINVTOT STINVTOT ON
    ITEMS.LOGICALREF=STINVTOT.STOCKREF WHERE STINVTOT.INVENNO IN (0,1,2,3,4,5)) ST
    left outer join "dbo"."LG_115_ITEMS" I ON (ST."STOCKREF" = I."LOGICALREF")
    left outer join (SELECT * FROM [L_CAPIWHOUSE]
WHERE FIRMNR='115') "Ambar" ON (ST."INVENNO" = "Ambar"."NR")
group by "Ambar"."NAME", I."NAME" order by "Ambar Adı", "Malzeme Adı"

SELECT "Ambar"."NAME" as "Ambar Adı", I."NAME" as "Malzeme Adı",
    Sum(ST."ONHAND") as "Fiili Stok", Sum(ST."PURAMNT") as "Satınalma Miktarı",
    Sum(ST."PURCASH") as "Satınalma Tutarı", Sum(ST."SALAMNT") as "Satış Miktarı",
    Sum(ST."SALCASH") as "Satış Tutarı"
FROM (SELECT STINVTOT.*, ORT_DEGER= CASE WHEN (SELECT ISNULL(SUM(ONHAND),0)
FROM LV_006_01_STINVTOT WHERE STOCKREF=ITEMS.LOGICALREF AND INVENNO=0) =0 THEN 0
ELSE ONHAND*AVGVALUE/(SELECT ISNULL(SUM(ONHAND),100000000000)
FROM LV_006_01_STINVTOT WHERE STOCKREF=ITEMS.LOGICALREF AND
(STINVTOT.DATE_<>'5-19-1919' AND INVENNO=0) AND STINVTOT.INVENNO IN (0,1,2,3,4,5))  END
FROM LG_006_ITEMS ITEMS LEFT OUTER JOIN LV_006_01_STINVTOT STINVTOT ON
    ITEMS.LOGICALREF=STINVTOT.STOCKREF WHERE STINVTOT.INVENNO IN (0,1,2,3,4,5)) ST
    left outer join "dbo"."LG_006_ITEMS" I ON (ST."STOCKREF" = I."LOGICALREF")
    left outer join (SELECT * FROM [L_CAPIWHOUSE]
WHERE FIRMNR='6') "Ambar" ON (ST."INVENNO" = "Ambar"."NR")
group by "Ambar"."NAME", I."NAME" 
HAVING (Sum(ST."PURAMNT")<>0)
order by "Ambar Adı", "Malzeme Adı"

Msg 156, Level 15, State 1, Line 12
Incorrect syntax near the keyword 'AND'.
Msg 102, Level 15, State 1, Line 17
Incorrect syntax near 'Ambar'.