 
          AND (AttributeCategoryName ISNULL or  AttributeCategoryName!= 'Groundwater')
 
+	  	  
          GROUP BY ResourceTypeAcronym,AttributeName,ScenarioName,AggregationStatisticCV,IntervalTimeUnitCV,UnitNameCV,UnitName,
          YearType,strftime('%Y', WaterYearDate)
-
 
 
          --close the second Select statement         

--Users need to check on the unit name to perform a conversion like from cfs to af/month

Adel Abdallah
Updated June 12, 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

