SELECT WRec.StationName, WRec.DateTimeUTC , AVG(WRange.QAQC_Conc) AS R24Hr_Conc, COUNT(WRange.QAQC_Conc) AS R24Hr_Count , Min(WRange.DateTimeUTC) AS MinUTC, Max(WRange.DateTimeUTC) AS MaxUTC , Max(WRange.QAQC_Conc) AS MaxConc, Min(WRange.QAQC_Conc) AS MinConc FROM QAQCData WRec JOIN QAQCData WRange ON WRec.StationName=WRange.StationName AND DATEDIFF(hour,WRange.DateTimeUTC, WRec.DateTimeUTC ) BETWEEN 0 AND 23 AND WRange.IsValidData=1 WHERE LTRIM(RTRIM(WRec.StationName)) LIKE LTRIM(RTRIM(@StationName)) GROUP BY WRec.StationName, WRec.DateTimeUTC ORDER BY WRec.DateTimeUTC DESC
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter