Influx distinct examples

Select movementCounter from ruuvi_measurements where mac='D48B9C6C230E' and 
time > '2022-11-11T10:37:00-05:00' and time < '2022-11-27T12:13:29-05:00' tz('America/New_York')
2022-11-11T10:37:41.999623272-05:00 -88  254
2022-11-11T10:45:11.862486176-05:00 -81  254
2022-11-11T11:07:05.394804120-05:00 -88  1
2022-11-11T11:19:36.354201988-05:00 -92  1
2022-11-11T13:00:47.016186188-05:00 -86  1
2022-11-11T13:09:49.309046669-05:00 -72  1
2022-11-11T13:15:06.133193087-05:00 -82  1
2022-11-27T12:12:23.547486663-05:00 -89  104
2022-11-27T12:12:51.260810966-05:00 -88  104
2022-11-27T12:13:24.308344006-05:00 -86  104

> select rssi,distinct(movementCounter) from ruuvi_measurements 
ERR: aggregate function distinct() cannot be combined with other functions or fields

> select distinct(movementCounter) from ruuvi_measurements where mac='D48B9C6C230E' and 
time>'2022-11-11T10:15:06-05:00' and time <'2022-11-27T12:13:29-05:00' limit 600  tz('America/New_York')
name: ruuvi_measurements

time                                distinct
----                                --------
2022-11-11T10:15:06.000000001-05:00 254
2022-11-11T10:15:06.000000001-05:00 1
2022-11-11T10:15:06.000000001-05:00 104

influx