select format(Event_DateTime,"yyyy-mm ") as Event_DateTime,
[Dissolved Oxygen] as DO,
DOSat as DOS,
[pH] as pH,
[Nitrate Nitrogen] as NO3,
[Ortho-phosphate] as OP,
[Settleable Solids] as SS,
[Total Alkalinity] as Alk,
[Water Temp] as WT,
[Specific Conductivity] as SC,
[WQI] as WQI,
[Ecoli3M] as EC,
Salinity as Sal,
EcoliIDEXX as ID
from QEvents
where Event_DateTime
and
Monitoring_Site_ID=XXX
order by Event_DateTime