Query: Companies with more than one assistant

1 )"> 1 )"> 1 )">

SELECT * FROM companies
WHERE companies."id" IN (
  SELECT "companyId" FROM assistants
  WHERE "deletedAt" is NULL
  GROUP BY "companyId"
  HAVING count(*) > 1
)