Case 3

  • Count number of unique SHARP numbers (regions) for each day of particular time period
  • Time range: 2002-03-10 to 2012-03-25
  • This case uses aggregation functions so it might use a little bit longer time than other cases.