Diana Shealy diana-shealy

## snapshot_by_day.sql
SELECT
   TD_TIME_FORMAT(time, ‘yyyy-MM’) as MONTH,
   category,
   usage
FROM usage_snapshot
WHERE TD_TIME_RANGE(time, ‘2016-04-01’)

## snapshot_max.sql
SELECT
   TD_TIME_FORMAT(time, ‘yyyy-MM’) as MONTH,
   category,
   MAX(usage) as total_max_usase
FROM usage_snapshot
	SELECT
	TD_TIME_FORMAT(time, ‘yyyy-MM’) as MONTH,
	category,
	usage
	FROM usage_snapshot
	WHERE TD_TIME_RANGE(time, ‘2016-04-01’)