I want to execute a subquery using the current customer ID as I try to describe below
SELECT DISTINCT Customer_Id,
(SELECT SUM (total) FROM Orders where Customer_Id = Customer_Id AND CAST(Date) > DayIspecify )
FROM Orders where shop_id= '1-9THT'
What I want is to calculate the SUM each customer spent over a specified time period on the specific shop.
SELECT Customer_Id, SUM(total) SumTotal
FROM Orders
where shop_id= '1-9THT'
group by Customer_id
Not require subquery Try this:
SELECT Customer_Id,SUM(total)FROM Orders WHERE shop_id='1-9THT' GROUP BY Customer_Id
(Updated) Try:
select Customer_Id,
sum(case when o.shop_id = '1-9THT' and Date > DayIspecify
then total else 0 end) total
from Orders
group by Customer_Id
- to return all customers recorded on the Orders table, together with the values of any of their orders placed through shop 1-9THT after the date specified. (Change > to >= to make it on or after the date specified.)
Use SQL GroupBy
SELECT DISTINCT Customer_Id, SUM (total) FROM Orders where shop_id= '1-9THT' group by customer_Id
