Gilles Ganault <gilles.ganault@...> writes:
SELECT a.zip, a.cnt_people_in_town, b.cnt_all_people ( SELECT zip, COUNT(zip) AS cnt_people_in_town FROM people GROUP BY zip ) a CROSS JOIN ( SELECT COUNT(zip) FROM people AS cnt_all_people ) b ; percent for you greetings oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
