select 
  vnd.[Vendor Posting Group], 
  x.[No_], 
  x.SumOfAmount, 
  x.[SumOfAmount (EUR)], 
  x.[Siai Dienai], 
  vnd.[E-Mail],
  vnd.[Address 2],
  vnd.[Phone No_]    

from
  (
    select ldg.[No_],
      -Sum(dtl.Amount) AS SumOfAmount, 
      -Sum(dtl.[Amount (LCY)]) AS [SumOfAmount (EUR)] , 
      sd.[Siai Dienai]    
    from
      [DatabaseOne] ldg
      left join [DatabaseDetailed] dtl on ldg.[No_]=dtl.[Vendor No_]
      LEFT JOIN
      (
        SELECT
          ldg.[No_], 
          -Sum(dtl.[Amount]) AS [Siai Dienai] 
        from
          [DatabaseOne] ldg     
          left join [DatabaseDetailed] dtl on ldg.[No_]=dtl.[Vendor No_]  
        WHERE
          dtl.[Posting Date]<=cast(getdate() as date)  
        group by ldg.[No_]
     ) sd 
     on sd.[No_]=ldg.[No_]    

    where
      ldg.No_ not like 'KT%' and
      dtl.[Posting Date]<= '2020 – 07 - 31'  

    group by  
      ldg.[No_], 
      sd.[Siai Dienai] 
  ) x 
  LEFT JOIN 
  (
    SELECT 
      vnd.[No_], 
      vnd.[Vendor Posting Group], 
      vnd.[E-Mail], 
      vnd.[Address 2],
      vnd.[Phone No_], 
    FROM
      [DatabaseOne] vnd) vnd on vnd.[No_]=x.[No_]    
    where x.sumofamount is not null 
    order by x.[No_] 
  )   

SELECT 
    [Vendor No_], 
    COUNT ([Amount (LCY)]) AS 'One', 
    SUM ([Amount (LCY)]) AS 'Two'
FROM 
    [DatabaseDetailed]
WHERE
    [Applied Vend_ Ledger Entry No_] = '0'
    AND [Posting Date] BETWEEN '2020-01-01' AND '2020-07-31' 
    AND [Document Type] >= '2'
GROUP BY
    [Vendor No_]