RobAWilkinson · December 31, 2015 01:04
diff --git a/lower_range.sql b/lower_range.sql
 SELECT start_date, duration 
 FROM assignments 
 WHERE start_date < '2016-01-26' 
  AND start_date + duration < '2016-01-26' 
 ORDER BY start_date DESC;
diff --git a/upper_range.sql b/upper_range.sql
 SELECT end_date, duration 
 FROM assignments 
 WHERE end_date > '2016-01-29' 
  AND end_date - duration > '2016-01-29' 
 ORDER BY start_date DESC;