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’