SELECT COUNT(*)
  FROM Company_relationship
 WHERE effective_date  = ?
    OR expiration_date = ?

##</code><code>##

SELECT COUNT(*)
  FROM Company_relationship
 WHERE effective_date <= ?
   AND expiration_date > ?