select.sql

SELECT t.test_id, t.run_count, t.success, t.failure, t.run_time
FROM tests t
JOIN test_runs tr   
  ON t.id = tr.test_id 
JOIN run_metadata rm
  ON rm.run_id = tr.run_id
  AND rm.key = 'build_name'     
  AND rm.value = 'gate-tempest-dsvm-postgres-full'
GROUP BY t.test_id, t.run_count, t.success, t.failure, t.run_time

WHERE tr.start_time >= DATE('2015-09-01 01:00:00') 
  AND tr.stop_time <= DATE('2015-09-01 02:00:00')
GROUP BY t.test_id, t.run_count, t.success, t.failure, t.run_time