SELECT COUNT(ID) AS intX, Keyword,

COUNT(CASE WHEN IsOrder=1 THEN ID END) AS intY,

SUM(Amount) AS Total FROM tblTrack

WHERE Sites_ID=" & session("SiteID") & "

AND DateTime >= '" & StartDate &...