On Jul 7, 2008, at 4:37 PM, Milan Nikollic wrote: > > SELECT > COUNT(visitor_id) AS num_visits, > human_year AS year, > human_month AS month, > human_day AS day, > (SELECT COUNT(DISTINCT ip_address) FROM nm_visitors AS aaa > WHERE aaa.human_year = bbb.human_year > AND aaa.human_month = bbb.human_month > AND aaa.human_day = bbb.human_day) AS num_unique_visits > FROM nm_visitors AS bbb > GROUP BY human_year, human_month, human_day > ORDER BY date DESC LIMIT 20 >
D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
