actually,there was no null in my data.
show the correct data
ok,seems you use it without problem.
I can try your SQL in my TDengine 3.0.2.0 then feedback to you