A
AK177
Hi, I am trying to write SQL language for a complex sum query. I have a
dataset with many columns, including PRECIP (precipitation for a specific
month), MON (month), YEAR, and HRU. I want to find the total PRECIP between
June and August (where MON between 6 and 8) for each HRU within each year.
For example, for HRU=1 and YEAR=2002, I want to determine total PRECIP where
MON between 6 and 8. I also want to determine total PRECIP for HRU=1 and
YEAR=2003...and total PRECIP for HRU=2 and YEAR=2002, etc, etc.
Can you help me with writing the proper language for this?
Thanks
dataset with many columns, including PRECIP (precipitation for a specific
month), MON (month), YEAR, and HRU. I want to find the total PRECIP between
June and August (where MON between 6 and 8) for each HRU within each year.
For example, for HRU=1 and YEAR=2002, I want to determine total PRECIP where
MON between 6 and 8. I also want to determine total PRECIP for HRU=1 and
YEAR=2003...and total PRECIP for HRU=2 and YEAR=2002, etc, etc.
Can you help me with writing the proper language for this?
Thanks