There's a count difference between Druid Native Query and Druid SQL when using query

I have a problem with Druid Query.

I wanted to get data count with hour granularity.

So, I used Druid SQL like this.


This is a companion discussion topic for the original entry at https://stackoverflow.com/questions/73566059/theres-a-count-difference-between-druid-native-query-and-druid-sql-when-using-q