Grouping by a date in a timestamp depending on time zone

This is my query:

Grouping by a date in a timestamp depending on time zone

This is my query:

Grouping by a date in a timestamp depending on time zone

This is my query:

How to have a row always on top even when using OFFSET?

I’m using Postgres.