SQL

postgresql substring

SELECT substring('w3resource' from 4 for 5);

sub query postgres

select id, ten_minute_interval
from (
  select to_timestamp(floor((extract('epoch' from CREATED_AT) / 600 )) * 600) as ten_minute_interval
  , id
  from TABLE_NAME
) as nested
where ten_minute_interval >= 'TIMESTAMP'

subquery postgresql syntax

# In Where Clause
# In From Clause
# In Select Clause