SELECT
         Customers.EmailAddress
         ,COUNT(Orders.OrderID)   AS 'overall NumOrders'
         ,SUM(Orders.PaymentAmount)  AS 'overall TotalOrdered'
           ,COUNT(case when Orders.OrderDate >= '20170101' then Orders.OrderID  end) AS '2017 NumOrders'
        ,SUM(  case when Orders.OrderDate >= '20170101' then Orders.PaymentAmount end) AS '2017 TotalOrdered'
       ,COUNT(case when Orders.OrderDate BETWEEN ' 01/01/2015 00:00' AND '12/31/2015 23:59' THEN Orders.OrderID   end) AS '2015 NumOrders'
        ,SUM(case when Orders.OrderDate BETWEEN ' 01/01/2015 00:00' AND '12/31/2015 23:59' then Orders.PaymentAmount end) AS '2015 TotalOrdered'
         FROM Customers
     JOIN Orders ON Customers.Customerid = Orders.Customerid
    WHERE
    Orders.OrderStatus NOT IN ('Cancelled','Payment Declined')
    AND Orders.OrderDate BETWEEN ' 01/01/2015 00:00' AND getdate()
    GROUP BY
          Customers.EmailAddress

Emailaddress|overallnumorders|overalltotalordered|2017numorder|2017totalordered| 2015numorder|2015totalordered
xyz@gmail.com 1                    23.99            0             0                      1               23.99

SELECT
     Customers.EmailAddress
     ,COUNT(Orders.OrderID)   AS 'overall NumOrders'
     ,SUM(Orders.PaymentAmount)  AS 'overall TotalOrdered'
SUM((OrderDetails.Vendor_Price) * (OrderDetails.Quantity) ) AS TotalCost,
       ,COUNT(case when Orders.OrderDate >= '20170101' then Orders.OrderID  end) AS '2017 NumOrders'
    ,SUM(  case when Orders.OrderDate >= '20170101' then Orders.PaymentAmount end) AS '2017 TotalOrdered'
   ,COUNT(case when Orders.OrderDate BETWEEN ' 01/01/2015 00:00' AND '12/31/2015 23:59' THEN Orders.OrderID   end) AS '2015 NumOrders'
    ,SUM(case when Orders.OrderDate BETWEEN ' 01/01/2015 00:00' AND '12/31/2015 23:59' then Orders.PaymentAmount end) AS '2015 TotalOrdered'
     FROM Customers
 JOIN Orders ON Customers.Customerid = Orders.Customerid
JOIN Orderdetails ON Orders.Orderid=Orderdetails.Orderid
WHERE
Orders.OrderStatus NOT IN ('Cancelled','Payment Declined')
AND Orders.OrderDate BETWEEN ' 01/01/2015 00:00' AND getdate()
GROUP BY
      Customers.EmailAddress

Emailaddress|overallnumorders|overalltotalordered|totalcost|2017numorder|2017totalordered| 2015numorder|2015totalordered
 xyz@gmail.com          2           47.98             11.99          0             0                      2               47.98

Emailaddress|overallnumorders|overalltotalordered|totalcost|2017numorder|2017totalordered| 2015numorder|2015totalordered
    xyz@gmail.com 1                    23.99      11.99      0             0                      1               23.99