On 2/19/2014 9:04 AM, Patrick Proniewski wrote:
For ISO = 100, I issue this request:SELECT strftime("%Y", datetime(CreateDate,"unixepoch")) as year, COUNT(ISO) FROM exifdata WHERE ISO = 100 AND year not null GROUP BY ISO, year ORDER BY year; That is correct, but not enough: the database includes pictures taken in 2014, none of which at ISO = 100, but I need a line "2014 0" in my output
select strftime(...) as year, sum(ISO=100) FROM exifdata GROUP BY year ORDER BY year; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
