a month ago
a month ago
a month ago
comma after now
a month ago
where clause date step 7 equals today date , check the this part
a month ago
Hi @ajitkumar_a ,
The query is not syntactically correct
it should be like this
SELECT Customer Name,
SUM(Usage Amount) AS Total_usage_now,
SUM(Usage Cost) AS Total_usage_cost
FROM sheet1
GROUP BY Customer Name
and the main thing is write the SQL query in Text mode then it should be working fine.