SQL - Descripcion o interpretacion de estas query

SET timezone TO 'America/Bogota';

-- Sabe above but only for current date

SELECT (o.created_at::timestamp AT TIME ZONE 'GMT-0')::DATE fecha, state, count(*)

FROM orders o

inner join stores s on o.store_id = s.id

where s.id in  (900048991, 900035152, 900035156, 900035157, 900035176, 900035177, 900035178, 900035179, 900035180, 900035181, 900037063, 900037064, 900037065, 900037066, 900037068, 900037070, 900037071, 900037072, 900037073, 900037074, 900037075, 900037076, 900037077, 900037078, 900037079, 900037080, 900037081, 900037082, 900037083, 900037084, 900037085, 900037086, 900037087, 900037091, 900037093, 900037094, 900037095, 900037097, 900037098, 900037099, 900037100, 900037102, 900037103, 900037104, 900037105, 900037106, 900037107, 900037108, 900037110, 900037111, 900037112, 900037115, 900037116, 900037117, 900037118, 900037119, 900037120, 900037121, 900037122, 900037123, 900037124, 900037125, 900037126, 900037127, 900037128, 900037129, 900037130, 900037134, 900037135, 900037136, 900037137, 900037138, 900037139, 900037140, 900037141, 900037142, 900037143, 900037144, 900037145, 900037146, 900037147, 900037148, 900037149, 900037150, 900037151, 900037152, 900037153, 900037154, 900037155, 900037156, 900037157, 900037158, 900037159, 900037160, 900064009, 900064010, 900066776, 900080041, 900082035, 900082036, 900082037, 900090447, 900099033, 900099034, 900099035)

and o.created_at >= ([now():brt:date] - interval '8 days' + interval '3 hours')

GROUP BY 1,2

SELECT o.store_id,

       o.id,

CASE

           WHEN o.state = 'ERROR' THEN '3-ERROR'

           WHEN o.state = 'SENT' THEN '2-WAITING'

           WHEN o.state = 'FINISHED' THEN '1-SUCCESS'

           WHEN o.state = 'READY_FOR_FALLBACK' THEN '4-FALLBACK'

           WHEN o.state = 'CANCELLED' THEN '5-CANCELLED'

           ELSE '6-OTHERS'

       END,

       o.created_at::TIMESTAMP AT TIME ZONE 'GMT-5',

       o.operation_notes

FROM orders o

WHERE o.created_at AT TIME ZONE 'GMT-5' >= now()::DATE AT TIME ZONE 'GMT-5' - interval '1d'

  AND o.state not in ('FINISHED', 'SENT')

ORDER BY 4 DESC