select * from assignment
  where customer=$customer
  and start_date   < $end_period
  and $start_period < end_date