Code:
data in myTable

id    date         ip
(1)  20050721 211.224.44.125 
(2)  20050721 211.224.44.125 
(3)  20050721 61.74.86.141 
(4)  20050721 220.89.253.152 
(5)  20050722 220.89.253.152 
(6)  20050722 220.89.253.152 
(7)  20050722 220.89.253.152 
(8)  20050723 211.224.44.125 
(9)  20050723 220.89.253.152 
(10) 20050723 61.74.86.141

code

select date
     , count(distinct ip) as visitors
     , count(*) as pageViews
      from myTable
group
    by date


result

date   visitors pageViews
20050721  3        4
20050722  1        3
20050723  3        3
I can produce the above result by the above code with the above data in myTable.


How can I get the total recordCount of date, visitors and pageViews like the following quote--especially the total recordCoun of visitors.

The total recordCount of date is '3.'
The total recordCount of visitors is '7.'
The total recordCount of pageViews is '10.'

I like to use the total recordCounts above in making the following target.

Code:
date   visitors pageViews
20050721    3      4
20050722    1      3
20050723    3      3
--------------------
     3      7     10 --- total