title: Query Select in SQL postgres
body: <p>We need help to use a command in "SELECT" to return the following information from a bank in PostgreSQL.</p>
  
  <p>"Terminals that had 10 or more occurrences, within 1 hour, with the same user, service, and terminal".</p>
  
  <p>We have the table <strong>TB_TRANSACOES</strong>:</p>
  
  <pre><code>Id bigserial NOT NULL,
  Dh_transaction timestamp NOT NULL,
  Nu_account bigint NOT NULL,
  Nu_value bigint NOT NULL,
  Co_terminal character varying NOT NULL,
  Co_service character varying NOT NULL,
  Co_user character varying NOT NULL,
  CONSTRAINT tb_transacoes_pkey PRIMARY KEY (id)
  </code></pre>
  
  <p>We have only this part:</p>
  
  <pre><code>SELECT * FROM TB_TRANSACOES WHERE CO_TERMINAL &gt;= 10
  </code></pre>
  
  <p>I'll be grateful.</p>