SELECT SiteId,Min(CountDate) As CountFromDate,Max(CountDate) As CountToDate
FROM t_Count
GROUP BY SiteId


//SELECT SiteId,Sum(h_0+h_1+h_2+h_3+h_4+h_5+h_6+h_7+h_8+h_9+h_10+h_10+h_11+h_12+h_13+h_14+h_15+h_16+h_17+h_18+h_19+h_20+h_21+h_22+h_23) As TotalCount
//FROM t_Count
//GROUP BY SiteId

SELECT SiteId,Sum(HourCount) As TotalCount
FROM v_Count
GROUP BY SiteId

SELECT SiteId,Sum(PageCount) As TotalPageCount
FROM t_Page
GROUP BY SiteId


SELECT SiteId, Max(HourCount) AS MaxCount, Max(CountDate) AS MaxDate
FROM v_Count
GROUP BY SiteId


SELECT SiteId,HourCount As YesterdayCount
FROM v_Count
WHERE CountDate=Date()-1


SELECT SiteId, HourCount AS TodayCount
FROM v_Count
WHERE CountDate=Date()


SELECT SiteId, HourCount AS MonthCount
FROM v_Count
WHERE CountDate>=DateSerial(Year(Date()),Month(Date()),1)


SELECT SiteId, HourCount AS YearCount
FROM v_Count
WHERE CountDate>=DateSerial(Year(Date()),1,1)