eng_active.sql

SELECT * FROM google_hire.list_applications AS app
 JOIN google_hire.list_candidates AS can
 ON app.candidate = can.name
 WHERE app.tenant = 'my_tenant'
 AND app.filter='status.state=ACTIVE'
 AND can.tenant = 'my_tenant'
 AND can.filter='applications.status.state=ACTIVE'
 AND job = (SELECT name FROM google_hire.list_jobs
   WHERE tenant='my_tenant'
   AND filter='state=OPEN'
   AND title='Software Engineer')