addInObservationQuery function

Query to add a new column to indicate if a certain record is within the observation period