Dumb1SELECT week 'avg_year', week 'thesampleweek', thedate, rainevent, YEAR(thedate) 'avg_yearx', siteid, phosphatetotal 'avg_analysisOne', COUNT(phosphatetotal) 'avg_analysisOne_cnt', phosphate 'avg_analysisTwo', COUNT(phosphate) 'avg_analysisTwo_cnt', rain, observations, datanotes FROM hika_data_all_wk WHERE YEAR(thedate) = 2022 AND thedate > '2021-01-01 01:00:00' GROUP BY week, siteid Samples
LNRP/LWI-Manitowoc
Water Sampling Sites
2022
indicates Rain Event
prior week rain
All Samples
phosphatetotal and phosphate
Value with 2 decimal places
Surface Water Standards.pdf
_