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,
[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 Date
and
Monitoring_Site_ID=XXX
order by Date