 --Users need to check on the unit name to perform a conversion like from cfs to af/month
 
 Adel Abdallah
-Updated June 12, 2018
+Updated June 21, 2018
 */
 
 SELECT ResourceTypeAcronym,ScenarioName,AttributeName,AttributeName_Abstract,AttributeNameCV,AttributeCategoryName, AggregationStatisticCV,IntervalTimeUnitCV,UnitNameCV,UnitName,


-- exclude the years that have less than 12 months (which will have a null value here because of the case above)
WHERE CumulativeAnnual is not null


         AND (AttributeCategoryName ISNULL or  AttributeCategoryName!= 'Groundwater')

	  	  
         GROUP BY ResourceTypeAcronym,AttributeName,ScenarioName,AggregationStatisticCV,IntervalTimeUnitCV,UnitNameCV,UnitName,
         YearType,strftime('%Y', WaterYearDate)


         --close the second Select statement         
