I executed a query in TDengine.
My SQL statement is :
select count(distinct id_number) from attendance where project_number = "202201130002" and attendance_mark = "1" group by id_number;
It reported an error:
DB error: syntax error near "distinct id_number) from attendance where project_number = "202201130002" and attendance_mark = "1" group by id_number;" (0.000143s)
Is there any syntax error in this sentence? How should I write it?