cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Getting SQL error in recipe

ajitkumar_a
Deputy Chef I
Deputy Chef I
 

Screenshot 2025-06-17 130333.png

5 REPLIES 5

ajitkumar_a
Deputy Chef I
Deputy Chef I

Screenshot 2025-06-17 131940.png

1dheeraj2
Deputy Chef III
Deputy Chef III

comma after now 

1dheeraj2
Deputy Chef III
Deputy Chef III

where clause date step 7 equals today date , check the this part

Bhagya_pola
Deputy Chef III
Deputy Chef III

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.