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