zap sql: ilosc odslon i unikalnych odwiedzin wg dnia Opcje

[ds26]

witam,

chce wyciagnac ilosc_odslon, ilosc_unikalnych_wizyt, i date, wszystko posortowane dla kazdego dnia.
i wlasnie tutaj ugrzazlem.. dostaje :

ERROR: more than one row returned by a subquery used as an expression

to jest zapyanie:

select cast(clicked as date) as sort_date,
(select
count(*) as page_views,
(select count(distinct ip) from click_track where brand_id =3) as unique_visitors
from click_track y
where y.brand_id = 3)
from click_track x
where x.brand_id = 3
group by sort_date

jakies pomysly?

[ds26]

ok: wiec mam cos takiego:

select cast(clicked as date) as sort_date,
(select count(*) from click_track where brand_id =3) as page_views,
(select count(distinct ip) from click_track where brand_id =3) as unique_visitors
from click_track y
where y.brand_id = 3
group by cast(clicked as date)


ale nie bardzo dziala bo taki wynik dostaje:

sort_date | page_views | unique_visitors
------------+------------+-----------------
2007-02-09 | 70 | 14
2007-02-08 | 70 | 14
(2 rows)

8-go powinien byc tylko jeden page_view i unikalny..